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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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.