topic Calculate difference to Total average expression in QlikView

Calculate difference to Total average expression

Wed, 03 Feb 2016 16:26:59 GMT

Name	Skill	Avg Score	Difference against total average	Above/Below
		2.82	How do I make this column?
Name 1	1	2.50	=2.82-2.50 (Column should show 0.32)	Above
Name 2	2	3	=2.82-3 (Column should show -0.18)	Below
Name 3	1	3	=2.82-3 (Column should show -0.18)	Below
Name 4	2	2.80	=2.82-2.80 (Column should show 0.02)	Above

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.

Best,

Mav

settu_periasamy — Thu, 04 Feb 2016 02:22:40 GMT

Hi,

Try this..

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

Thu, 04 Feb 2016 03:42:37 GMT

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‌