Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello! I have a table like this:
Day | Deal ID |
---|---|
1 | 1 |
1 | 2 |
1 | 3 |
2 | 4 |
2 | 5 |
I need to conver it this, in a table widget:
Day | Deal ID |
---|---|
1 | 1&2&3 |
2 | 4&5 |
Its important to make it via calculated dimension or measure. Not vial loading script.
Chart:
Dimension : Day
Expression : Concat([Deal ID], '&')
hI
Try this
aggr(Concat([Deal ID]),Day) in expression of PIVOT TABLE
Is this you need
Hi,
Please find the following QVF file. Its your output.
Thanks,
Thaks, it works)
Thaks, it also works)
Thaks, but i'm using qlik sense.
Thak you too)