topic Re: how to hide specific values in a dimension? in QlikView

how to hide specific values in a dimension?

chriscools — Wed, 05 Dec 2012 07:12:39 GMT

Hello,

i have a table with 1 dimension and a few expressions.

the dimension has 5 different values, but i would only to show 3 of them.

do i make a calculated dimension for this? and how would i then exclude the 2 values i don't want?

thanx!

chris

sivarajs — Wed, 05 Dec 2012 07:20:03 GMT

Create calculated dimension like

if( not wildmatch(Dimension,'*Val1*','*Val2*'),Dimension)

if(Dimension<>'Val1' or Dimension<>'Val2',Dimension)

chriscools — Wed, 05 Dec 2012 11:19:07 GMT

Hello,

the first solution worked, but the second dit not .

(there the values for the dimension got a different sorting, but nothing else happened)

thanx!

chris