topic Re: Using set analysis within abvove function in QlikView

Using set analysis within abvove function

Fri, 19 Dec 2014 07:27:09 GMT

Hi,

I have a requirement wherein I need to calculate the sum of the above 3 rows as my 4th row for which I am using above function and it seems to be fine but the problem is when I make a selection on the year it is turning out to be zero which is not correct and hence I believe if I can use set analysis and bypass the selections I can achieve the desired results. So please guide on how to go with it

Expression currently used is

=if(BS_No=50,above(Column(1),1)+above(Column(1),2)+above(Column(1),3),
if(BS_No=100,above(Column(1),1)+above(Column(1),2)+above(Column(1),3),
if(BS_No=120,above(Column(1),2)-above(Column(1),7),
if(BS_No=10 or BS_No=60 or BS_No=110 or BS_No=130,' ',

sum( $(vSet),FY = {"$(vPrevYear)"},[Month Name]=>} AMOUNT)/Denominator))
))

Re: Using set analysis within abvove function

tresB — Fri, 19 Dec 2014 07:37:54 GMT

Set can't be used in above(), because that is not an aggregation function. However, you could probably have an alternative to resolve the issue. Can you post your sample qvw that demonstrates the issue?

Re: Using set analysis within abvove function

alkesh_sharma — Fri, 19 Dec 2014 08:03:01 GMT

Check the IF condition syntax.

First if condition ends @if(BS_No=50,above(Column(1),1)

after the plus operator above(Column(1),2) here ,2 means nothing