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

Mopadi — Wed, 16 Aug 2023 22:26:08 GMT

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

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

Digvijay_Singh — Thu, 17 Aug 2023 01:30:18 GMT

May be try -

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

topic Re: Use in one dimension expression - valuelist - concat and ignoring filter in App Development

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

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