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.

shubham_kumar
Contributor III

How do arrange the data in a coloumn where dates are Grouped by week.

How do arrange the data in a coloumn where dates are Grouped by week.

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.

weekday.png

Best,

Shubham Kumar

join@apt

2 Replies
dennisnet
Valued Contributor III

Re: How do arrange the data in a coloumn where dates are Grouped by week.

Hi Shubham,

         Week([ISSUED DATE]) as Weeknr

Will get you the weeknumber of your [ISSUED DATE], is that helpfull?

Good Luck,

Dennis.

shubham_kumar
Contributor III

How do arrange the data in a coloumn where dates are Grouped by week.

Hi Dennis,

Thanks for your quick response. The solution provided by you will not help much since I need entire week date should come in the same column. I dont need the weeknumber. I need to find the details of the one week transaction detail is a single row.

Thanks

Shubham Kumar

Community Browser