SET Analysis with multiple fields

[newqlik2017]

I've multiple list box as filter:

Unit1, Unit2, State, County, Zip. Now, I've an expression for Amount which should reflect the values the ONLY filters selected.

For examples,

1) Return the value when Dim1 filter is selected
2) Return the value when Dim1 & Dim2 filters are selected
3) Return the value when Dim1, Dim2 & state filters are selected
4) Return the value when Dim1, Dim2, state & county filters are selected
5) Return the value when Dim1, Dim2, state, county & zip filters are selected

How does the set analysis expression look like for this selection combination?

Thanks!

[olivierrobin]

hello

why do you need set analysis ?

if you select one or more of the fields, the filters will automatically be applied

[newqlik2017]

Hi Olivier,

I'm thinking ways to make my report work. Here's my initial posting. So I created multiple tables - one for Unit, state and county and merging them together with concat function. That's why I wanted to use set analysis to see if that would work.

https://community.qlik.com/message/1476142?et=watches.email.thread#1476142

[olivierrobin]

hello

from you 1st post, i would basically load the 2nd table 1st and then left load the 1st one on the common keys

so the amount is stored on each row

but the question remains : it's the total amount which is stored on each row. you can't spit it without a repartition key