9 Replies Latest reply: Apr 10, 2017 3:12 PM by Harold McCormick

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

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

Something like this?

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

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

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.

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

Like this?

Used a pivot table and pivoted the day field

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

Exactly like that! Thank you!

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

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

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

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

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

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?

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

Try the attached

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

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

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