Measure affected only by one filter

[darroyo_telcomu]

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.

[Mauritz_SA]

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

[vidyarani · Accepted solution]

Hello,

Could you please try the below expression:

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

hope this helps.

Thanks,

Vidya

[darroyo_telcomu]

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

[darroyo_telcomu]

It works! Thank you very much!

[Nolgath]

Thanks, worked for me as well