Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
replace Datefield with the field using which you are creating the weeks!
Thanks for reply!
No vineeth, its not working. Can you download attached qvf file.
I am not able to view your sent file.Its not atall opening
Go to your thread you may get it.
Otherwise Do this below mentioned,
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.
Try
=WeekYear(CanonicalDate)
See attached app
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.
See updated APP
created a variable
MaxWeekStart = WeekStart(Max(CanonicalDate)-56)
and used this variable in your expressions
Thanks Vineeth, This idea really worked.