topic Re: Duplicate values are not shown in chart in App Development

Duplicate values are not shown in chart

nskatzis — Thu, 30 Mar 2023 08:41:14 GMT

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 — Thu, 30 Mar 2023 10:18:49 GMT

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 — Thu, 30 Mar 2023 10:11:21 GMT

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

BrunPierre — Thu, 30 Mar 2023 12:07:21 GMT

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 — Thu, 30 Mar 2023 12:16:31 GMT

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 — Thu, 30 Mar 2023 12:29:22 GMT

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