Qlik Community

Ask a Question

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
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

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

Specialist
Specialist

use the WEEK function ..

like

Week day

Weekstart

weekend

weekname

weekyear

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