topic Re: Set Analysis expression using a variable in QlikView

Set Analysis expression using a variable

Tue, 21 Jul 2015 13:05:39 GMT

I want to write a set analysis expression to calculate total sales where [REGION] is equal to either ‘Africa’, ‘Asia’ or ‘Ireland’

where my total sales amount is a variable called $vSumSales.

Thanks in advance

Re: Set Analysis expression using a variable

sunny_talwar — Tue, 21 Jul 2015 13:07:00 GMT

May be this:

=Sum({<REGION = {'Africa', 'Asia', 'Ireland'}>}Sales)

Re: Set Analysis expression using a variable

Anonymous — Tue, 21 Jul 2015 13:09:42 GMT

Hi,

Try this:

=Sum({<REGION = {'Africa', 'Asia', 'Ireland'}>}Sales)

Re: Set Analysis expression using a variable

Kushal_Chawda — Tue, 21 Jul 2015 13:10:08 GMT

try,

=Sum({<REGION = {'Africa', 'Asia', 'Ireland'}>}Sales)

Re: Set Analysis expression using a variable

Tue, 21 Jul 2015 13:22:57 GMT

Thanks guys - they were all the correct answer and I realised what I was doing it wrong.

Moving on from this what if for the same view I now wanted sales broken down by the regions mentioned rather than aggregated ? Ie total sales for Africa, Asia and Ireland each

Re: Set Analysis expression using a variable

sunny_talwar — Tue, 21 Jul 2015 13:25:37 GMT

Create a chart with REGION as dimension and the =Sum({<REGION = {'Africa', 'Asia', 'Ireland'}>}Sales) as expression.

Re: Set Analysis expression using a variable

Tue, 21 Jul 2015 13:30:03 GMT

Thanks Sunny - that was glaring me in the face. I think I was trying to take a very difficult route.

Re: Set Analysis expression using a variable

sunny_talwar — Tue, 21 Jul 2015 13:31:45 GMT

No problem

I am glad we were all able to help you here.