Expression Variable Help

[sona_sa]

Hi Team,

I am using an expression, i.e. - if(comparison_type = 'MTD', date(MonthEnd(Date#([time] & '-' & right(years,4),'MMM-YYYY')),'MMM-YYYY'), if(comparison_type = 'YTD' OR comparison_type = 'Year on Year', right(years,4),
//else QTD
IF(time = 'JAN' OR time = 'FEB' OR time = 'MAR', Right(years, 4) & ' Q1' ,
IF (time = 'APR' OR time = 'MAY' OR time = 'JUN', Right(years, 4) & ' Q2',
IF (time = 'JUL' OR time = 'AUG' OR time = 'SEP', Right(years, 4) & ' Q3',
Right(years, 4) & ' Q4')))))

Output is : Jan-2018, Feb-2018....2017 Q1, 2017 Q2... 2017, 2018 Etc....

When I am creating a Variable --> vTime  and assigning the same expression and calling the same variable in listbox with the $(vTime). It is not working.

Can anyone suggest how it will work with the variable in Listbox.

Regards,

AK

[Uday_Pasupuleti]

You can call the variable in the filter pane

[sona_sa]

Please find the attached JPG. It's not coming.

Regards,

AK

[sona_sa]

I did it, But not working.

Regards,

AK

[Uday_Pasupuleti]

Did you select any thing from comparison_type field?