topic Re: SET Analysis with multiple fields in QlikView

SET Analysis with multiple fields

newqlik2017 — Wed, 25 Nov 2020 16:16:04 GMT

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!

Re: SET Analysis with multiple fields

olivierrobin — Tue, 24 Apr 2018 15:42:57 GMT

hello

why do you need set analysis ?

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

Re: SET Analysis with multiple fields

newqlik2017 — Tue, 24 Apr 2018 15:47:01 GMT

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

Re: SET Analysis with multiple fields

olivierrobin — Wed, 25 Apr 2018 08:00:50 GMT

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