

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Show only Months with Values
Hello dear QlikView-Community,
maybe you can help me with following problem:
I created a bar-chart for the years 2017 and 2018. Since I do not have any values for January until September 2017, I dont want this months to be shown in the chart. Also I dont have values for September, October, November and December 2018 yet, so I dont want this months to be shown either.
My dimensions are: Year and Month
My Value is the sum of sales, but there are just sales from October 2017 until August 2018.
I know the option "Do not show 0-values" in properties, but it doesnt influence something.
I would be grateful for help.
Thank you,
Jakob
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How about if you use a single dimension instead of two?
=Date#(Monat&'-'&Year, 'MMM-YYYY')

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Jacob,
Could you upload a sample file here? It will be easy for us to provide the solution.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
This is an example i created with random-values:
--------------------2017-----------------------------------------------//-------------------------2018-----------------------------------------
The months without value should not get shown.
Greetings

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jakob - Please attache the sample file (which you created) here.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
i attached it including data, thank you


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Just promote you Month dimension ahead of year.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Deepak,
if I do so, my Chart looks like:
But I dont want Month & Year mixed, I want it like this (but emtpy month not shown):
Greetings
Jakob

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How about if you use a single dimension instead of two?
=Date#(Monat&'-'&Year, 'MMM-YYYY')


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
WORKS PERFECTLY
Thank you Sunny!
