Sorting issue in line graph in Qliksense

[berryandcherry6]

Hi,

i have a graph which shows data for last 8 weeks, with

Dimension: Week

Expression: Count(Invitation)

Here i need to display graph to show data with order of week in ascending order. Currently week is jumbled. How to sort it in week order.

I have made all to auto sorting in Sorting Tab of Qliksense.

[vinieme12]

replace Datefield with the field using which you are creating the weeks!

[berryandcherry6]

Thanks for reply!

No vineeth, its not working. Can you download attached qvf file.

[berryandcherry6]

I am not able to view your sent file.Its not atall opening

[Silambarasan1306]

Go to your thread you may get it.

Otherwise Do this below mentioned,

[berryandcherry6]

Hi,

But when i limit it to show last 8 weeks as mentioned below, it has to show latest weeks. Here it showing someother weeks.

19 dec 2016 -25 dec 2016

26 de 2016 -01 jan 2017

02 jan 2017 -08 jan 2017

09 jan 2017 - 15 jan 2017

16 jan 2017 -22 jan 2017

23 jan 2017 -29 jan 2017

30 jan 2017 -05 feb 2017

06 feb 2017 -12 feb 2017.

[vinieme12]

Try

=WeekYear(CanonicalDate)

[vinieme12]

See attached app

[berryandcherry6]

Hi Vineeth,

i need to display last 8 weeks data in order in line graph, not in table(in attached sample it displays 2016 canonical date).

For this below date i need to display line graph

19 dec 2016 -25 dec 2016

26 de 2016 -01 jan 2017

02 jan 2017 -08 jan 2017

09 jan 2017 - 15 jan 2017

16 jan 2017 -22 jan 2017

23 jan 2017 -29 jan 2017

30 jan 2017 -05 feb 2017

06 feb 2017 -12 feb 2017.

[vinieme12 · Accepted solution]

See updated APP

created a variable

MaxWeekStart = WeekStart(Max(CanonicalDate)-56)

and used this variable in your expressions

[berryandcherry6]

Thanks Vineeth, This idea really worked.