Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Selectively display data in a pivot table

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.

data.PNG  table.PNG

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.

example.PNG

Thank you in advance for your help!

1 Solution

Accepted Solutions
MVP
MVP

Re: Selectively display data in a pivot table

Try something like

=FirstSortedValue(DISTINCT Price, -Volume)

as your expression with the three dimensions mentioned above.

View solution in original post

2 Replies
MVP
MVP

Re: Selectively display data in a pivot table

Try something like

=FirstSortedValue(DISTINCT Price, -Volume)

as your expression with the three dimensions mentioned above.

View solution in original post

Not applicable

Re: Selectively display data in a pivot table

Thank you, swuehl. It works.