Re: How do arrange the data in a coloumn where dat... - Qlik Community

Anonymous · ‎2011-10-19

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.

Best,

Shubham Kumar

join@ap t

Anonymous · ‎2011-10-19

Hi Shubham,

Week([ISSUED DATE]) as Weeknr

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

Good Luck,

Dennis.

Anonymous · ‎2011-10-19

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