set exp in the variable - Qlik Community

pk · ‎2019-11-20

hi guys,

Want to create variable for below exp-

=if(CF_Month='Apr',
(Count(DISTINCT {<Flag={'Active'}, FYear={$(vtestYear)},CF_Month={$(vtestmonth)},Quarter=,FIN_Year=, O1andOE={'O1 & Above'},Location2-={'2004'}>} [Personnel No])),
(Count(DISTINCT {<Flag={'Active'}, FYear={$(VFYear)},CF_Month={$(vtestmonth)},FIN_MNT=,FYear=, O1andOE={'O1 & Above'},Location2-={'2004'}>} [Personnel No]))
)

Please help.

Thanks in advance

Brett_Bleess · ‎2019-12-04

Priti, check the following Help link, if that does not help, please provide further context on things, as I am a bit confused, which means others likely are too, and that may be why nobody has answered already...

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/Scrip...

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.