Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
jc17
Partner - Contributor II
Partner - Contributor II

'Ignore' selections in Master Dimension in Set Analysis

Hi everyone,

I have a master dimension in my app and I want to ignore possible selections in this master dimension for a measure with Set Analysis. It is not valid to use 'Dimension_name=' in Set Analysis as this is a master dimension. Is there any way to achieve this?

Thank you in advance

Labels (5)
6 Replies
Taoufiq_Zarra

@jc17  if I understood correctly

to ignore selection add 1 to your set analysis like sum({1<...> MEASURE)

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
jc17
Partner - Contributor II
Partner - Contributor II
Author

Thank you for your help. If I use what you say, filters in other fields will not be taken into account, and I only need to ignore filters in this master dimension

agigliotti
Partner - Champion
Partner - Champion

Hi @jc17 ,

What's the field name linked to the master dimension?

jc17
Partner - Contributor II
Partner - Contributor II
Author

The name is 'Week'

agigliotti
Partner - Champion
Partner - Champion

What about the below expression:

sum( {< Week= > MEASURE )

?

Andrei_Faibich
Contributor III
Contributor III

It doesn't work, I have the same issue.