Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
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 II
Champion II

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

rsimson1
Contributor II
Contributor II
Author

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

vinieme12
Champion II
Champion II

so it is not a dupe then!?

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
Partner

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 II
Champion II

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

krishnacbe
Partner
Partner

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], ',')