Filtering data in just one table only - Qlikview

[cmccafferty]

Hi Guys,

Just wondering if this is possible.

I have two tables on a tab.. one shows all bookings in local currency, and I want an identical one to show all bookings made in Canadian Dollars.

Is this possible?

[mireland]

Have you tried using set analysis for this? Assuming you are using the chart table option, you could add an expression  that is something like this

count({1<Currency = {'GBP'}>}booking)

Here is the link on  Set Analysis from Qlik Help

[cmccafferty]

Thanks friend.

Yes it is chart table option.

So, would I apply that to the expression.. on the definition bit?