conditional in pivot table

[volakakis]

Hi to all (really excited because I am really new to QlikView)

I have created a pivot Table as you can see here

now I have a question:

in the expression Stats (which is column (Correct)/(next column)) is there a way that I can keep only the result if the value is 1 and if not then there will be no result?

Thank you all in advance

[maxgro · Accepted solution]

try

if(     (Correct)/(next column))  = 1,      (Correct)/(next column)) )

another option is in "Visual Cues" tab

you can set the color white or tranparent when your expression is >= 1.0001 and when is <= 0.9999

The first option changes the value

The second hides the values

[volakakis]

I dont want to hide the values because in the next step I want to aggregate all 1 so I will use the first option... Thank you very much