topic Re: Sorting in Line Chart in QlikView

Sorting in Line Chart

hopkinsc — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

i am trying to get a line chart sorted as per the following..

i have week number on my x axis which is currently sorted numerically (1-52) but what i want is to sort it based on the last date that data was received.

The last date is 09/10/2017 which is week 41, so i want the chart to start at week 42 and end at 41.

can anyone help please?

i have attached an example.

Thanks

Re: Sorting in Line Chart

sunny_talwar — Tue, 09 Jan 2018 12:41:30 GMT

Try sorting by Max(Date) (Asc or Desc)

Re: Sorting in Line Chart

Anil_Babu_Samineni — Tue, 09 Jan 2018 12:43:10 GMT

May be use Calc. Dimension for Week like

=If(Week >= $(vMaxEndDate), Week)

Re: Sorting in Line Chart

hopkinsc — Tue, 09 Jan 2018 12:55:43 GMT

this is the first thing i tried (and the obvious one) but it doesnt work in my live qvw!

this might be difficult for me get help with then as i cant upload my live version.

i see it works in my sample though..

Re: Sorting in Line Chart

sunny_talwar — Tue, 09 Jan 2018 12:59:31 GMT

What is different between this sample and live version? Set Analysis? calculated dimension? anything else?

Re: Sorting in Line Chart

hopkinsc — Tue, 09 Jan 2018 13:03:42 GMT

No calculated dimensions and no set analysis. the only difference is the data model.

there are some synthetic keys which i will sort out now but up until now they've caused no problems.

maybe its those that are stopping this from working

Re: Sorting in Line Chart

sunny_talwar — Tue, 09 Jan 2018 13:04:46 GMT

Very difficult to say....

Re: Sorting in Line Chart

hopkinsc — Tue, 09 Jan 2018 13:10:09 GMT

no worries, thanks for your help, i will sort out these synthetic keys and try again.

Re: Sorting in Line Chart

hopkinsc — Tue, 09 Jan 2018 14:30:46 GMT

i have managed to get an example where its not working.

any chance you could see if anything jumps out? !

Re: Sorting in Line Chart

sunny_talwar — Tue, 09 Jan 2018 14:47:48 GMT

Try this

=Max({<MAT_Year = {'Current Year (MAT)'}>}nd_CALENDAR_YYYYMMDD)

Re: Sorting in Line Chart

stigchel — Tue, 09 Jan 2018 14:53:46 GMT

Try with

max({<raw_sales_volume={'>0'}>}nd_CALENDAR_YYYYMMDD)

Re: Sorting in Line Chart

hopkinsc — Tue, 09 Jan 2018 15:08:34 GMT

thats great, thanks so much for your help!