This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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.
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
View solution in original post
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