Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
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 II
Partner - Master II

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)