Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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)