topic Re: Bar chart showing dimension with no data in QlikView

Bar chart showing dimension with no data

Zaga_69 — Sat, 16 Nov 2024 00:39:43 GMT

Hi all,

I want to create a bar chart using time as dimension. However, for period beyond 2020-04 I do not have any data in my dataset, then even using a master calendar, the full 12 months for 2020 are not shown in the graph. I enabled also "Include null values".

This is more less the dataset:

I suspect that it is not working because when filtering by Scenario="ACT" the dataset contain any data for period higher than 2020-04 even if I am using the YearMonth field from the master calendar.

Any idea?

BR,

Edi

Re: Bar chart showing dimension with no data

Akhil_Reddy — Sun, 17 May 2020 17:15:34 GMT

I think the only option is create inline table with fields

load * inline

[year-month],[sales],[scenario]

2020-6, ,ACT

2020-8, ,ACT

2020-12 , ,ACT

concatenate the above table to the dataset.

create 2 expressions

expression1 - sum(sales)

expression2 - 1

now for expression2 uncheck the 'bar' under 'display options'.

now even though you select 'ACT' all the yearmonths going to show with null value.