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: 
Not applicable

Straight chart of sales per day of entire product line? Can't work it out

Hello! new to Qlik and this has got to be easier than I'm making it out to be.

I have sales records that I'm trying to build a chart of that shows by vehicle line the total sales per day in a given month.

Straight chart with the vehicle line as a dimension, then each day of the month as a dimension, and the count of sales per vehicle line per day.

I must be overthinking this somehow.

I've attached my rough beginnings and the source data.

1 Solution

Accepted Solutions
sunny_talwar

Like this?

Capture.PNG

Used a pivot table and pivoted the day field

View solution in original post

9 Replies
sunny_talwar

Something like this?

Capture.PNG

Used Day as the dimension and removed Day = {4} from set analysis

Not applicable
Author

Very close, but I need each day of the month to be a column, and each vehicle line to be a row showing the # of sales per day.

sunny_talwar

Like this?

Capture.PNG

Used a pivot table and pivoted the day field

Not applicable
Author

Exactly like that! Thank you!

Not applicable
Author

How do I get days without any sales to still appear?

sunny_talwar

Uncheck 'Suppress Zero Values' on the presentation tab...

Not applicable
Author

That works! but now I have a row of zeros and a column of zeros. Strange, any way to hide that row/column without losing the other days that have zeros for every row?

sunny_talwar

Try the attached

Changed the expression and added back the 'Suppress Zero Value'

Not applicable
Author

AWESOME thank you! Seems like a really long way around, but I'll take it!