Hello! I have a table like this:
I need to conver it this, in a table widget:
Its important to make it via calculated dimension or measure. Not vial loading script.
Dimension : Day
Expression : Concat([Deal ID], '&')
Thaks, it works)
aggr(Concat([Deal ID]),Day) in expression of PIVOT TABLE
Thaks, it also works)
Is this you need
Thaks, but i'm using qlik sense.
Please find the following QVF file. Its your output.
Thak you too)
Retrieving data ...