qlik sense

[Chinnu3]

I want to convert a Date(27-10-2021) in Week(YYYY-W43) like this.

how to convert this in Dimension, I want to show this in Bar chart.

Thanks..

[AshutoshBhumkar]

Hello,

Something like this ?

Year(Date(Date#('27-10-2021','DD-MM-YYYY')))&'-W'&Week(Date(Date#('27-10-2021','DD-MM-YYYY')))

Thanks,

Ashutosh

[tresesco · Accepted solution]

Or, like this:

=Replace(
WeekName(Date#('27-10-2021', 'DD-MM-YYYY'))
,'/','-W')

[Chinnu3]

I want to convert a Date(27-10-2021) in to Month(YYYY-MMM) like this and I want last 12months from Date(27-10-2021).

how to convert this in Dimension, I want to show this in Bar chart.