topic Set analysis in a variable in QlikView

Set analysis in a variable

Fri, 30 Jan 2015 13:39:33 GMT

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.

Re: Set analysis in a variable

Anonymous — Fri, 30 Jan 2015 13:44:19 GMT

Hi,

I suggest you to use this:

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

and then

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

Elena

Re: Set analysis in a variable

Gysbert_Wassenaar — Fri, 30 Jan 2015 13:44:25 GMT

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?

Re: Set analysis in a variable

jmmayoral3 — Fri, 30 Jan 2015 13:49:38 GMT

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