Discussion Board for collaboration related to QlikView App Development.
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)
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
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
use the WEEK function ..
if(match(Day,15,16,17,18,19,20,21),dual(3,'Week3'),dual(4,'Week4')))) as WeekNew
Please help it is really urgent
PFA the sample application.
Thanks in advance