last 3 months calculation in Barchart

[#1]

Hi,

I want to calculate sum(value) based on months(last 3 months) and Category.

So i used set analysis in expression. It works fine.

But zero vales are not visible in bar chart.

For Ex:

If the current month is March. Then Bar chart has to show Jan, Feb and Mar as month.

I dont have data for feb month, but has to show sum(value) as 0(Zero).

It is showing only Jan and Mar month.

Please help me on this.

PFA,

Thanks in Advance...

[Anonymous]

see the attachement

[Anonymous]

you need to take a look on properties>dimension>suppress when value is null

for all the dimensions

and  properties>Presentation>Suppress Missing

for expressions

[Anonymous]

Can you change these and other such settings programatically and is there a list of such settings with syntax in the QlikView documentation? 

[PrashantSangle]

Hi,

Just uncheck Supress when value is null for Category Dimension.

Regards

[Anonymous]

refer to Qlikview Reference manual or help from qlikview desktop

[#7]

Hi Bhagirath ,

thanks for you reply it works fine..

But in my question i forgot to add one more condition,

PFA,

[Anonymous]

check the script and take a reload

[#9]

Hi Bhagirath,

Thanks for your reply.

I checked script..

While posting question, I forgot to add one more field in script and expression.

So again i attached excel and .qvw

please look into that.