Trying to get only selected values

[#1]

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?

[christophebrault]

Hi,

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

Or show us your expressions in the graph plz.

[#3]

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?

[christophebrault]

Ok nice.

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