Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Specialist II
Specialist II

List of all tags in text object

Hi friends,

Is it possible to have list of all tags MonthName in text object like below

September 2012, July 2013, August 2013, September 2013

Thanks,

1 Solution

Accepted Solutions
Employee
Employee

an numeric expression you have into your cloud, maybe

concat(DISTINCT MonthName, ', ',YEAR*100+MONTH)

View solution in original post

6 Replies
MVP
MVP

Not sure if I understand your request properly, but maybe

=concat(DISTINCT MonthName, ', ')

Specialist II
Specialist II

Yes, exactly like it, but order by Months.

I should use dual function?

Thanks,

Employee
Employee

concat(DISTINCT MonthName, ', ',<a sort expression>)

Specialist II
Specialist II

What the expression for sort MonthName

order by MonthName?

Employee
Employee

an numeric expression you have into your cloud, maybe

concat(DISTINCT MonthName, ', ',YEAR*100+MONTH)

View solution in original post

Specialist II
Specialist II

Nice job