Why Week('2021-01-24')=5 in QlikSense? - Qlik Community

Nora104 · ‎2021-01-24

In QlikSense, Week('2021-01-24')=5, as the below:

But in Qlikview, it's right:

Ksrinivasan · ‎2021-01-24

hi,

try this:

=Week('01/01/2021')

ksrinivasan

Nora104 · ‎2021-01-25

Thank you. But it doesn't work.

Ksrinivasan · ‎2021-01-25

hi,

its purely based on your date format.

but you can try

=week(makedate(202101,24))

or

Week('MM/DD/YYYY')

ksrinivasan.