Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
chandana_gowdar
Creator II
Creator II

Year and Month Axis in Charts

Hi all ,

i have a dimension Year & '-' & Month used in the axis of a bar chart.

its displayed as shown below .. months order.PNG 

now i dont want to show years repetitively.. instead have one common label 2016 under those months which belong to 2016.

like wise for all years.

Kinldy help

Thanks

5 Replies
sudhirpkuwar
Partner
Partner

Why dont you use MonthYear as Dim

It will show like this

Jan-16,Feb-16,Mar-16.... and so on

which is better than showing the whole Year and Month

maxgro
MVP
MVP

this chart has 2 dimensions, year and month and 2 expression, the second expression is invisible

1.png

chandana_gowdar
Creator II
Creator II
Author

Hi Massimo,

Thanks for your reply , this works , but there are empty months coming up even when there is no data.

I tried checking Suppress null values option , but it doesn't work.

kindly suggest on what can be done in this situation.

Thanks

sudhirpkuwar
Partner
Partner

Make sure "Show All Values" is deselected in the Dimension tab

chandana_gowdar
Creator II
Creator II
Author

Hi Sudhir ,

The "Show All Values" is deselected in the Dimension tab , but seems like it doesn't work.


Have you tried ?


Thanks