Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming Aug. 9: New Simplified Authoring for Qlik Sense SaaS – For Details, CLICK HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
jakobjosef
Creator II
Creator II

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

1 Solution

Accepted Solutions
sunny_talwar

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

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


Capture.PNG

View solution in original post

8 Replies
tamilarasu
Champion
Champion

Hi Jacob,

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

jakobjosef
Creator II
Creator II
Author

This is an example i created with random-values:

Tamil.PNG

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

The months without value should not get shown.

Greetings

tamilarasu
Champion
Champion

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

jakobjosef
Creator II
Creator II
Author

i attached it including data, thank you

dsharmaqv
Creator III
Creator III

Just promote you Month dimension ahead of year.

jakobjosef
Creator II
Creator II
Author

Hi Deepak,

if I do so, my Chart looks like:

deepak1.PNG

But I dont want Month & Year mixed, I want it like this (but emtpy month not shown):

deepak2.PNG

Greetings

Jakob

sunny_talwar

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

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


Capture.PNG

jakobjosef
Creator II
Creator II
Author

WORKS PERFECTLY

Thank you Sunny!