
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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...

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
see the attachement

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Can you change these and other such settings programatically and is there a list of such settings with syntax in the QlikView documentation?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Just uncheck Supress when value is null for Category Dimension.
Regards
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
refer to Qlikview Reference manual or help from qlikview desktop

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Bhagirath ,
thanks for you reply it works fine..
But in my question i forgot to add one more condition,
PFA,

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
check the script and take a reload

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
