Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a below Inline Table
[Test]:
Load * Inline [
Document_No,Transaction Type,Amount
1,2,400
1,2,100
1,2,400
1,2,400
];
My table looks as below -
But I want all the records to be displayed but Qlik is automatically merging the rows.
I don't want that. I want all my rows to be displayed even if they are duplicates.
Please help.
This is how Qlik Sense works. A workaround is to add a unique row ID field to your data and add that one to your visualisation as a column.
Another way to not loose the duplicate information could be to replace the dimension Amount with a measure sum(amount) or add an new measure to count the no of recorss that are consolidated into each row: count(Document_No)