This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I am relatively new to QlikSense and I have read many posts on Concatenating in Load Scripts but I still can not find a solution.
I have a list of Orders and each order can have Multiple Statuses i.e.
I would like to see a result of:
I am loading data from an excel document i.e.
FROM [lib://50.Operations_SourceFiles/Productivity-MasterX.xlsm](ooxml, embedded labels, table is PlannedVActual);
From what I have read, I need to concat the data and group but what script do I need to add to the above please?
You can try concat on resident load like below
Data:load Plnt,....OrderFROM Source
left join (Data)load Order,concat(distinct Stat,',') as Statusresident Datagroup by Order;
View solution in original post
Order,concat( distinct Status,',') as Status
FROM [lib://50.Operations_SourceFiles/Productivity-MasterX.xlsm](ooxml, embedded labels, table is PlannedVActual)
group by Order;
Kush,Thank you for the reply, unfortunately I get an ' Invalid Expression' ErrorI have taken a screen shot of the full script. Thanks in Advance. Ben
screenshot is missing
Is it visible now? Thanks
That worked great.
Thank you for the help