Convert the numeric format to yyyy-ww

[aminqlik]

Hi All:

     I have the initial numeric format as below.

    Then, I used the Weekname function to get the table as below:

when I put the year week as dimension, the time sequence is wrong.

Can anyone help me to fix it?

Regards,

aminqlik

[lironbaram]

hi 

when you look at the chart properties what is the first element is the sorting tab?

[Kushal_Chawda · Accepted solution]

You need to have a numeric value associated with year week. Use dual function to assign numeric value to year week.

Assuming that you have calculated  year week as year(Date)&'\'&week(Date)  where Date is your numeric value field. You can now create year week as below

=dual ( year(Date)&'\'&week(Date) , weekstart(floor(Date))

Now you can sort the your week dimension from chart properties

[aminqlik]

Hi Kush:

     Thank you very much for the solution. It runs well.

Regards