What is wrong with my chart as the numbers are WAY off

[#1]

I am try to make a line chart of what is currently a straight chart table.

My table shows 412 items and I am attempting to line chart them over time.

However, when I build the line chart (and turn on full accumulation so I can see the total number of issues), I get a number of 669, and a 'Date = -' field (with over 1600 issues) at the very right of the chart.

The expression I'm using is based on selections and is a simple Count(Variable).  How are the numbers from the same exact set of selections so drastically different?

[sunny_talwar]

Try checking 'Suppress When Value is Null' on dimension tab of the chart properties and see if that helps.

Best,

Sunny

[#3]

Ok, that got rid of my date = - problem, but my final number 669 is still well above the 412 it should be.

When I suppress null, what exactly am I suppressing?

[sunny_talwar]

You are suppressing the Dimension where its Null and I would think that it should suppress the value associated with it as well, but surely that is not happening. Would you be able to share a sample?

Best,

Sunny

[Colin-Albert]

Are the totals for each date correct if accumulation is not enabled?

[#6]

Actually,  the totals without accumulation are not correct.  I singled out a given day, and my straight table chart shows 6, but my line chart shows 10.  How do I determine what else the line chart is pulling in as data?

A little more information, I have several different date fields and I have created a linked date calendar in addition to calendars for each type of date (Created, updated, resolved).   The date I am using for this particular table chart and line chart is "LDate", or the linked date that pulls anything relevant to a specific date.

[#7]

Unfortunately the data is very sensitive and I can't share anything other than what I've already shared.

[sunny_talwar]

We might just need few rows of data which can be representative of your actual data.

[Colin-Albert]

You need to get the values correct before applying accumulate.

Can you add some listboxes to filter the data to help identify why the values are incorrect?

I would suggest cloning the chart and working with a straight table to get the expression correct.

You can add additional dimension fields to the table to see what values Qlik is calculating.

Can you post your expression?

[#10]

My expression is simple - "Count(Master ID)".

I should be counting based on the selections.  I'll expose every field in list boxes to see if I can see what isn't right.

I just find it odd that one table shows 6, and the chart based on the same data shows 10 for that single date.