topic Filtering data in just one table only - Qlikview in QlikView

Filtering data in just one table only - Qlikview

cmccafferty — Sat, 16 Nov 2024 05:09:03 GMT

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 — Fri, 23 Nov 2018 18:00:55 GMT

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 — Fri, 23 Nov 2018 20:03:57 GMT

Thanks friend.

Yes it is chart table option.

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