Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
manoranjan_d
Specialist
Specialist

Week

I want to display the week number as w1,w2, w3...

how to do this in script level?

5 Replies
prieper
Master II
Master II

= 'w' & WEEKNUM(MyDate)

Peter

manoranjan_d
Specialist
Specialist
Author

there is  WEEKNUM  function in the qlikview

Kushal_Chawda

='W' & week(Date)

manoranjan_d
Specialist
Specialist
Author

i can achive this only in front end level but not in th e script level

Kushal_Chawda

you can create the field in script like below

LOAD

'W' & week(Date) as WeekNumber

...