Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Filtering data in just one table only - Qlikview

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?

 

Labels (3)
2 Replies
Highlighted
Contributor II
Contributor II

Re: Filtering data in just one table only - Qlikview

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

Highlighted
Contributor III
Contributor III

Re: Filtering data in just one table only - Qlikview

Thanks friend.

Yes it is chart table option.

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