Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rekha_jv
New Contributor III

WeekEndDate is not showing in Sequence

Hi,

Could any one help me. I have a bar graph with Di mention as Month and Year and Alternate Dimention as WeekEnd Date

When I select WeekEndDate the dates are not in sequence or chronological order. Have not done any sorting by default its in Auto.

Not sure why the dates are not in sequence.

Have put the screen shots for reference.

Your help will be highly appreciated.

Thank you in advance.

Rekha

2 Replies
stascher
Contributor

Re: WeekEndDate is not showing in Sequence

They're probably being sorted in load order.

Try changing the Sorting to explicitly be Numeric.

Also, verify that WeekEndDate is actually being loaded as a date object and not just as a string.

rekha_jv
New Contributor III

Re: WeekEndDate is not showing in Sequence

I am not sorting in load editor.

here is how I have used in Load editor

Date([OpenWeekEndDate]) AS [OpenWeekEndDate]

By changing the Sorting to Numeric also the dates are not falling in sequence.

Thank you,

Rekha J. v.