topic group date in QlikView

group date

Mon, 12 Jul 2010 18:56:54 GMT

Hi ,

I have a date & Qty data as show in image. I want a chart which shows total of qty for every 7 days (not weekly).

Ex: -

Jan 1 to Jan 7th

Jan 8 to Jan 14........

Thanks in Advance

group date

Mon, 12 Jul 2010 20:44:04 GMT

Something like this:


Left join <your table name>
Load *, floor(day(Date) / 7) as ChunkOfSevens
resident <your table name>;

After that you can use ChunkOfSevens as Dimension in your chart.

group date

Mon, 12 Jul 2010 21:08:40 GMT

Thanks for your reply... Can we do it in the charts directly by any expressions , instead of doing at load script?

group date

johnw — Mon, 12 Jul 2010 23:57:28 GMT

Sure, just use floor(day(Date)/7) as a calculated dimension. It'll perform better if you make it a real dimension in the script like Nick suggested, though.

group date

Wed, 14 Jul 2010 15:56:56 GMT

I tried that expression but getting nulls..? can you please upload a sample.

group date

Wed, 14 Jul 2010 17:46:16 GMT

It shouldn't if you have "Date" field. Do you have Date field?

It will be great if you send us your example.