Discussion Board for collaboration related to QlikView App Development.
I have the following data in my QV table
I would my table to show distinct ID and associated subjects - so this is want I'd like to output
Any suggestions please
Are there only a maximum of 2? You could create a more dynamic loop if there are more, but this should work for two:
Subject AS Subject1
WHERE Not ID = Previous(ID)
ORDER BY ID, Subject;
Left Join (NewTable)
Subject AS Subject2
WHERE ID = Previous(ID)
View solution in original post
No I have 4870 IDs and 4999 subjects. I just provided a sample. I really wanted do this as an expression in a table.
Thank you. That worked perfectly. I managed to put it into the script.