topic Re: Calculated Dimension in QlikView

Calculated Dimension

evansabres — Tue, 29 Aug 2017 17:26:42 GMT

I am attempting to create a calculated dimension.

I want my field to display the 'PriceLevel' when it is not equal to the following:

'100 Preferred Rinkside'

'100 Level II Rinkside'

'100 Level III Rinkside'

'Hockey Suite'

I attempted

=if(PriceLevel <> '100 Preferred Rinkside' or PriceLevel <> '100 Level II Rinkside' or PriceLevel <> '100 Level III Rinkside' or PriceLevel <> 'Hockey Suite', PriceLevel)

However, this seems to only remove the '100 Preferred Rinkside'

Am I structuring this incorrectly?

Re: Calculated Dimension

its_anandrjs — Tue, 29 Aug 2017 17:37:51 GMT

Then write

=If( NOT Match( PriceLevel ,'100 Preferred Rinkside','100 Level II Rinkside','100 Level III Rinkside','Hockey Suite') PriceLevel)

Re: Calculated Dimension

evansabres — Tue, 29 Aug 2017 17:40:12 GMT

Thanks!