Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi
You can try this
=Year('12/01/2013')&'/'&Week('12/01/2013')
Thanks
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')
Yea, i guess so too.
But how can i get a Year/Week Number with a single function?
Hi
You can try this
=Year('12/01/2013')&'/'&Week('12/01/2013')
Thanks
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