Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

jhdiwakar
New Contributor

How to concatenate strings for grouped columns and Direct fields in straight table for YTD.

Hi,

How to concatenate strings for grouped columns and Direct fields in straight table for YTD.

Example Expression that i am using for concatenate is:

Concat(DISTINCT{<[Financial Year]=,MonthShortName=,FiscalMonthKey={"$(='>=' & $(vSelYrMthStart) & '<=' & $(vSelYrMthEnd1))"}>}Account,',')

Here Account is my grouping column

Please help on the above issue.

2 Replies
devarasu07
Honored Contributor II

Re: How to concatenate strings for grouped columns and Direct fields in straight table for YTD.

Hi,

Can you try like below,

=Concat(DISTINCT{<[Financial Year]=,MonthShortName=,FiscalMonthKey={"$(='>=' & $(vSelYrMthStart) & '<=' & $(vSelYrMthEnd1))"}>} chr(39) & Account & chr(39),',')

MVP
MVP

Re: How to concatenate strings for grouped columns and Direct fields in straight table for YTD.

What is the issue that you are having? Is the above expression not working? Are you using this as a dimension? If that is what you are doing, you will need to use Aggr() function to make it work as a dimension