Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Vince_CH
Contributor II

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

Tags (1)
Labels (1)
2 Replies
Luminary
Luminary

Re: Line chart issues

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
Contributor II

Re: Line chart issues

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.