Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist III
Specialist III

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
Highlighted
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
Highlighted
Specialist
Specialist

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


Regards

Pratyush

Highlighted
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

Highlighted
Specialist III
Specialist III

thanks its worked as required