Discussion Board for collaboration related to QlikView App Development.
I have a data file as shown on the left, i would like to display it in a pivot table as shown on the right.
My question is how do i selectively display the price according to the Volume.
e.g. For Prod1, Cust1 and S1, there are two rows, shown as below. I only want to display the price (0.352) which has bigger volume.
Thank you in advance for your help!
Try something like
=FirstSortedValue(DISTINCT Price, -Volume)
as your expression with the three dimensions mentioned above.
View solution in original post
Thank you, swuehl. It works.