topic Re: condition dimnesion in QlikView

condition dimnesion

Anonymous — Sun, 21 Jul 2013 05:13:39 GMT

hi,

i have pivot with dimension name "kodbreak",

i don't want to show kodbreak num - 1052,1058,1111.

i wrote at enabeld conditinal - kodbraek<> 1052,1058,1111

but nothing heppend.

what i did wrong ?

thanks'

yarin.

Re: condition dimnesion

priyav24 — Sun, 21 Jul 2013 05:52:48 GMT

Hi,

Try this,

=if(kodbreak<> 1052,1058,1111,

kodbreak)

in the calculated dimension

Re: condition dimnesion

Gysbert_Wassenaar — Sun, 21 Jul 2013 09:54:45 GMT

The conditional expression is for showing or hiding the entire dimension, not hiding some values but still showing the column. If you want to hide some values you have to use a calculated dimension:

if(match(kodbreak,1052,1058,1111), null(), kodbreak)

You'll also want to enable the Suppress When Values Is Null option of the calculated dimension.