Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
KSONI23
Contributor II
Contributor II

Mini Chart - Order of dates in mini chart

Hi 

 

How can I ensure the mini chart I am using is in the correct date order? The dimension I am using is to split the data to look back 6 months .

 

The spark line used in the mini chart seems to be starting from latest date to the oldest date. How can I get it so it start with the earliest date first?

 

Thanks

Krishna

 

 

Labels (1)
2 Replies
Mark_Little
Luminary
Luminary

HI @KSONI23 

I haven't seen this problem before, normally it orders it self by date. How is the column ordered in a filter or table if you drop it on?

Mark

KSONI23
Contributor II
Contributor II
Author

Thanks for getting back to me. 

When I drop the month field into a table, it appears from old to latest date .

But in the spark link , the graph seems to show the opposite trend as i am expected . I cannot check the points of the months on the spark line, as when i hover over it the average appears for the duration of month. this number is correct its just the trend it self seems to be the wrong way round.

This is the filter i am using on the spark line 

KSONI23_0-1660294135197.png