topic Re: Week in qlikivew in QlikView

Week in qlikivew

Wed, 21 May 2014 12:00:08 GMT

Hi,

I want to show the weeks details for a month like week1,week2,week3,week4.

For Eg: If i choose Jan Month drill down -> week1,week2,week3,week4.(4 weeks)

Thanks,

Thiru

Hi all

Here by enlcosing the sample application.Can u please help on this..

How to do the drill down i tried but it doesnt work for me

Thanks,

Thiru

alexandros17 — Wed, 21 May 2014 12:01:25 GMT

You need week field in your script that is:

if you have for example invoice_date then

Month(invoice_date ) gives you the month

Week(invoice_date ) gives you the week

then use the week as dimension

Anonymous — Wed, 21 May 2014 12:06:01 GMT

use the WEEK function ..

Week day

Weekstart

weekend

weekname

weekyear

preminqlik — Wed, 21 May 2014 12:09:32 GMT

calendar:

Load *,

if(match(Day,1,2,3,4,5,6,7),dual(1,'Week1'),

if(match(Day,8,9,10,11,12,13,14),dual(2,'Week2'),

if(match(Day,15,16,17,18,19,20,21),dual(3,'Week3'),dual(4,'Week4')))) as WeekNew

resident path;

Thu, 22 May 2014 03:20:31 GMT

Please help it is really urgent

PFA the sample application.

Thanks in advance

Thiru