Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
shubham_shah
Contributor
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

1 Reply
madhumitha
Creator
Creator

Hi Shuhbam,

Please modify you expression as below.

Concat(Day(DCR_Filed_Date),',')

Thanks!