problem in Variable..

[vijayit43]

Hi Expert,

In My QlikView we have create a variable using Aggrigate sum , when we use variable in pivat expression then no data coming when expression write same Aggrigate Sum Expression then give correct data, how to set expression using variable. please Suggest

[Gysbert_Wassenaar]

Please post a document that demonstrates the problem. Your explanation does not offer enough information to pinpoint the problem.

[vijayit43]

Hi

We have Calculating Employ Aging where we create every expression as one variable when select one dimension give accurate data but when no filter apply then give all value is 0 please Suggest how to do that its urgent. for sample QV is attached

[vijayit43]

Hi Expert...

   Please Suggest..

[SunilChauhan]

use like below example

set Vaggr="=aggr(sum(sales),DeptId)";

and use $(Vaggr) in front end expression

or

set Vaggr=aggr(sum(sales),DeptId);

and use $(Vaggr) in front end expression

or

set Vaggr='=aggr(sum(sales),DeptId)';

and use $(Vaggr) in front end expression

hope this helps

[vijayit43]

Hi Sunil,

        I am try but its not work sample qv attached please suggest..

[Gysbert_Wassenaar · Accepted solution]

See attached qvw. You should do these calculations in the script. The performance of the expressions in the pivot table is pretty bad.