topic Re: Bar Chart - Null Feilds in QlikView

Bar Chart - Null Feilds

tenyeapen — Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: Bar Chart - Null Feilds

tresB — Tue, 12 Feb 2019 07:17:28 GMT

Could you share your sample app that demonstrates the issue/behavior?

Re: Bar Chart - Null Feilds

gn_marvs1989 — Tue, 12 Feb 2019 07:18:02 GMT

On the Dimension property of your Bar chart, Check on the "Show all value"

Re: Bar Chart - Null Feilds

tenyeapen — Tue, 12 Feb 2019 09:00:38 GMT

Below is my chart and when im selecting year 2019 and month December (which no data is there) instead of giving null chart its giving the values for previous years December values which I don't want.

[cid:image001.png@01D4C2D2.D9ED3830]

Re: Bar Chart - Null Feilds

tenyeapen — Tue, 12 Feb 2019 09:15:13 GMT

Attached is my chart and when im selecting year 2019 and month December (which no data is there) instead of giving null chart its giving the values for previous years December values which I don’t want.

Re: Bar Chart - Null Feilds

gn_marvs1989 — Tue, 12 Feb 2019 13:14:24 GMT

It is better if you can give us a QVW to check. I am suspecting that it there should be change in the expression.

Re: Bar Chart - Null Feilds

tenyeapen — Tue, 12 Feb 2019 13:24:03 GMT

.qvw file attached.

Re: Bar Chart - Null Feilds

gn_marvs1989 — Wed, 13 Feb 2019 07:27:59 GMT

It is because of Qlikview Associative selection. It is normal behavior. Notice the current selection, if you make a selection on Month= December and then select Year=2019, the Month selection will be cleared out.
I suggest you to use a Master Calendar table to have complete Year and Month. This will make you select both Month and Year without clearing each other selections.