Qlik Sense Duplicate Row Behavior

[Sonja_Bauernfeind]

Duplicate rows are suppressed in Qlik Sense table charts.

Environment:

Qlik Sense Enterprise on Windows 
Qlik Cloud 
Qlik Sense Business 

This is the intended behaviour for Qlik Sense. The Qlik engine suppresses the duplicate rows in charts and tables when all the dimensions have the same values. This way the chart only shows rows that represent a distinct combination of dimension values.

The workaround for this, when the end-user desires to see the duplicate rows, is to add an additional column to the data source during the data load.

The functions recno() or rowno() can be used to add a column that then makes every row unique. Please see the help.qlik.com site for more details on when these functions can be used.