Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rsimson1
Contributor II
Contributor II

Duplicate row appearing in table

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?

9 Replies
vinieme12
Champion III
Champion III

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!!

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
rsimson1
Contributor II
Contributor II
Author

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

vinieme12
Champion III
Champion III

so it is not a dupe then!?

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
rsimson1
Contributor II
Contributor II
Author

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

krishnacbe
Partner - Specialist III
Partner - Specialist III

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.

rsimson1
Contributor II
Contributor II
Author

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

vinieme12
Champion III
Champion III

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.)

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
krishnacbe
Partner - Specialist III
Partner - Specialist III

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

maxgro
MVP
MVP

try with an expression instead of a dimension

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