topic Re: Duplicate row appearing in table in QlikView

Duplicate row appearing in table

rsimson1 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a duplicate row appearing in my table. This look to be getting caused by the Award Value appearing twice in my table and when I bring it in as a dimension it duplicates the row. When I don't include Award Value in the dimension table then all the values appear on the one row which is what I'm trying to achieve.

Can anybody help?

Re: Duplicate row appearing in table

vinieme12 — Fri, 27 Jan 2017 14:13:49 GMT

are you doing any join to add Award category field to your main table?

or the associated table has a null [Award Category] for reference A01LV5SOUN16S with Fe Disc.. value at 57.4 quids!!

Re: Duplicate row appearing in table

rsimson1 — Fri, 27 Jan 2017 14:15:39 GMT

No there is no join.... the associated table has a null value

Re: Duplicate row appearing in table

vinieme12 — Fri, 27 Jan 2017 14:16:48 GMT

so it is not a dupe then!?

Re: Duplicate row appearing in table

rsimson1 — Fri, 27 Jan 2017 14:19:05 GMT

No its not a duplicate in back end table but only when drawn into the table but I want to merge the values and only have one line

Re: Duplicate row appearing in table

krishnacbe — Fri, 27 Jan 2017 14:48:03 GMT

Do you want to show the Null records for Award Category?

If not then you can check the "Suppress Null Value" for the Award Category.

Re: Duplicate row appearing in table

rsimson1 — Fri, 27 Jan 2017 14:49:38 GMT

Yes I do want to show them but I want all the values to be merged...

Re: Duplicate row appearing in table

vinieme12 — Fri, 27 Jan 2017 14:56:44 GMT

Can you upload a sample?

or i think you might have to do this

Dimensions:

Age,

Maintenance,

Reference,

Name,

AGGR(Concat(Distinct Award Category),Reference)

Expressions:

Sum(TotalPaid)

sum(Maint Paid)

Sum(Travel Paid)

SUM(ASN)

SUM(Study Exprense)

Sum(FE ChildCare)

Sum(FE Disc.)

Re: Duplicate row appearing in table

krishnacbe — Fri, 27 Jan 2017 14:57:46 GMT

Can you please share the qvw to debug and help you to fix the issue?

Re: Duplicate row appearing in table

maxgro — Fri, 27 Jan 2017 15:12:47 GMT

try with an expression instead of a dimension

concat(DISTINCT [Award Category], ',')