topic Re: Set analysis with more viariables in QlikView

Set analysis with more viariables

HitcH — Sat, 16 Nov 2024 17:57:42 GMT

Seems strange to me, but I couldn't find similar topics.

Let's consider two variables and one value:

I'd like to select with set analysis only "Male" and "Brown". The expression I'm using is:

sum({$<[Gender]={Male}>*<[Hair]={Brown}>} Number)

But obviously this is not working (else you wouldn't be reading this 😄 )

Any help please?

Taoufiq_Zarra — Fri, 16 Oct 2020 15:23:44 GMT

like ?

=sum({$<[Gender]={'Male'},[Hair]={'Brown'}>} Number)

HitcH — Fri, 16 Oct 2020 15:33:53 GMT

Thanks a lot, I found "*" on a guide on the net, I guess it was wrong 🙂