Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Qlik Sense graphs

Why all of my graphs on Qlik sense showing me the breakdown; as well as the total of all the breakdowns added together? This is screwing up my visuals.

EG

Cakes 342

Chocolates 111

Peanuts 222

Total adds up to 673 so if I show a pie graph is displays 342; 111; 222 and 673. I dont want it to show 673

10 Replies
MVP
MVP

Re: Qlik Sense graphs

Could you post a screenshot or a sample QVF that shows your issue?

TKendrick20
Valued Contributor

Re: Qlik Sense graphs

Can you provide a screenshot of what the problem is?

Not applicable

Re: Qlik Sense graphs

Capture.PNGsee all the grey that shouldnt be there

Not applicable

Re: Qlik Sense graphs

Capture.PNG the greyed out bit -  321923  is the sum of all of the numbers in a row. I dont want to see the sum in graphs or tables or anything. And its not like my data has the sum at the end, so not too sure why its displaying it in the graphs etc

reddys310
Honored Contributor II

Re: Qlik Sense graphs

Hi Barbara,

Looks there is an issue with your datamodel. You have duplicates of all the records in your data model and thats the reason why your totals look doubled.

Review your datamodel. Check for joins/auto concatenation etc

Thanks,

Sangram.

MVP
MVP

Re: Qlik Sense graphs

Those are all values aggregated for having no dimension value (NULL). You can filter them out in dimension properties..

Not applicable

Re: Qlik Sense graphs

Thanks Guys

I have checked both comments. I dont have duplicate data and I havent got null at all

TKendrick20
Valued Contributor

Re: Qlik Sense graphs

All of your charts will have this button to show null values. Make sure it is not checked.

Show Null Values.PNG

Additionally, depending on your data model, you may consider using the DISTINCT keyword to avoid counting duplicate records where you do not intend to.

MVP
MVP

Re: Qlik Sense graphs

Then you have data from two different tables with no overlap..

Community Browser