Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

last 3 months calculation in Barchart


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...

8 Replies
Highlighted
Creator III
Creator III

see the attachement

Highlighted
Creator III
Creator III

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

Highlighted
Contributor II
Contributor II

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

Highlighted

Hi,

Just uncheck Supress when value is null for Category Dimension.

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Highlighted
Creator III
Creator III

refer to Qlikview Reference manual or help from qlikview desktop

Highlighted
Not applicable

Hi Bhagirath ,

thanks for you reply it works fine..

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

PFA,

Highlighted
Creator III
Creator III

check the script and take a reload

Highlighted
Not applicable

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.