i have a graph which shows data for last 8 weeks, with
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.
Solved! Go to Solution.
or else you can create an inline load for weeks and you can use in front end,
try to create a calculated dimension to get the output.
check below link for your u.standing
Thanks for Reply!
In script i have maintained canonical date as below
Date(CanonicalDate, 'MM-DD-YYYY') AS CanonicalDate,
Year(CanonicalDate) AS Year,
date(WeekStart(CanonicalDate), 'MM-DD-YYYY') &' - '& date(WeekEnd(CanonicalDate), 'MM-DD-YYYY') as Week_Group_Year,
Load Date(MinDate + IterNo() -1 ) AS CanonicalDate While (MinDate + IterNo() - 1) <= Num(MaxDate);
and using Week_Group_Year as dimension in front end.
What i need to add to make it to display in order.
No, its not working.
This is what i am doing in steps:
Step1: This shows all the datas
Step2: Now i limit it to show last 8 weeks, so limiting it to 8. Where chosen sorting to auto
Here as you can see its not even showing latest values.
I have attached qvf file of my sample please refer it.