Week('4/1/2016')

[Anonymous]

Hi All,

In Qlikview Week('4/1/2016') = 13

Where in Excel Weeknum("4/1/2016") = 14

How do i achieve excel format in Qlikview ..?

[Chanty4u · Accepted solution]

chk dis

Redefining the Week Numbers

[Anonymous]

Thanks This works

[awhitfield]

Hi Karthik,

if you are happy with chanty4u's  reply, then please mark it as CORRECT.

This helps other community users!

Andy

[t_chetirbok]

Qlik Community Tip: Marking Replies as Correct or Helpful