topic Re: How to apply filter selection for only 2 columns on set analysis if you have 50 columns in QlikView

How to apply filter selection for only 2 columns on set analysis if you have 50 columns

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have columns names like Country,Area,Region,State,City,Zipcode,geocode,Areacode,lob,client,productname,subproductname.

Now I am showing expression as Sum(sales). Now i want restrict selection on this expression only applicable for Country,lob.

Then i can write set analysis as Sum({<Area=,Region=,State=,City=,Zipcode=,Areacode=,client=,productname=,subproductname=>}sales)

If i have 50 columns and i want effect only 2 column selections on Sum(sales),i can write above expression but it is very difficult add 48 columns in set analysis.If you guys finds any other simple way to put in set analysis please send me the expression.

Thanks,

Raj

Re: How to apply filter selection for only 2 columns on set analysis if you have 50 columns

Clever_Anjos — Tue, 06 Feb 2018 11:56:20 GMT

Try with this, where Col1 and Col2 are the fields that you want to be restricted

Sum({1<Col1=P(Col1),Col2=P(Col2)>}sales)

Re: How to apply filter selection for only 2 columns on set analysis if you have 50 columns

Anonymous — Tue, 06 Feb 2018 12:25:21 GMT

Thanks for your replay.No it didn't work..i needed set analysis expression for out of 50 columns i want selections need to be applicable for only 2 columns.

Re: How to apply filter selection for only 2 columns on set analysis if you have 50 columns

Clever_Anjos — Tue, 06 Feb 2018 17:07:36 GMT

that 1 after brackets means "Discard all selections" and then we´re applying the only columns that matter using the P() operator

Re: How to apply filter selection for only 2 columns on set analysis if you have 50 columns

Anonymous — Wed, 07 Feb 2018 04:47:04 GMT

But it's not working

Re: How to apply filter selection for only 2 columns on set analysis if you have 50 columns

jonathandienst — Wed, 07 Feb 2018 05:03:11 GMT

P() gives possible values which may be affected by other selections. This is a better way to respect the selections for Country, Iob:

=Sum({1<Country = $::Country, Iob = $::Iob>} sales)

Re: How to apply filter selection for only 2 columns on set analysis if you have 50 columns

tresB — Wed, 07 Feb 2018 05:17:49 GMT

Have a look at this document: Ignore all selections except few fields using Set Analysis