Force Set Analysis disregarding selection

Fri, 14 Sep 2012 22:19:29 GMT

Hello, I'm having trouble using set analysis disregarding the selection the user makes.

On a clear state my table shows like this:

GROUP1	ITEM 1	324
GROUP2	ITEM 1	347
GROUP3	ITEM 1	100
GROUP4	ITEM 1	32
GROUP 5	ITEM 1	250

But when the user selects one of the groups, my table shows like this:

GROUP1	ITEM 1	-
GROUP2	ITEM 1	347
GROUP3	ITEM 1	-
GROUP4	ITEM 1	-
GROUP 5	ITEM 1	-

I want the chart to keep the values as the selection should only affect other charts, not this one.

I'm using the next expression on my chart:

(sum({1<Date={$(vPeriod)},Flag_BAE={1}>}Weight* Flag_YearToDate)/Value)

I've tried other variations:

(sum({1<Date={$(vPeriod)},Flag_BAE={1},ID_Group=,Group=>}Weight* Flag_YearToDate)/Value)

(sum({$<Date={$(vPeriod)},Flag_BAE={1},ID_Group=,Group=>}Weight* Flag_YearToDate)/Value)

but i can't make it work, any ideas?

Re: Force Set Analysis disregarding selection

swuehl — Fri, 14 Sep 2012 22:29:02 GMT

Could you post a small sample app? Maybe you need to use something like

.../ only({1} Value) )

Re: Force Set Analysis disregarding selection

Sat, 15 Sep 2012 02:07:50 GMT

Yes, you're correct, the trouble is with the Value. I removed it and moved it to the sum expression and now it works perfect. Thank you very much for pointing that out!

topic Re: Force Set Analysis disregarding selection in QlikView

Force Set Analysis disregarding selection

Re: Force Set Analysis disregarding selection

Re: Force Set Analysis disregarding selection