Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
acbishop2
Creator
Creator

Second Dimension Alters Totals

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:

Count of Orders by Employee.JPG

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

1 Solution

Accepted Solutions
Digvijay_Singh

When I removed continuous scale from X axis, it started showing 109, also it shows dots for Bree and Isabel for me.

See attached

Capture.PNG

View solution in original post

9 Replies
siddharth_s3
Partner - Creator II
Partner - Creator II

It could be a date thing. Are you doing any date conversions?

acbishop2
Creator
Creator
Author

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.

Digvijay_Singh

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.

acbishop2
Creator
Creator
Author

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.)

Count of Orders by Employee2.JPG

acbishop2
Creator
Creator
Author

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:

Bree.JPG

When Emily is selected:

Emily.JPG

Digvijay_Singh

When I removed continuous scale from X axis, it started showing 109, also it shows dots for Bree and Isabel for me.

See attached

Capture.PNG

krishna_2644
Specialist III
Specialist III

Check this out.Attached is the qvf.

1.PNG

acbishop2
Creator
Creator
Author

Removing the continuous scale did it! Although I still don't understand why... Any ideas?

Digvijay_Singh

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.