Set Analysis Problem

max_potass — Fri, 18 May 2018 13:06:22 GMT

Hi everyone,

I am in a state of complete resignation... I have no Idea what I am doing wrong. I did this before and it worked just fine, so I guess I did something wrong, but I can't figure it out on myself...

I have following Expression:

SUM({[1]<Rep_HaWa_Normal={'Nicht HaWa, Nicht REP'}, Verkaufsorganisation={'1000'}, [Leading Product Cluster TEXT_PMM]={'X'}>}AE.Netto)

I now want AE.Netto for Not [Leading Product Cluster TEXT_PMM]={'Food Solutions'} so I do this:

SUM({[1]<Rep_HaWa_Normal={'Nicht HaWa, Nicht REP'}, Verkaufsorganisation={'1000'}> - [1]<[Leading Product Cluster TEXT_PMM]={'X'}>}AE.Netto)

But it Returns 0. That implies, that there are only 'X' for [Leading Product Cluster TEXT_PMM], right? But it is not the case. If I just do not filter [Leading Product Cluster TEXT_PMM] it get the correct value...

No Idea what is going on. I have this logic working in several different spots and no problems...

Best Regards

Max

Re: Set Analysis Problem

sunny_talwar — Fri, 18 May 2018 13:10:08 GMT

Why don't you try this

SUM({[1]<Rep_HaWa_Normal={'Nicht HaWa, Nicht REP'}, Verkaufsorganisation={'1000'}, [Leading Product Cluster TEXT_PMM] -= {'X'}>} AE.Netto)

Re: Set Analysis Problem

max_potass — Fri, 18 May 2018 13:16:04 GMT

Thank you so much Sunny! I did not know, you can do this... That makes a lot of things easier

Have a nice Weekend.

topic Re: Set Analysis Problem in QlikView

Set Analysis Problem

Re: Set Analysis Problem

Re: Set Analysis Problem