Three node Drill group

[#1]

Hi everyone,

I'm new to qlikview i need to create Drill group like

Year-->Month-->Date

I have data like

Date	Amount
1-Jan-13	200
2-Jan-13	250
3-Jan-13	310
4-Jan-13	150
5-Jan-13	155
.
.
1-Feb-13	600
2-Feb-13	532
3-Feb-13	326
4-Feb-13	256
5-Feb-13	225

Any Help

[vikasmahajan]

Hope this help you.

Vikas

[#3]

Hi Vikas,

Thank you for your reply

But i didn't help me, I already create a drill group like that but when i click on year it jump to direct date not on month

please find the attachment.

Thanks in advance

[vikasmahajan]

I have created small demo for you please find attached.

Thanks

vikas

[amars · Accepted solution]

Hi Adeel,

Can you check in your group, if you have kept your 2nd Dimension as the Date. If so it is jumping to Date.

One more possibility is if you have only one possible value for month to select then in that case it will jump directly to date and not month.

Thanks

[#6]

Jordan,

You are right. I realized this in the evening after so many attemp.

Thank you so much for your help.

Regards,

[#7]

Thank you vikas for your response but i identified this,

I have only one value of month in my data thats why it jump direct to date.

Regards,