topic Re: conditional in pivot table in QlikView

conditional in pivot table

volakakis — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: conditional in pivot table

maxgro — Wed, 30 Nov 2016 17:49:35 GMT

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

Re: conditional in pivot table

volakakis — Wed, 30 Nov 2016 17:51:30 GMT

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