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]

change to custom sorting >>> sort by Expression = Week(Datefield)

[Chanty4u]

or else you can create an  inline load for weeks  and you can use in front end,

or

try to create a calculated dimension to get the output.

check below link for your u.standing

Sorting by week number | Qlik Community

[berryandcherry6]

Thanks for Reply!

In script i have maintained canonical date as below

LOAD

    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.

[berryandcherry6]

Hi Vineeth,

Thanks for reply!

what is Datefield?

[Chanty4u]

May be try this expression

='Week'&Ceil(Day(the_date)/7)

[Silambarasan1306]

Hi Supriya,

Could you please share your sample data or show how the week column is look like.

Thank you.

[berryandcherry6]

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.

[berryandcherry6]

Hi Silambar,

Please find below attached qvf file.

In that i need to display latest 8 weeks data, but in there its all jumbled.

[Silambarasan1306]

Hi,

Please find the application. This is what you expected right.