Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
hello
why do you need set analysis ?
if you select one or more of the fields, the filters will automatically be applied
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
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