Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
siddharthsoam
Partner - Creator II
Partner - Creator II

Cannot fetch multiple values from the months filter

I am using the following expression for to fetch multiple values from the filter (months)

concat(distinct text(Date(Date#(if($(exit_month)=12,$(exit_month)-9,$(exit_month)+3),'MM'),'MMM')),',')


where exit_month is used to compute the last month month from months filter. The expression for exit_month is as follows:


max((If(num(month(date#(Mon,'MMM')))<4,num(month(date#(Mon,'MMM')))+9,

num(month(date#(Mon,'MMM')))-3)),'MM')


The exit_month expression works fine independently but does not work with concat( distinct..



0 Replies