Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Please have a look Concat - script function ‒ QlikView
May be like this
Fact:
LOAD Date,
product,
[max days],
Concat(DISTINCT Number, ', ') as Number
FROM....
Group By Date, product, [max days];
If on the UI part you required this than try this ways
Dim:- Date, product, max days
Expre:- Concat(DISTINCT Number, ', ')
Hi Experts,
How to use first sorted value in Script level ? Can any one Explain me with Example?
How to use first sorted value in Script level ? Can any one Explain me with Example?
I think you are asking the question which is not in a context with your requirement.
Where did firstsortedvalue came in from? May be check here:
In this model or data model and the output that you need is not using Firstsorted
Check about Firstsorted example