topic Re: Set Analysis Help in QlikView

Set Analysis Help

Wed, 01 May 2013 12:55:42 GMT

Hi, Im using set analysis to sum a field for a certain dimension :

sum({<[Indicator]={45}>}Number)

I need to add another condition to the analysis to sum those value for Indicator=45 and Measure='Distributor'

Ive had a go but I cant get the syntax right.

Any help appreciated

Thanks,

Fiorano

Re: Set Analysis Help

Gysbert_Wassenaar — Wed, 01 May 2013 12:57:50 GMT

sum({<[Indicator]={45},Measure={'Distributor'}>}Number)

Re: Set Analysis Help

jagan — Wed, 01 May 2013 13:20:51 GMT

Hi,

Try this Measure={'Distributor'} to your expression, like this you can add any number of conditions. Refer Set Analysis section of Help file.

=Sum({<Indicator={45}, Measure={'Distributor'}>}Number)

Hope this helps you.

Regards,

Jagan.

Re: Set Analysis Help

Wed, 01 May 2013 13:25:09 GMT

Excellent ! Thanks!

Re: Set Analysis Help

paulyeo11 — Wed, 01 May 2013 13:46:39 GMT

Good post , because it help me how set analysis work. Since this expression with out year and month.

Re: Set Analysis Help

Wed, 01 May 2013 14:33:34 GMT

Hi,

This solution seems to be not working. I have two textboxes with the following expressions :

=sum({<Indicator={80},Measure={'Distributor'}>}Number)

=sum({<Indicator={80},Measure={'Reseller'}>}Number)

and the two values are the same.

To test this I have placed another text box with =sum(Number) and two listboxes each containing Indicator and Measure. When I select the 80 & 'Distributor' or 80 & 'Reseller' the value in the third textbox changes.

Any thoughts on why this maybe happening? Or am I using Set analysis for the wrong reason?

Thanks again,

Fiorano

Re: Set Analysis Help

jagan — Wed, 01 May 2013 14:44:19 GMT

Hi,

In the below two expressions you are explicitly specifying the Indicator and Measure so the values of this expression won't change even if you change the selections of Indicator and Measure.

=sum({<Indicator={80},Measure={'Distributor'}>}Number)

=sum({<Indicator={80},Measure={'Reseller'}>}Number)

In the third textbox you didn't specified any values in the expression, so the values are changing based on the current selections.

Hope this helps you.

Regards,

Jagan.

Re: Set Analysis Help

Wed, 01 May 2013 14:48:02 GMT

HI, thanks for your reply. My question is why isn't the sum of Number different for each of the expressions:

=sum({<Indicator={80},Measure={'Distributor'}>}Number)

=sum({<Indicator={80},Measure={'Reseller'}>}Number)

Many thanks,

Fiorano

Re: Set Analysis Help

jagan — Wed, 01 May 2013 14:54:45 GMT

Hi,

Check your data whether you have same values for the two expressions in your data.

Regards,

Jagan.

Re: Set Analysis Help

Wed, 01 May 2013 19:10:42 GMT

Hi,

Given that the third text box containing ' =sum(Number) ' updates when I select the two types of values that Im trying to use set analysis on - doesnt this show that the data is different for 'Distributor' and 'Reseller' ?

Thanks again,

Fiorano