Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
santosh4195
Contributor II
Contributor II

How to make one dimension disable on other dimension

Hi,

I have a  requirement:

I need facility name filter should not affect month dimension in a bar graph. I am using below expression:

Aggr(only({<FACILITY_NAME=>}month),month)

but the data still changes with the FACILITY_NAME filter. Any suggestions on how to make FACILITY_NAME inactive here?

@sunny_talwar 

Labels (1)
2 Replies
BrunPierre
Partner - Master
Partner - Master

Try this

Aggr(Only({1<FACILITY_NAME=>}month),month)

Digvijay_Singh

Try this as well in case, didn't test it so not sure - 

Aggr({<FACILITY_NAME=>}only({<FACILITY_NAME=>}month),month)