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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
sachin1
Contributor III
Contributor III

Issue: Need to Exclude MonthName Selection in Expression

I want to exclude the MonthName field in the expression below. It's not working as expected — I want the selection of MonthName to be ignored, meaning the expression should not respond when MonthName is selected.

 

Count({< [Year-Month]= {"$(vMinMonth)"}, MonthName=,
ID = {"=Not Match(Concat(DISTINCT {<[Year-Month] = {'$(vMaxMonth)'}>} ID, ','), ID)"}
>} DISTINCT ID)

Labels (2)
1 Solution

Accepted Solutions
marcus_sommer

The adjustment of the selection state needs to be applied within all expression-parts - means also within the concat(). Also you may look to replace the concat() approach with an e() or p(), maybe something in this way:

Count({< [Year-Month]= {"$(vMinMonth)"}, MonthName=,
ID = e({<[Year-Month] = {'$(vMaxMonth)'}, MonthName= >} ID) >} DISTINCT ID)

Further check if the variables are responding on any MonthName selections.

View solution in original post

1 Reply
marcus_sommer

The adjustment of the selection state needs to be applied within all expression-parts - means also within the concat(). Also you may look to replace the concat() approach with an e() or p(), maybe something in this way:

Count({< [Year-Month]= {"$(vMinMonth)"}, MonthName=,
ID = e({<[Year-Month] = {'$(vMaxMonth)'}, MonthName= >} ID) >} DISTINCT ID)

Further check if the variables are responding on any MonthName selections.