Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

vinieme12
Esteemed Contributor II

Re: Sorting issue in line graph in Qliksense

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

berryandcherry6
Contributor II

Re: Sorting issue in line graph in Qliksense

Thanks for reply!

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

berryandcherry6
Contributor II

Re: Sorting issue in line graph in Qliksense

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

silambarasan130
Contributor II

Re: Sorting issue in line graph in Qliksense

Go to your thread you may get it.

Otherwise Do this below mentioned,

Sorting.JPG

berryandcherry6
Contributor II

Re: Sorting issue in line graph in Qliksense

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.

Highlighted
vinieme12
Esteemed Contributor II

Re: Sorting issue in line graph in Qliksense

Try

=WeekYear(CanonicalDate)

vinieme12
Esteemed Contributor II

Re: Sorting issue in line graph in Qliksense

See attached app

berryandcherry6
Contributor II

Re: Sorting issue in line graph in Qliksense

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
Esteemed Contributor II

Re: Sorting issue in line graph in Qliksense

See updated APP

created a variable

MaxWeekStart = WeekStart(Max(CanonicalDate)-56)

and used this variable in your expressions

berryandcherry6
Contributor II

Re: Sorting issue in line graph in Qliksense

Thanks Vineeth, This idea really worked.