topic Re: Variable not working in QlikView

Variable not working

rohitians — Thu, 01 Nov 2018 11:20:15 GMT

Hi Friends,

I have expression,

Count(Distinct {$<[$(=Concat({1<$Table-={'Readership','DimDocument','DimAuthor','MasterCalendar','DimClient','DimClientContact',

'DimEmployee','BridgeTab'}>}distinct $Field,']=,[')&']=')>} RSHitID)

which works perfectly Fine

But when i Store the set analysis in variable and use as following,

count(distinct {<vReadershipFilters>} RSHitID)

vReadership=

'['&Concat({1<$Table-={'Readership','DimDocument','DimAuthor','MasterCalendar','DimClient','DimClientContact',

'DimEmployee','BridgeTab','DimClientTier','DimSalesCoverage'}>}distinct $Field,']=,[')&']='

After using variable the expression is not working properly,

Please help if i am doing any mistake while storing in varibale.

Thanks,

Rohit Yadav

Re: Variable not working

sunny_talwar — Thu, 01 Nov 2018 11:34:08 GMT

May be try with dollar sign expansion of the variable

Count(DISTINCT {<$(vReadershipFilters)>} RSHitID)

Re: Variable not working

rohitians — Thu, 01 Nov 2018 13:08:04 GMT

Hi Sunny,

Thanks got it..

without $ it wont be possible right?

Re: Variable not working

sunny_talwar — Thu, 01 Nov 2018 13:10:24 GMT

Not in this scenario. But is there a reason you want to use it without dollar sign expansion?

Re: Variable not working

rohitians — Thu, 01 Nov 2018 14:22:23 GMT

Hi Sunny,

Actually this is for Qliksense

Yes because business users may not understand what $ means so..

Thanks,

Rohit Yadav

Re: Variable not working

sunny_talwar — Thu, 01 Nov 2018 14:51:57 GMT

Why do they need to look at the expression?

Re: Variable not working

rohitians — Fri, 02 Nov 2018 07:12:54 GMT

For self serve if they want to use and make their expressions...

Re: Variable not working

sunny_talwar — Fri, 02 Nov 2018 11:09:52 GMT

If your users are knowledgeable enough to create an expression like this

Count(DISTINCT {<vReadershipFilters>} RSHitID)

I am sure you can convenience them to use this instead

Count(DISTINCT {<$(vReadershipFilters)>} RSHitID)

All you are asking them is to add dollar sign expansion which evaluates the variable. If you are unable to do this, then I don't think you have any other alternative.