Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

kathleene
New Contributor III

Show all days of week even when no data to display

Hello,

I'm creating a bar chart that shows sum of items sold by day of week.  In my example there aren't any sales for Friday; I would like Friday to show on the axis.  How do I do that? 

I've attached an app with sample data.

Thanks

Kathleen

Tags (1)
1 Solution

Accepted Solutions

Re: Show all days of week even when no data to display

Two things

1) Uncheck 'Suppress Zero-Values' on the Presentation tab

2) Check 'Suppress When Value Is Null' on the Dimensions tab

Capture.PNG

View solution in original post

2 Replies

Re: Show all days of week even when no data to display

Two things

1) Uncheck 'Suppress Zero-Values' on the Presentation tab

2) Check 'Suppress When Value Is Null' on the Dimensions tab

Capture.PNG

View solution in original post

kathleene
New Contributor III

Re: Show all days of week even when no data to display

Thanks Sunny Talwar; I appreciate the help. 

Kathleen