topic Re: Set Analysis question in QlikView

Set Analysis question

Tue, 21 Jan 2014 03:30:21 GMT

Hi all,

I want to caculate the sales ignoring any selections except field 'Area'. Pls help me, thanks in advance.

zhou

CELAMBARASAN — Tue, 21 Jan 2014 03:42:35 GMT

senpradip007 — Tue, 21 Jan 2014 04:24:28 GMT

Hello Zhou.

Try this :

Sum(<{Field1=, Field2=, Field3=}> Sales)

Let us assume that you want to ignoring the selections of Field1, Field2 and Field3.

Tue, 21 Jan 2014 04:59:28 GMT

Hello Zhou

you can by pass those fields which you don't want to affect the selection.

you can write set as follows :

sum({<area={'Area name'}, year={'year'}, field1=, field2=>}sales)

regards

harshal

Tue, 21 Jan 2014 05:14:30 GMT

There are up to 10 fields i should ignore...

I have tried this method and worked. But i think there is another simlier way. Thanks.

Tue, 21 Jan 2014 05:34:01 GMT

=sum(total Sales<Area>)

Tue, 21 Jan 2014 05:48:45 GMT

=Sum(TOTAL <Area> Sales)

Tue, 21 Jan 2014 06:45:41 GMT

you can try using

sum({<area = {"*"},Field2=,Field=>}Sales)

This will include include the area and ignore rest.

Thanks,

Angad

Tue, 21 Jan 2014 07:16:04 GMT

Thank you very much. A clever approach!