Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
shubham_shah
New Contributor

How to get information in pivot table for repeated entries in comma separated form?

Hi ,

I want the ouput in the following format.Month.png

but I'm unable to get the entries as in pivot it only shows one data of having only one entry.

PivotTable.PNG

Following is my Load statement :

VisitDates:

LOAD [ABM NAME],

     [TBM NAME],

     DOC_NAME,

     Date as DCR_Filed_Date

Tags (2)
1 Reply
madhumitha
Contributor

Re: How to get information in pivot table for repeated entries in comma separated form?

Hi Shuhbam,

Please modify you expression as below.

Concat(Day(DCR_Filed_Date),',')

Thanks!