Show only Months with Values

[jakobjosef]

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

[tamilarasu]

Hi Jacob,

Could you upload a sample file here? It will be easy for us to provide the solution.

[jakobjosef]

This is an example i created with random-values:

--------------------2017-----------------------------------------------//-------------------------2018-----------------------------------------

The months without value should not get shown.

Greetings

[tamilarasu]

Jakob - Please attache the sample file (which you created) here.

[jakobjosef]

i attached it including data, thank you

[dsharmaqv]

Just promote you Month dimension ahead of year.

[jakobjosef]

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

[sunny_talwar · Accepted solution]

How about if you use a single dimension instead of two?

=Date#(Monat&'-'&Year, 'MMM-YYYY')

[jakobjosef]

WORKS PERFECTLY

Thank you Sunny!