topic Re: above(total(expression)) not prodcuing desired result. in QlikView

above(total(expression)) not prodcuing desired result.

Thu, 18 Sep 2014 08:43:34 GMT

Hi,

PFA - I have a dimension called department. I need to find various analysis using salary in the expression. When I try to find out total salary, irrespective of the department (means for whole organization), I was left with choice to use Set Analyis. Can we also use above(total()) as an alternative?

I need to correct my understanding on how above(total()) works. From help file it says: " if the expression is preceded by the total qualifier, the current column segment is always equal to the entire column". So, my understanding is using above(total(sum(salary))) gives the total salary of the organization a whole. I am sorry I am failed to interpret the help file's line.

But, neither sum({1} salary) nor above(total(sum(salary))) expression gives me the correct result. Additionally, I would be highly thankful if you please explain how above(total()) works.

Thanks!

Re: above(total(expression)) not prodcuing desired result.

MK_QSL — Thu, 18 Sep 2014 08:48:35 GMT

1) If you want TOTAL Salary irrespective of Department, you can use....

SUM(ALL salary)

SUM(TOTAL salary)

2) If you want TOTAL Salary Department wise... use below

RangeSum(Above(SUM(TOTAL <department> salary),0,RowNo(TOTAL)))

Re: above(total(expression)) not prodcuing desired result.

jonathandienst — Thu, 18 Sep 2014 08:55:55 GMT

I think you just need:

Sum(TOTAL salary)

The total qualifier in the sum means ignore the dimension.

HTH

Jonathan

Re: above(total(expression)) not prodcuing desired result.

MK_QSL — Thu, 18 Sep 2014 09:00:28 GMT

even for 2nd answer... you don't need RangeSum...

You can simply write...

SUM(TOTAL <department> salary)