Displaying null values in a bar chart

[WalidChoukri]

Hello guys,

I'm new to qlikview and i'm facing a problem right now, I'm trying to display the history of consumption of a product, the chart displays only the weeks where there was a consumption, i need it to add all weeks with 0 value, 

like week 1 value 0

        week 2 value 0

        week 3 value  400 and so on

Any ideas, thanks for your help

[MayilVahanan]

Hi @WalidChoukri 

Based on ur screenshot, week 1, 2 are not associated with ur article. That's the reason, its not displaying in the chart. 

You need to amend the data in ur data model with zero data for missed date / week.

[WalidChoukri]

@MayilVahanan  Thanks for your reply.

Actually i did add all weeks in my data model, the problem is the chart only displays the weeks where the "qty conso" in not null, i tried show all values option but it didn't work.

[MayilVahanan]

Hi @WalidChoukri 

Can you send the sample data? 

[WalidChoukri · Accepted solution]

Actually i figured it out, just have to keep "show all Values" checked in dimension tab and uncheck "suppress missing" in the presentation tab.

Thank you @MayilVahanan