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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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)>}