Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Vince_CH
Creator III
Creator III

Line chart issues

Hello Community,

I have a linechart like below, with dimension in YearMonth, which couldn't be ranked in sequence automatically, i tried other options in the property ranked by number or letter, but still doens't work out,  do you know how to fix it?

Also on the bottom of chart, there is a minichart, which I want to hide, is it possible? thank you.

 

11.jpg

2 Replies
jheasley
Luminary Alumni
Luminary Alumni

sort it by expression:

Min(Date(FISCALYEARMONTH,'YYYY-MMM'))

you many need to play around with the formating of the date, or possible use date#() instead.

Vince_CH
Creator III
Creator III
Author

thanks, i used date#() trying with fiscal year and fiscal month combination. It worked with in similar calendar sequence from Jan to Dec, whereas my expectation is something like: Jul-2019, Aug-2019,Sep-2019,Oct-2019,Nov-2019,Dec-2019,Jan-2019....till Jun-2019.