topic Re: problem in Variable.. in QlikView

problem in Variable..

vijayit43 — Thu, 25 Dec 2014 09:37:06 GMT

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

Re: problem in Variable..

Gysbert_Wassenaar — Thu, 25 Dec 2014 09:43:59 GMT

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

Re: problem in Variable..

vijayit43 — Thu, 25 Dec 2014 14:03:34 GMT

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

Re: problem in Variable..

vijayit43 — Thu, 25 Dec 2014 15:34:43 GMT

Hi Expert...

Please Suggest..

Re: problem in Variable..

SunilChauhan — Thu, 25 Dec 2014 15:39:21 GMT

use like below example

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

and use $(Vaggr) in front end expression

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

and use $(Vaggr) in front end expression

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

and use $(Vaggr) in front end expression

hope this helps

Re: problem in Variable..

vijayit43 — Thu, 25 Dec 2014 16:44:48 GMT

Hi Sunil,

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

Re: problem in Variable..

Gysbert_Wassenaar — Thu, 25 Dec 2014 18:29:49 GMT

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