topic Re: Trying to get only selected values in QlikView

Trying to get only selected values

Thu, 31 May 2012 10:29:31 GMT

Hi I am trying to get Qlikview to only show a selection of the data, here shown by the number 1 with only 29 in Klasse A for example. I have manged to get as far as you can see below, but it also shown values that are not from the dimension.

The dimension is Misligholdte which is a dummy (0,1)

How do I get to show only the values associated with Mislighold = 1?

Trying to get only selected values

christophebrault — Thu, 31 May 2012 10:38:28 GMT

Hi,

In you chart \ Dimensions, try to check suppress if null value for your dimension.

Or show us your expressions in the graph plz.

Re: Trying to get only selected values

Thu, 31 May 2012 10:51:47 GMT

That was it!

=if (Misligholdte <> '0',Misligholdte)

is the expression I used in the calculated dimension.

Is there a way to hide the first column, as I don't need to show this value?

Trying to get only selected values

christophebrault — Thu, 31 May 2012 11:26:30 GMT

Ok nice.

If you are working on a simple table chart, you can go in Presentation, select your column and check hide column.