Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis question

Hi all,

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

zhou

1 Solution

Accepted Solutions
8 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

senpradip007
Specialist III
Specialist III

Hello Zhou.

Try this :

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

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

Not applicable
Author

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

Not applicable
Author

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.

Not applicable
Author

=sum(total Sales<Area>)

Not applicable
Author

=Sum(TOTAL <Area> Sales)

Not applicable
Author

you can try using

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

This will include include the area and ignore rest.

Thanks,

Angad

Not applicable
Author

Thank you very much. A clever approach!