Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
mdb_blin
New Contributor

YearWeek in chronological order in a barchart

I am filtering by last 4 months(Nov-2018 to Feb 2019) which crosses into 2018. 

I am trying to get my bar chart to view week in chronological order?  Anyway to do this without having to affect the script?

I want it to show from Week 40(Nov 2018) and ending at Week 9 (Feb 2019).

Currently, it begins at Week 1.

 

 

2 Replies

Re: YearWeek in chronological order in a barchart

Hi,

Did you try to give the 'Expression' in the sort tab?

Capture.JPG

Partner
Partner

Re: YearWeek in chronological order in a barchart

Hi,
Try to use "Sort by Expression" and expression will be something like
Year*100+Week

Assuming both year and Week are numbers
Hope this helps!
//Andrei