Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

siva_boggarapu
Contributor II

How to do Group function in Desinger part?

Hello there,

I have a filed called ISSUED DATE. Here, i want to make the date into group week wise only. How it is possible?

Thanks in advance

best,

siva

2 Replies

How to do Group function in Desinger part?

Hi,

I suggest create Weekdays of the field and use it to group like

Weekday([ISSUED DATE]) as Weekdays

Rgds

Anand

shubham_kumar
Contributor III

How to do Group function in Desinger part?

Hi Anand,

Weekday([ISSUED DATE]) as Weekdays) will return only the weekday, suppose if that day is sunday or monday. but the question is we need to make all the week days in one column, and the data for the week should be showing respectly in different columns.

e.g. 17/10/2011-23/10/2011 (which is one week) that should come in the same row.

Best,

Shubham Kumar