Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
cmccafferty
New Contributor II

Setting a filter within a table

Hi,

Is it possible that i can write something into my table, so that only values where [BD SellingCurrency] = 'CAD' is shown on the list of bookings that gets returned?

qv1.png

Tags (2)
3 Replies
vamsee
Valued Contributor

Re: Setting a filter within a table

As you have multiple Dimensions. Try creating the condition in your expressions.

{< [BD SellingCurrency] = {'CAD'} >}

Or

(not recommended)

Add Calculated Dimension IF( [BD SellingCurrency] = 'CAD' , [BD SellingCurrency] )

cmccafferty
New Contributor II

Re: Setting a filter within a table

Sorry not quite sure where to put this formula in.

vamsee
Valued Contributor

Re: Setting a filter within a table

In the expressions.

You can post your expression for me to help you with it.