Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sona_sa
Creator II
Creator II

Expression Variable Help

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

Labels (1)
4 Replies
Uday_Pasupuleti
Partner - Creator III
Partner - Creator III

You can call the variable in the filter pane

 

Capture.PNG

sona_sa
Creator II
Creator II
Author

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

Regards,

AK

sona_sa
Creator II
Creator II
Author

I did it, But not working.

Regards,

AK

Uday_Pasupuleti
Partner - Creator III
Partner - Creator III

Did you select any thing from comparison_type field?