Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Iamwilliamlo
Contributor
Contributor

Text in the beginning

All,

i am able to load  =round(WEEKNUMBER) & 'WK' and come out '1WK'. But may i know how to make 'WK' in the beginning like WK1?

1WK 2WK 3WK 4WK

become

WK1 WK2 WK3 WK4

in pivot table

Thks a lot 

 

 

 

 

2 Replies
Or
MVP
MVP

Sounds like ='WK' & round(WEEKNUMBER)

Iamwilliamlo
Contributor
Contributor
Author

Thank you Or. It works. I tried this before but the result was not same this time. thks anyway.