Qlik Community

Ask a Question

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator
Creator

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 (2)
4 Replies
Partner
Partner

You can call the variable in the filter pane

 

Capture.PNG

Creator
Creator

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

Regards,

AK

Creator
Creator

I did it, But not working.

Regards,

AK

Partner
Partner

Did you select any thing from comparison_type field?