Qlikview：tablebox或straight / pivot，它将显示最小值和最小值的相关值 [英] Qlikview: tablebox or straight/pivot which would show minimum value and related value of the min value

问题描述

这让我疯了。
说我有大量的产品名称，价格和价格来源的清单：
产品，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$, USA Product, 2€, EU Product, 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，它将显示最小值和最小值的相关值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！