Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
darroyo_telcomu
Partner - Contributor III
Partner - Contributor III

Measure affected only by one filter

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.

Labels (1)
1 Solution

Accepted Solutions
vidyarani
Contributor III
Contributor III

Hello,

Could you please try the below expression:

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

hope this helps.

Thanks,

Vidya

View solution in original post

5 Replies
Mauritz_SA
Partner - Specialist
Partner - Specialist

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
Contributor III
Contributor III

Hello,

Could you please try the below expression:

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

hope this helps.

Thanks,

Vidya

darroyo_telcomu
Partner - Contributor III
Partner - Contributor III
Author

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

darroyo_telcomu
Partner - Contributor III
Partner - Contributor III
Author

It works! Thank you very much!

Nolgath
Creator
Creator

Thanks, worked for me as well