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

[vishsaggi]

Yes and link that to your fact table.

[#3]

Can you attach sample app with date range implemented if possible please

[vishsaggi]

Yes PFA a sample Calendar i used some time ago.

Let me know if you get struck.

Thanks,
V.

[#5]

I have implemented Calendar in my script , now I need to know how do I implement Calendar Object with date range in my application

[vishsaggi · Accepted solution]

Create these below variables inside the script . Then find the attached file to implement calendar object. Use calendar object properties and apply button properties and change where necessary. Let me know if any doubts.

VarDates:

Load

      min([%Key Date]) as minDate,

      max([%Key Date]) as maxDate

FROM <Give your calendar table name here>;

// To update dates into Variables

LET vMinDate = Floor(YearStart(Peek('minDate', 0, 'VarDates')));

LET vMaxDate = Floor(YearEnd(Peek('maxDate', 0, 'VarDates')));

Drop Table VarDates;

[#7]

[%Key Date] is the fact table date not calendar table date right?

I have created two calendar objects with button and applied properties but when I am selecting from and to date it is selecting all values in listbox

[#8]

it is selecting end date correctly but from date selecting from 12/31/1899

[vishsaggi]

Yes it should be from the Fact table. And can you attach me a sample app where you facing the issue.

[#10]

sorry I rechecked it is not selecting end date correctly either

[vishsaggi]

Can you send me the sample app you trying on please??