Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Fixed x-axes in a chart


Hi,

in a chart there is an timeline on x-axes an i will display month begins with Oct an ends on Sep. In this case chart will display always the same view. If click on year, x-axes should have month and year, e.g. oct 13, nov 13, dec 13, jan 14, feb 14,…

Regards

Stefan

7 Replies
Not applicable
Author

Hi Stefan,

I'm not sure if I have understood you correctly but if you want to display the month and year in the dimension you need to concatonate the month and year fields together.

If you put this expression in the dimension

=Left(fy_mMMM,3) & ' ' & Right(year,2) 

I've done  that on your example and attached it back.  Like I say, I'm not entirely sure if this was what you were hoping for.

mr_janne
Contributor III
Contributor III

And an another example. I'm not completely sure what you want to do - you have a field named "mon_YY" which does what you need?

Not applicable
Author


I hadn't spotted that!  I seem to be forever seeking a complicated solution when there's a simpler one.

preminqlik
Specialist II
Specialist II

stefen hi again,

please find attachment

regards

Premhas

Anonymous
Not applicable
Author

Hi at all,

thanks for you solutions. The chart should have a fix x-axes. oct 13, noc 13,...sep 14, so i have 12 month, independent there are no values to be displayed.

Regards

Stefan

Anonymous
Not applicable
Author

Stefan

For your internal Calendar table, have you thought about changing it to using autogenerate and ensuring it contains the dates you require ?

Best Regards,     Bill

Anonymous
Not applicable
Author

Hi Bill,

in FYCalender i have only generate month and this should be displayed on x-axis. If i click on year in Listbox, year attached on month in chart x-axis.

Regards

Stefan