Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

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

Like this?

Capture.PNG

Used a pivot table and pivoted the day field

9 Replies

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

Something like this?

Capture.PNG

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

Not applicable

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?

Capture.PNG

Used a pivot table and pivoted the day field

Not applicable

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

Exactly like that! Thank you!

Not applicable

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

Not applicable

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'

Not applicable

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!

Community Browser