Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
I suggest you to use this:
vFilter= Platform={'YES'},[Product Family]={'YES'},[Release Date]= {'YES'}
and then
Sum({<$(vFilter)>}Sales)
Elena
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?
I just try your formula and i don´t have an error. Formula is well written.