Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Something like this?
Used Day as the dimension and removed Day = {4} from set analysis
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.
Like this?
Used a pivot table and pivoted the day field
Exactly like that! Thank you!
How do I get days without any sales to still appear?
Uncheck 'Suppress Zero Values' on the presentation tab...
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?
Try the attached
Changed the expression and added back the 'Suppress Zero Value'
AWESOME thank you! Seems like a really long way around, but I'll take it!