Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

Highlighted
divyanshi
New Contributor III

using concat() function in an expression

Hello,

I have an expression :

(text(Date(Date#((If(num(month(date#(GetFieldSelections(Mon),'MMM')))<4,num(month(date#(GetFieldSelections(Mon),'MMM')))+9,

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

This expression basically return the month name after all computation.

I want to use the CONCAT() function in this expression in order to get  multiple months name at the same time i.e. Apr, June... and so on.

The expression I m using is

Concat(Distinct ((text(Date(Date#((If(num(month(date#(GetFieldSelections(Mon),'MMM')))<4,num(month(date#(GetFieldSelections(Mon),'MMM')))+9, num(month(date#(GetFieldSelections(Mon),'MMM')))-3)),'MM'),'MMM')))),',')

But not getting the result.

Kindly help.