Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

JustinDallas
Valued Contributor II

Why doesn't Qlik show duplicate but different rows?

Hello Folks,

I've got a table, and when the contents of two rows are the same, it doesn't show that row twice, it just shows it once.  Of course, any sums balance out correctly, but for some users may be astonished that the row count doesn't match.  Generally, this problem goes away when you add a column/measure that breaks the tie.  I've attached a QVW that shows the phenomenon I'm talking about.

Is there a way to make the Table show equivalent but different rows without adding a tie breaker?  I've attached an image and a QVW demonstrating what I'm talking about.

Snippet.PNG

Thank you to anyone who can shed light on this issue.

1 Solution

Accepted Solutions

Re: Why doesn't Qlik show duplicate but different rows?

This is the way Qlik works.  For any chart, or a table, you will get a single row for each unique combinations of Dimension values.

In QlikView, you can add your "tie breaker column (KeyId)" and make it invisible on the Presentation tab.  You still get a row for each KeyId but the KeyId is not visible.

In Qlik Sense table viz, the hide feature is not available. You would need to use an extension. The vizlib table almost supports hidden columns as you are allowed to set a fixed column width. The min value on the slider is 10px but I bet if you contacted vizlib rbecher they would look into making the min 0px.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

3 Replies

Re: Why doesn't Qlik show duplicate but different rows?

This is the way Qlik works.  For any chart, or a table, you will get a single row for each unique combinations of Dimension values.

In QlikView, you can add your "tie breaker column (KeyId)" and make it invisible on the Presentation tab.  You still get a row for each KeyId but the KeyId is not visible.

In Qlik Sense table viz, the hide feature is not available. You would need to use an extension. The vizlib table almost supports hidden columns as you are allowed to set a fixed column width. The min value on the slider is 10px but I bet if you contacted vizlib rbecher they would look into making the min 0px.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

MVP
MVP

Re: Why doesn't Qlik show duplicate but different rows?

Good idea rwunderlich‌ ! Will have a look into having a 0px col in the vizlib table

- Ralf

mov
Esteemed Contributor III

Re: Why doesn't Qlik show duplicate but different rows?

I just make the Id column as narrow as possible, and text color white.  The only drawback that it is visible on export.  Trying not to overuse extensions if possible.

Community Browser