Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
If you are a Qlik Insight Bot user, join this collaborative group: JOIN GROUP
Highlighted
Contributor

Datewise status should sort in order

Hi Expert,

I have Row ID wise NEW VALUE and REC UPDATED DATE .My user want data must be concat and show in one column with ascending order.I can sort date but New value can not sort.It automatically sort by alphabetically order.Please suggest correct way .I have attached sample data.

Thanks in advance.

Rupali

Tags (2)
2 Replies
Highlighted
Honored Contributor III

Re: Datewise status should sort in order

Hi Rupali,

may be

Concat(DISTINCT NEW_VALUE,',',ROW_NUMBER) AS NEW_VALUE

Regards,

Antonio

Highlighted
Contributor

Re: Datewise status should sort in order

Thanks 🙂