topic Finding a specific row number after sorting in QlikView

Finding a specific row number after sorting

Thu, 18 Nov 2010 20:18:31 GMT

I have a table with the following columns, Product class, Stock Code Number, Sales Order Number, Transaction Date and Gross Margin. There are 40 different Product Classes

We want to see, by Product Class, what is the Gross Margin at 5% of the line items and 10% of the line items, with Gross Margin sorted from worst to best. So, for example, if Product Class X has 100 total lines I want to first sort the list from worst to best Gross Margin and report what the margin is at line 5 (5% times 100 lines) and line 10 (10% times 100 lines).

Any ideas?

Thanks,

Stephen

Finding a specific row number after sorting

Thu, 18 Nov 2010 20:56:51 GMT

Hi,

Just use as expression


=fractile(GrossMargin , 0.05) for the5% line
=fractile(GrossMargin , 0.01) for the 10% line

with Product Class as dimension

Finding a specific row number after sorting

Thu, 18 Nov 2010 21:24:36 GMT

This returns nothing.