Discussion Board for collaboration on QlikView Scripting.
Im struggling on how to calculate the above.
I would also like to know that if I was to add conditions in set analysis i.e. Skill = 1 only if I would have to do it differently.
Go to Solution.
Expression for Difference against total average : =Avg(TOTAL [Avg Score])-[Avg Score]
Expression for Above / Below : =if([Difference against total average]<=0,'Below','Above')
Check the Attachment
You can reference the existing expression names in the new expression in the straight table.
So you can use the expressions suggested by settu.periyasamy