Duplicate values are not shown in chart

[nskatzis]

Hello,

I noticed that Qlik sense cuts the duplicate rows from charts.

I have a table chart and it only displays once, the rows that have the same values to all the columns.

See the attached excel which is exported from my table:

In the first sheet, all the rows (6) exist because I added an extra column (E).

But when I omit this column, the last row is lost and I have 5 rows.

This is a huge problem because I can't get the results displayed in a chart.

To add an extra column is not an option because I have sum fields in the chart.

Is there any way to display duplicate rows as well?

Thank you,

Nikos

[BrunPierre]

Hello @nskatzis, in your load statement, use RowNo() to generate a unique row id.

LOAD *,
RowNo() as ID
.....

And an expression like this would count the records records including duplicates.

Count(Aggr(Count([Rec. WBS element_RPROJ]), ID))

[nskatzis]

But still I need to include id in my chart, right?

[BrunPierre]

The ID column can be hidden under the presentation when using a straight table in QV, so it's not always necessary.

In QS, however, I'm yet to see such a feature.

[nskatzis]

In my opinion, QS table views should have an option to keep or not duplicate values.

From the moment that such option does not exist, the values should be summed up for the duplicated rows that they are not shown.

I appreciate your help,

Nikos

[Or]

https://community.qlik.com/t5/forums/postpage/board-id/qlik-ideas/search-before-post-mode/true

I wouldn't expect it to get much traction, though - Qlik focuses on displaying data, not rows of text.