Discussion board where members can learn more about Qlik Sense App Development and Usage.
I have a table in which the an ID appears several times, but for each, there's only one field that is not null:
Is there a way in which I could merge these into a single row?
PS. I built this table from another one that looked like this:
Therefore, if this could be solved more easily by changing the way the table is constructed I could do it too.
If I understand you correctly you want one row with the Stage*Date variables, i.e.
This can be achieved via Left Join prefix and Where clause.
Where Not IsNull(Stage1Date);
Where Not IsNull(Stage2Date);
See attachment for little explanation and example.
View solution in original post