topic Re: How to make a qlikview empty set analysis ? in QlikView

How to make a qlikview empty set analysis ?

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi everybody,

I have my set_analysis variable in a variable like that:

Set setAnalysis=

Then I use, maybe wrongly, this set_analysis variable in other variables like that:

set f_$(vNomVariables)=count(distinct {$<$(setAnalysis)>}[NUM_CONTRAT]);

Now I can't change how I use this set_analysis variable cause there's too much code to modify.

I have a case where I wouild just like this setAnalysis to be empty..

I've tried Set setAnalysis={}, Set setAnalysis={0} but it doesn't work and I have no other ideas..

avinashelite — Tue, 06 Feb 2018 09:43:49 GMT

try like didn't get your exact requirement ..try like this

Set setAnalysis=''; or Set setAnalysis=null();

Anonymous — Tue, 06 Feb 2018 09:53:11 GMT

Hi Avinash,

Thanks for your reply.

It does not work. I put my variables using the set_analysis in text box and I have the message "Error in a set modifier expression".

Anonymous — Tue, 06 Feb 2018 09:56:38 GMT

Ok, you've inspired me, I've tried

Set setAnalysis= ['']; and it works,

Thanks !

avinashelite — Tue, 06 Feb 2018 10:23:45 GMT

good ..I think the problem is since the values is null the variable is not creating at all ...first shout add the value and then try to nullify...