Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I'm hitting a wall on this one... My data set is relatively simple. Yet for some reason, I'm not getting the right totals.
I am only dealing with two fields at this time: a Date/Time field, and an Employee field. I need to graph the number of Conditions ordered over time, with respect to employee. Ideally, Something like this:
To achieve the graph above, I have used the following setup:
Dimension 1: [ConditionOrdered.autoCalendar.Date]
Dimension 2: Employee
Measure: Count([ConditionOrdered])
It seems like this should work, but the totals are off from what they should be. As an example, I have attached data from the most recent business day. Without the [Employee] dimension, the graph shows that there were 109 orders made, whereas with the [Employee] dimension, I get a total of 103. It makes sense that the two blanks in the [Employee] field would not be counted, but that does not account for another four that aren't being counted.
Has anyone had a similar issue when including a second dimension? Any ideas for solutions?
Thanks,
Aaron
When I removed continuous scale from X axis, it started showing 109, also it shows dots for Bree and Isabel for me.
See attached
It could be a date thing. Are you doing any date conversions?
The only manipulation that I can see is what Qlik did automatically.
The format in Excel is MM/DD/YYY hh:mm. The data is loaded into Qlik with the timestamp() function and assigned to the autoCalendar.
I see the correct total in straight table even with employee dim, I am not sure how did you count total with one day data in line chart. See attached.
My data set is larger. I just singled out one day to make things simpler.
Yes, the straight table has the correct total. The pivot table does as well. However, if we set the graph that you made to a stacked area graph, it does not have the correct total. This is the same problem that I am facing. (Notice that even with null values included, the stacked total is only 104, where it should be 109.)
When I select Bree or Isabel from the legend, no dots are highlighted. This would account for the lost 5 orders, but why would they not be included in the graph?
When Bree is selected:
When Emily is selected:
When I removed continuous scale from X axis, it started showing 109, also it shows dots for Bree and Isabel for me.
See attached
Check this out.Attached is the qvf.
Removing the continuous scale did it! Although I still don't understand why... Any ideas?
Looks like a bug to me as I am not finding any reason of change in total due to some feature but at the same time I don't use continuous scale so cannot be 100% sure.