Getting Year and Week from YearWeek

[GnomeGuy]

Hello all,

Was referring to the function <WeekName> on qlik help, it says that i will get

2013/02 with the expression Weekname('12/01/2013')

However, i am unable to get that when i tried the expression in a KPI Chart, getting a number 41.28k instead.

I would like some method to give me the year with the week with a single function without concatenating thanks. 

Appreciate help on this matter. Thank you.

[Lisa_P]

Qlik Sense will internally save dates as integers, so if you want to change the display, you can use the Date function to format.

eg Date(Weekname('12/01/2013'), 'YYYY/MM')

[GnomeGuy]

Yea, i guess so too.

But how can i get a Year/Week Number with a single function?

[Kashyap_R · Accepted solution]

Hi

You can try this 

=Year('12/01/2013')&'/'&Week('12/01/2013')

Thanks

[GnomeGuy]

Was looking for a single function but it seems that it is not possible. Will stick to using functions Year and Week then. 

Thank you all for the inputs