Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In QlikSense, Week('2021-01-24')=5, as the below:
But in Qlikview, it's right:
hi,
try this:
=Week('01/01/2021')
ksrinivasan
Thank you. But it doesn't work.
hi,
its purely based on your date format.
but you can try
=week(makedate(202101,24))
or
Week('MM/DD/YYYY')
ksrinivasan.