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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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

Labels (1)
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