Weekname is not giving correct result

[that_anonymous_guy]

I have converted my date using weekname in the script and it is week/year format when I am previewing it in the model but when I'm using the same in qlik sense chart it is coming again as a date format. 

Could anyone help me rectify what the issue is?

[sidhiq91]

@that_anonymous_guy  Could you please try the below code?

NoConcatenate
Temp:
Load Date(Date#(Date, 'MM/DD/YYYY'),'MM/DD/YYYY') as Date,
Sales
inline [
Date, Sales
1/17/2023, 10
1/10/2023, 50
1/03/2023, 100
];

NoConcatenate
Temp1:
Load WeekName(Date) as Week,
Sales

Resident Temp;

Drop table Temp;

Exit Script;

If this resolves your issue, please like and accept it as a solution.

[Mark_Little]

Hi,

If the suggestion doesn't help can you share some more information. 

Share the script around the date and weekname formatting

What chart are you using, what properties are set

[that_anonymous_guy · Accepted solution]

Thank you everyone for your efforts. Nothing worked so changed the dimension as year(date)&'-'&week(date) to get it done.