topic I need 4 different filters (selection Boxes) for same field for compartive analysis in QlikView

I need 4 different filters (selection Boxes) for same field for compartive analysis

Wed, 05 Feb 2014 15:53:28 GMT

Hi Community,

I have to create a 4 different selection boxes for same field in comparing of straight table,,i used states but they are not working for set analysis.Can some one help what is solution ?

Re: I need 4 different filters (selection Boxes) for same field for compartive analysis

Oleg_Troyansky — Wed, 05 Feb 2014 16:04:46 GMT

States are working very well in Set Analysis, you just need to use the correct syntax.

If you named your 4 states State1, State2, State3 and State4, the expressions for the four columns would be:

sum({State1} Amount)

sum({State2} Amount)

sum({State3} Amount)

sum({State4} Amount)

Are you experiencing any other problems with Set Analysis and Alternate States?

I encourage you and anybody else who is interested in advanced Set Analysis, to check out my sessions at the Masters Summit for QlikView in Chicago:

www.masterssummit.com

best,

Oleg Troyansky

Re: I need 4 different filters (selection Boxes) for same field for compartive analysis

Wed, 05 Feb 2014 16:16:45 GMT

Thanks for your reply, Can you please tell how can i write syntax for this expression:

='High' & ':' &count({<[QC SCAR Severity] = {'High'}>}DISTINCT [QC SCAR Number])

My State is =State 2

Re: I need 4 different filters (selection Boxes) for same field for compartive analysis

Oleg_Troyansky — Wed, 05 Feb 2014 16:30:23 GMT

Something like this (writing it "dry",so can't guarantee the exact syntax:

='High' & ':' &count({[State 2] * $<[QC SCAR Severity] = {'High'}>} DISTINCT [QC SCAR Number])

Explanation: the resulting set is the intersection (*) of the Sate 2 (selected Supplier) and the current Selections State $ with the modifier of QC SCAR Severity = High.

Try and see if it works