topic Re: set analysis error in QlikView

set analysis error

Fri, 28 Apr 2017 06:52:54 GMT

Hi,

i have an issue with set expression the following is expression

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

(sum({<vc_gl_code_L1={5},YEAR={$(VMaxYear)}>}DEBITAMT-CRDTAMNT))

the above expression it displaying only first expression value that means after '-' operator expression value is not considering.

Anonymous — Fri, 28 Apr 2017 06:57:55 GMT

Braces are incorrect. CAn you please explain what you are trying to here??

tresB — Fri, 28 Apr 2017 06:58:09 GMT

May be you need to add one more parenthesis like.

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

(sum({<vc_gl_code_L1={5},YEAR={$(VMaxYear)}>}DEBITAMT-CRDTAMNT)) )

Anil_Babu_Samineni — Fri, 28 Apr 2017 06:59:07 GMT

May be parenthesis missing on end

Fri, 28 Apr 2017 08:20:37 GMT

Thanks to all

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

(sum({<vc_gl_code_L1={5},YEAR={$(VMaxYear)}>}DEBITAMT-CRDTAMNT)) it is correct but am using variable of this expression