Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Force Set Analysis disregarding selection

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

On a clear state my table shows like this:

GROUP1ITEM 1324
GROUP2ITEM 1347
GROUP3ITEM 1100
GROUP4ITEM 132
GROUP 5ITEM 1250

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

GROUP1ITEM 1-
GROUP2ITEM 1347
GROUP3ITEM 1-
GROUP4ITEM 1-
GROUP 5ITEM 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?

1 Solution

Accepted Solutions
swuehl
MVP
MVP

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

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

View solution in original post

2 Replies
swuehl
MVP
MVP

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

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

Not applicable
Author

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!