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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Mopadi
Contributor
Contributor

Use in one dimension expression - valuelist - concat and ignoring filter

Hi guys,

I have the following measure and it works correctly :

=valuelist( $(=concat(distinct chr(39) & MasterCalendar.Calendar_MonthStartDate & chr(39),',')) )

It is used to create dimension of one of my chart. So I get all the date depending of the filters applied to the table MasterCalendar or any other related table.

On top of that I would like to use the analysis set {1<MasterCalendar.year=$::MasterCalendar.year>} to get the same result without taking into consideration all filters applied except on the field MasterCalendar.year.

Unfortunatly I have not been able to integrate this piece of code in my dimension expression. Do you have any idea ?

Best

Labels (1)
1 Reply
Digvijay_Singh

May be try - 

{1<MasterCalendar.year=P(MasterCalendar.year)>}