Discussion board where members can get started with Qlik Sense.
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?
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
View solution in original post
when you look at the chart properties what is the first element is the sorting tab?
Thank you very much for the solution. It runs well.