Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
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?