Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

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

3 Replies
Highlighted
Specialist
Specialist

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] )

Highlighted
Contributor III
Contributor III

Sorry not quite sure where to put this formula in.

Highlighted
Specialist
Specialist

In the expressions.

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