Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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
Partner - Champion III
Partner - Champion III

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.