Discussion board where members can get started with Qlik Sense.
I have a set of data like below:
As you can see,
StudentID 1's item list: 1001, 1002, 1003, 1004
StudentID 2's item list: 1004, 1003, 1002, 1001
They actually have the same list of items.
I need to change the above data like below:
We can filter and count the duplicate lists and have a list of items for each unique combination in code like Java, but I am wondering if we can do it in qlik sense data load script.
Any help will be appreciated.
Go to Solution.
Create a concatenated list of the values per student:
concat(ItemID, ', ', ItemID) as ItemList
Autonumber(concat(ItemID, ', ', ItemID)) as Result
Then you can use Result as dimension and count(distinct StudentID) as expression in a chart.
View solution in original post
Make use of the table and list boxes to figure out issues in the data.
Thanks so much Gysbert! It is working perfectly. I didn't realize the concat actually first sorts the item list.
You mean at presentation layer? The real data is more complicated, so I have to organize well in data model. Thanks anyway. Gysbert's way is working perfectly in my case.
Yes Jing, on the presentation layer.