Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

tenyeapen
New Contributor

Bar Chart + Null

In a bar chart i have to select data from 2 feilds namely year and month. but if i select year 2019 and month december (this search doesnt have any value), the chart will show the value for all decmeber cases in theprevious months. How to avoid this?

2 Replies

Re: Bar Chart + Null

Hi, maybe there is no row with year 2019 and month dec, if you select 2019 and december has a grey background that means that there is no relation between those fields values, so Qlik removes one (or many) selections to allow you to select month december.

Maybe cerating a maester calendar so at least there is a relation between 2019 and december, one.

Here is one way of doing it:

Calendar:
LOAD
IdDate as IdDate,
Date(IdDate) as Date,
Month(IdDate) as Month,
Year(IdDate) as Year
;
LOAD
AddMonths(MinDate, IterNo()-1) as IdDate
While AddMonths(MinDate, IterNo()-1) <= MaxDate
;
LOAD
YearStart(Min(FieldValue('IdDate', RecNo()))) as MinDate,
Floor(YearEnd(Max(FieldValue('IdDate', RecNo())))) as MaxDate
AutoGenerate FieldValueCount('IdDate')
;

// change IdDate to your current date field, you can create one using "Makedate(YearField, MonthField) as IdDate"
tenyeapen
New Contributor

Re: Bar Chart + Null

It didn't went correctly.. 😞