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

Announcements
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different. Learn More!
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

...