Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
bertrand_fr
Creator
Creator

How to make a qlikview empty set analysis ?

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

4 Replies
avinashelite

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

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

bertrand_fr
Creator
Creator
Author

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

bertrand_fr
Creator
Creator
Author

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