topic Re: Show only Months with Values in QlikView

Show only Months with Values

jakobjosef — Wed, 01 Aug 2018 06:13:56 GMT

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

Re: Show only Months with Values

tamilarasu — Wed, 01 Aug 2018 06:32:42 GMT

Hi Jacob,

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

Re: Show only Months with Values

jakobjosef — Wed, 01 Aug 2018 06:42:21 GMT

This is an example i created with random-values:

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

The months without value should not get shown.

Greetings

Re: Show only Months with Values

tamilarasu — Wed, 01 Aug 2018 07:24:56 GMT

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

Re: Show only Months with Values

jakobjosef — Wed, 01 Aug 2018 08:11:33 GMT

i attached it including data, thank you

Re: Show only Months with Values

dsharmaqv — Wed, 01 Aug 2018 09:48:36 GMT

Just promote you Month dimension ahead of year.

Re: Show only Months with Values

jakobjosef — Wed, 01 Aug 2018 11:12:40 GMT

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

Re: Show only Months with Values

sunny_talwar — Wed, 01 Aug 2018 11:31:47 GMT

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

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

Re: Show only Months with Values

jakobjosef — Wed, 01 Aug 2018 11:37:22 GMT

WORKS PERFECTLY

Thank you Sunny!