topic Re: Setting a filter within a table in QlikView

Setting a filter within a table

cmccafferty — Tue, 18 Sep 2018 15:48:27 GMT

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?

Re: Setting a filter within a table

vamsee — Tue, 18 Sep 2018 16:05:38 GMT

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

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

(not recommended)

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

Re: Setting a filter within a table

cmccafferty — Wed, 19 Sep 2018 11:22:36 GMT

Sorry not quite sure where to put this formula in.

Re: Setting a filter within a table

vamsee — Wed, 19 Sep 2018 14:08:22 GMT

In the expressions.

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