Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
Thanks friend.
Yes it is chart table option.
So, would I apply that to the expression.. on the definition bit?