Qlikview：tablebox或straight / pivot，它将显示最小值和最小值的相关值

问题描述

这让我疯了。
说我有大量的产品名称，价格和价格来源的清单：
产品，1 $，美元
产品，2€，欧元
产品， 0.5€，HK

This is driving me nuts.Say I have a mass of lists with product names, their prices and the origins of the pricing:Product, 1$, USAProduct, 2€, EUProduct, 0.5€, HK

获得此结果的正确表格配置是什么，而不重复相同产品名称的记录？：
产品0.5€HK

What is the correct table configuration to get this result, without duplicating the record of the same product name?:Product 0.5€ HK

也就是说该表计算最低价格并显示最低价格的正确来源？

That is to say the table calculates the minimum price and shows the correct origin for the minimum price?

I或者获得所有扩展的枢轴重复产品或产品原产地归还伪造。
Excel的数据透视表没有显示重复的行，简单的索引和匹配函数工作得很快，但我希望这两个计算在Qlikview中成功完成。

I either get all expanded pivot dupe products or the product origin is returned bogus.Excel's pivot does not show duplicate rows, and the simple index and match functions work fast, but I want the two calculations to be done within Qlikview with success.

请帮助，
-v

Please help,-v

推荐答案

您需要在应用程序的脚本部分执行此操作。

You need to do this in the scripting portion of the app.

首先，您需要建立产品清单及其最低价格

First you need to build a list of the Products and their minimum prices

 LOWEST_PRICES:
 Load Product_ID,
      min(Selling_Price) as Min_Price
 resident SOURCE_TABLE
 group by Product_ID;

然后您将使用最低价格和product_ID的组合来加入返回源位置到桌面上

and then you are going to use that combination of the minimum price and the product_ID to join back source location onto the table

left join
Load Product_ID,
     Selling_Price as Min_Price,
     Source_Location
Resident SOURCE_TABLE;

然后您可以让QlikView与原始表中的Product_ID关联，它将始终返回一个Source_Location和一个Min_Price

Then you can just let QlikView associate to the Product_ID from the original table and it'll always return one Source_Location and one Min_Price

这篇关于Qlikview：tablebox或straight / pivot，它将显示最小值和最小值的相关值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！