Week in qlikivew

[#1]

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]

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]

use the WEEK function ..

like

Week day

Weekstart

weekend

weekname

weekyear

[preminqlik]

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;

[#5]

Please help it is really urgent

PFA the sample application.

Thanks in advance

Thiru