topic Re: Problems with set analysis sytaxis in QlikView

Problems with set analysis sytaxis

Fri, 24 May 2013 09:14:35 GMT

Hi,

I have this set analysis expresion:

=sum({$<Par={'RTM - SME'}>}MLoc)

and it works correctly.

But I also have a variable called Variable1 which has a string value:

Variable1='RTM - SME'

I am not able to write correctly Variable1 into the set expression.

Even more, I would like to use '*' before and after the string 'RTM - SME' in order to get all the values of 'Par' containing the string 'RTM - SME', I am also unable unable to write this set analysis expression correctly.

Help please.

Thanks

Re: Problems with set analysis sytaxis

Sokkorn — Fri, 24 May 2013 09:18:17 GMT

Hi,

Do this

sum({$<Par={$(=Variable1)}>}MLoc)

Regards,

Sokkorn

Re: Problems with set analysis sytaxis

Gysbert_Wassenaar — Fri, 24 May 2013 09:18:57 GMT

The variable can be used like this:

sum({$<Par={'$(Variable1)'}>}MLoc)

With the wildcard * it would look like this:

sum({$<Par={'*$(Variable1)'}>}MLoc)