Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

week format

Hi all,

I want to get the  week format  like below how can I get this?

wk.PNG

Can anyone help me to get like above?

Thanks

Sony

1 Solution

Accepted Solutions
sergio0592
Specialist III
Specialist III

Hi,

Try with ='WE '&weekstart(You_date_field, 0, 5)


5 in second argument because it seems that your first day of week is saturday.

View solution in original post

3 Replies
prat1507
Specialist
Specialist

Do you already have the date fields, you can concatenate 'Week' & DateField to get the desired result.


Regards

Pratyush

sergio0592
Specialist III
Specialist III

Hi,

Try with ='WE '&weekstart(You_date_field, 0, 5)


5 in second argument because it seems that your first day of week is saturday.

soniasweety
Master
Master
Author

thanks its worked as required