Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
De
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
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
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