Filtering in straight table

Fri, 21 Sep 2012 03:32:27 GMT

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

topic Filtering in straight table in QlikView

Filtering in straight table