How to make a qlikview empty set analysis ?

[Anonymous]

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]

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

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

[Anonymous]

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]

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

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

Thanks !

[avinashelite]

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...