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

[Nora104]

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

But in Qlikview, it's right:

[Ksrinivasan]

hi,

try this:

=Week('01/01/2021')

ksrinivasan

[Nora104]

Thank you. But it doesn't work.

[Ksrinivasan]

hi,

its purely based on your date format.

but  you can try

=week(makedate(202101,24))

or

Week('MM/DD/YYYY')

ksrinivasan.