topic Variable within set analysis in QlikView

Variable within set analysis

ivandrago — Tue, 09 Apr 2013 16:00:59 GMT

Hi,

I have the attached document and want to know if this is possible?

I have created a variable called vSuccess within there I have a list of ID's that i declare as being a success (1,2). I am then trying to use this variable within the expression as per the text object 'Success based on variable (NOT WORKING)' and expecting to see the same result as the text box where the result shows

'Success 1450'

Thanks

Re: Variable within set analysis

Tue, 09 Apr 2013 19:19:51 GMT

Use

='Success based on variable (NOT WORKING) '&chr(10)&chr(10)&sum({$<ID={$(vSuccess)}>}OrderVal)

The variable vSuccess needs to be encapsulated by parentheses or be used with dollar sign expansion $().

Re: Variable within set analysis

Anonymous — Tue, 09 Apr 2013 19:19:55 GMT

Ivan

It's just a minor syntax error, this works:

='Success based on variable (NOT WORKING) '&chr(10)&chr(10)&sum({$<ID={$(vSuccess)}>}OrderVal)

Regards,

Michael