topic Re: Expression Variable Help in App Development

Expression Variable Help

sona_sa — Wed, 22 Dec 2021 16:34:21 GMT

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,

Re: Expression Variable Help

Uday_Pasupuleti — Mon, 03 Jun 2019 11:16:43 GMT

You can call the variable in the filter pane

Re: Expression Variable Help

sona_sa — Mon, 03 Jun 2019 11:26:04 GMT

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

Regards,

Re: Expression Variable Help

sona_sa — Mon, 03 Jun 2019 11:27:50 GMT

I did it, But not working.

Regards,

Re: Expression Variable Help

Uday_Pasupuleti — Mon, 03 Jun 2019 12:28:01 GMT

Did you select any thing from comparison_type field?