Qlik Sense graphs

[#1]

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

[swuehl]

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

[TKendrick20]

Can you provide a screenshot of what the problem is?

[#4]

see all the grey that shouldnt be there

[#5]

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

[reddy-s]

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.

[rbecher]

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

[#8]

Thanks Guys

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

[TKendrick20]

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

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

[rbecher]

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