topic Re: Measure affected only by one filter in App Development

Measure affected only by one filter

darroyo_telcomu — Fri, 02 Apr 2021 08:24:01 GMT

Hello.

Imagine I have dimensions D1, D2 and D3, and I want my measure sum(measure) only be affected by filtering D1.

I have seen solutions in the "negative" way, I mean writing the dimensions I want to affect the measure, like this:

sum({<D2,D3>}measure)

But this is not operative if I have a lot of dimensions. I should not be writing a list of n dimensions indicating that dimensions don't have to affect my measure.

I figure it must be a way to indicate the only one dimension D1 that should affect my meassure.

Please tell me I'm right 😄

Thanks for your support.

Re: Measure affected only by one filter

Mauritz_SA — Sat, 04 Apr 2020 19:18:58 GMT

Hi @darroyo_telcomu

I unfortunately don't have access to Qlik right now so I couldn't test it, but try using:

sum(TOTAL <D1> [Field to Sum])

Hope this helps.

Regards,

Mauritz

Re: Measure affected only by one filter

vidyarani — Sat, 04 Apr 2020 19:57:55 GMT

Hello,

Could you please try the below expression:

sum({1<D1=P(D1)>}measure)

hope this helps.

Thanks,

Vidya

Re: Measure affected only by one filter

darroyo_telcomu — Mon, 06 Apr 2020 11:34:47 GMT

Thank you very much, but it didn't work.

Re: Measure affected only by one filter

darroyo_telcomu — Mon, 06 Apr 2020 11:35:26 GMT

It works! Thank you very much!

Re: Measure affected only by one filter

Nolgath — Fri, 23 Dec 2022 10:47:24 GMT

Thanks, worked for me as well