topic Show missing data as 0 in QlikView

Show missing data as 0

Sumit2504 — Wed, 27 Jan 2021 06:52:46 GMT

Hi All,

I've a country eg ABC, it's data is missing in source DB for weeks 12, 13, 14, 17 and 50.

As I already have a master calendar, so I can see missing weeks as grayed out (Excluded) in list box.

Is there any way I can show data as 0 for those missing weeks in a line chart.

List of dimension and measures used in line chart.

Dimension - Week

Measure - Count(app_Id)

Regards,

Sumit

Re: Show missing data as 0

MayilVahanan — Wed, 27 Jan 2021 07:58:46 GMT

HI @Sumit2504

Try like below

In Dimension tab, check below option

In Presentation tab, check like below

Hope it helps

Re: Show missing data as 0

Sumit2504 — Wed, 27 Jan 2021 08:02:51 GMT

Hi @MayilVahanan ,

I used "Show All Values" to force the missing weeks to display. It does display with the line going to 0 properly. However, the chart shows ALL weeks and it'll deselect the range I've selected. So this won't work for my case

Re: Show missing data as 0

MayilVahanan — Wed, 27 Jan 2021 08:20:18 GMT

Hi @Sumit2504

In that case, u need to generate missed week info in script by assigning zero values.

Hope it helps.