topic Re: variable issue in QlikView

variable issue

Wed, 03 May 2017 06:42:29 GMT

hi friends,

i have small issue with variable in my pivot table am using one variable like"VRev", of following expression

=sum({<Test2,Level3_desc,Desc2, vc_gl_code_L1={'4'} ,YEAR={$(VMaxYear)}>} DEBITAMT-CRDTAMNT)*Flag_Sales,

the above expression is giving the right values in pivot table but in the sub level the values are not displaying. and if i am not using '='

sign before expression it displays right values of sublevel but the main values are not correct, let me know is there any issue with my expression.

Re: variable issue

tresB — Wed, 03 May 2017 06:53:33 GMT

The issue is not with variable I guess. If you use set analysis in a chart, it gets evaluated once for the chart and NOT row-wise. You might have to use Sum(If(... or Firstsortedvalue() in combination with aggr() to achieve the same. Try to share a sample qvw for detailed help.

Re: variable issue

vinieme12 — Wed, 03 May 2017 07:23:09 GMT

try like below sample.

Sum( AGGR( YourExpression , Field1,Field2,....) )

here field1,field2 are the dimensions used in the pivot table.

Re: variable issue

Wed, 03 May 2017 07:50:16 GMT

give me the sample expression combination of those