Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
risabhroy_03
Partner - Creator II
Partner - Creator II

Auto row merge

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 - 

risabhroy_03_0-1660294514079.png

 

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.

1 Reply
Vegar
MVP
MVP

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)