Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Could you post a screenshot or a sample QVF that shows your issue?
Can you provide a screenshot of what the problem is?
see all the grey that shouldnt be there
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
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.
Those are all values aggregated for having no dimension value (NULL). You can filter them out in dimension properties..
Thanks Guys
I have checked both comments. I dont have duplicate data and I havent got null at all
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.
Then you have data from two different tables with no overlap..