Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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?

11 Replies
Colin-Albert
Partner - Champion
Partner - Champion

Do you need a distinct count?

Is the figure correct with       count( DISTINCT [Master ID])

Not applicable
Author

Ok, turns out using my LDate field was where things were going wrong.  Once I used a date field that pulled from only a single table, the DISTINCT gave me the right number.

Thanks for the help everyone.