Hi,
I have a pivot table with 4 cols (As Dimensions) and 6 expressions. The users would like to initially see all the data. Then as they wish they would like to filter the data.
Lets assume I have the following fields in my table and all the values for those fields are displayed after load. Note Ccypair and client are dimensions and the other two are expressions so that users can group by CcyPair and Client.
CcyPair Client TradeCount NotionalAmount
Now, the user might want to filter values based on the following conditions.
1. Show top 10 trades with highest notional amount. Within this result, user might want to filter only ccypair which has a value EURUSD.
2. Another scenario, user might want to display all rows where TradeCount > 100
and so on..
Can somebody please give me an example of how to do this?
PS: I use QlikView v11.
Cheers