topic can't use two variables in an expression in QlikView

can't use two variables in an expression

sdepotter — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Being new to Qlikview I rteally struggle with the following:

I made 2 variables to calculate current headcount and planned headcount

vActualsCurrentMonth==sum({<Calculatemonth={'$(=max(Calculatemonth))'}>} FTE)

vProfitPlanCurrentMonth=sum({<Calculatemonth={'$(=max(Calculatemonth))'}>} FTEPP15)

Now I want to count the number of divisions where the current headcount (vActualsCurrentMonth) is higher than the planned headcount (vProfitPlanCurrentMonth) and am trying this expression

=Count( {$ <sum({<Calculatemonth={'$(=max(Calculatemonth))'}>} FTE)={">sum({<Calculatemonth={'$(=max(Calculatemonth))'}>} FTEPP15) "} DISTINCT Division)

but it is not working. I must be doing something wrong?

Any help is highly appreciated.

Re: can't use two variables in an expression

sunny_talwar — Thu, 28 Apr 2016 16:12:24 GMT

May be try this:

Sum(Aggr(If(vActualsCurrentMonth > vProfitPlanCurrentMonth, 1, 0), Division))

Re: can't use two variables in an expression

sdepotter — Fri, 29 Apr 2016 08:46:25 GMT

Hi,

thansk but it is not fully working. If I make a straight table with the two expressions (not the variables) and I check where the number of actuals is above the planned number, this is 2.

If I use your expression, the count gives a result of 8?

Re: can't use two variables in an expression

sunny_talwar — Fri, 29 Apr 2016 19:07:39 GMT

Would you be able to share a sample to look at the issue?

Re: can't use two variables in an expression

sdepotter — Wed, 18 May 2016 14:45:56 GMT

Hi Sunny

tried again. it's working now. thanks a lot for your help!