Input Parameter and drill down

[#1]

Hi,

I need to design Qlikview report same as existing Business object report ,  BO report  has below feature implemented, please suggest how to implement same in Qlikview

1. User input parameter for date- it asks user to select date while running report

2. Drill down from one level to another level

[#2]

attached is the sample

[#3]

[Count date] is linked with [Count Date] in master calendar, is that okay ?

[vishsaggi]

I got to look into few things and discuss, do you have a gmail account for a chat if that is ok?

[#5]

gmail is not accessible , please post here

[vishsaggi]

Ok. Can you create this in your fact table: Like

CASE:

LOAD

    *,

    FLOOR(Num([Count Date])) As [%Key Date],

FROM F4141;

Then use the Calendar script in the attachment.

Then in the Calendar objects add the variables in both near variable like below:

[#7]

I have applied Date(vMinDate),'MM/DD/YYY') in button actions and it is working fine now

[vishsaggi]

Oh cool. Glad it worked for you.