Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set analysis in a variable

Hi everyone,

I have created a variable wich incude some set analysis parameters, like bellow:

vFilter= {$<Platform={'YES'},[Product Family]={'YES'},[Release Date]= {'YES'}>}

My exression is :

sum($(vFilter)Sales)

But Qlikview displays 'allocated memory excedeed'. What's wrong with my formula?

Thank you in advance.

3 Replies
Anonymous
Not applicable
Author

Hi,

I suggest you to use this:

vFilter= Platform={'YES'},[Product Family]={'YES'},[Release Date]= {'YES'}

and then

Sum({<$(vFilter)>}Sales)

Elena

Gysbert_Wassenaar

Looks ok to me, assuming you don't put an = sign at the start of the expression in the variable.

And you don't get the error when you use the fully expanded expression sum({$<Platform={'YES'},[Product Family]={'YES'},[Release Date]= {'YES'}>} Sales) instead of using the variable?


talk is cheap, supply exceeds demand
jmmayoral3
Creator
Creator

I just try your formula and i don´t have an error. Formula is well written.