topic Displaying null values in a bar chart in QlikView

Displaying null values in a bar chart

WalidChoukri — Tue, 08 Dec 2020 09:23:42 GMT

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

Re: Displaying null values in a bar chart

MayilVahanan — Tue, 08 Dec 2020 09:34:47 GMT

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.

Re: Displaying null values in a bar chart

WalidChoukri — Tue, 08 Dec 2020 09:53:21 GMT

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

Re: Displaying null values in a bar chart

MayilVahanan — Tue, 08 Dec 2020 10:00:20 GMT

Hi @WalidChoukri

Can you send the sample data?

Re: Displaying null values in a bar chart

WalidChoukri — Tue, 08 Dec 2020 10:16:10 GMT

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