Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Week in qlikivew

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

4 Replies
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

venkatasreekant
Specialist
Specialist

use the WEEK function ..

like

Week day

Weekstart

weekend

weekname

weekyear

preminqlik
Specialist II
Specialist II

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;

Not applicable

Please help it is really urgent

PFA the sample application.

Thanks in advance

Thiru