Firstsorted value

[Anonymous]

Date	product	max days	Number
07/21/2017	7700550007000100	3	654582-002
07/21/2017	7700550007000100	3	729871-001
07/21/2017	7700550007000100	3	773911-002
07/21/2017	7700550007000100	3	777321-001
07/22/2017	7700550007000100	3	654582-002
07/22/2017	7700550007000100	3	729871-001
07/22/2017	7700550007000100	3	773911-002
07/22/2017	7700550007000100	3	777321-001
07/23/2017	7700550007000100	3	654582-002
07/23/2017	7700550007000100	3	729871-001
07/23/2017	7700550007000100	3	773911-002
07/23/2017	7700550007000100	3	777321-001

4 numbers are  blocking each date and days also same but i want output below one

654582-002,729871-001, 773911-002, 777321-001  in script level  for each distinct date  like output

07/21/2017	7700550007000100	3	654582-002,729871-001,773911-002,777321-001
07/22/2017	7700550007000100	3	654582-002,729871-001,773911-002,777321-001
07/23/2017	7700550007000100	3	654582-002,729871-001,773911-002,777321-001

[Anil_Babu_Samineni]

Please have a look Concat - script function ‒ QlikView

[sunny_talwar]

May be like this

Fact:

LOAD Date,

     product,

     [max days],

     Concat(DISTINCT Number, ', ') as Number

FROM....

Group By Date, product, [max days];

[its_anandrjs]

If on the UI part you required this than try this ways

Dim:- Date,  product,  max days

Expre:- Concat(DISTINCT Number, ', ')

[Anonymous]

Hi Experts,

How to use first sorted value in Script level ? Can any one Explain  me with Example?

[Anonymous]

How to use first sorted value in Script level ? Can any one Explain  me with Example?

[Kushal_Chawda]

I think you are asking the question which is not in a context with your requirement.

[sunny_talwar]

Where did firstsortedvalue came in from? May be check here:

FirstSortedValue - script function ‒ QlikView

[its_anandrjs]

In this model or data model and the output that you need is not using Firstsorted

Check about Firstsorted example

https://community.qlik.com/docs/DOC-6907#comment-45792