Hi,
I have a pivot table with the columns as shown in the attached image. By default my pivot table is grouped by CcyPair column.
What I would like is to allow users to limit their display on the pivot table dynamically. For eg. I want users to enter value 10 in an input box and then the pivot table must only show the top 10 CcyPairs which has the highest "USD Ntl" total.
Next, lets assume we already are displaying top 10 ccypairs with highest usd notional as per previous filter. What I would also like to do is allow users to enter a value so that now it displays all CcyPairs which has a total 'Trade Count' greater than 100.
Can somebody please show this with an example?
PS: Im using QlikView v11
Updated:
Please note that each ccypair when expanded might have multiple trade id's, counterparties. So this result should not be impacted by the top n selection
Cheers