Qlik Community

Ask a Question

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Qlik Sense does not show rows with exactly the same data

Hi,

Today I discovered an odd thing in Qlik Sense.

I have a dataset where there are some rows that are exactly the same. All columns and data are the same for two rows. The dataset consists only of one table and no data modelling is done.

If I do a table with only dimensions (no aggregation), I only get one row of two. If I sum the data (amount paid), I get the sum of both rows.

I have checked the app in 3 different environments (prod, test and desktop) - all with the same result. 

Can anyone of you explain this, and more importantly how can I fix this behaviour?

Thank you.

P.S. I can't share the dataset, as it is highly sensitive.

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

It's one of the main-features of Qlik that only distinct values are displayed in objects. It has nothing to do with hiding data else the data are intentionally stored in this way because Qlik follows no SQL-like row-based storing else it's a column-based storing and this leads to a significantly better performance.

If there is any reason to validate the data against the source-data (usually only during the development) it's useful to follow the suggestion from @mikaelsc to add recno() and/or rowno() to the loads - but after that they won't be needed respectively they become a disadvantage.

- Marcus

 

View solution in original post

3 Replies
Creator III
Creator III

qlik will only show unique values. 

add a differentiating field to your model and your table... you'll get what you want 

 

(for example rowno() as UniqueRecID, )

Contributor III
Contributor III

Thank you @mikaelsc 

Do you know if this is a feature in Qlik Sense? Can it be found in the documentation?

I am asking because I think it is odd to create this behaviour. I do not like when a programme "hides" data without me asking it to do so.


MVP & Luminary
MVP & Luminary

It's one of the main-features of Qlik that only distinct values are displayed in objects. It has nothing to do with hiding data else the data are intentionally stored in this way because Qlik follows no SQL-like row-based storing else it's a column-based storing and this leads to a significantly better performance.

If there is any reason to validate the data against the source-data (usually only during the development) it's useful to follow the suggestion from @mikaelsc to add recno() and/or rowno() to the loads - but after that they won't be needed respectively they become a disadvantage.

- Marcus

 

View solution in original post