topic Re: Input Parameter and drill down in QlikView

Input Parameter and drill down

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Input Parameter and drill down

adamdavi3s — Wed, 17 Aug 2016 09:13:15 GMT

1- Use a date list box to limit data or if more appropriate then use a date variable and calendar object, then use this variable in your expressions

2- Use a drill down group, or use variables to hide / show, or use a selection trigger to change tabs

There are many different ways to do these sorts of thing and searching on here should help you come up with a way of doing it.

Please remeber to mark this answer as helpful or correct if it helps or answers your question

Re: Input Parameter and drill down

Gysbert_Wassenaar — Wed, 17 Aug 2016 09:13:43 GMT

1. Use a listbox object to select the date

2. Create a drill down group with the fields you want to use a drill down hierarchy and use that drill down group as dimension in your chart or table.

Re: Input Parameter and drill down

stabben23 — Wed, 17 Aug 2016 09:19:53 GMT

Hi,

I have rebuild a couple of BO reports to Qlikview reports. Qlikview is so much more than a static BO report.

1.In qlikview you have all dates and you can build a calendar where the user picks whatever date he want.

2. for drill down a simple Pivot table is good enough

just convince the customer that qlikview can do so much more than a BO report.

Re: Input Parameter and drill down

Thu, 18 Aug 2016 20:14:12 GMT

Hi,

Do I need to create Calendar Table in data model in order to implement Calendar Object ?

Re: Input Parameter and drill down

Thu, 18 Aug 2016 20:20:03 GMT

Hi,

Do I need to create Calendar Table in data model in order to implement Calendar Object ?

Re: Input Parameter and drill down

vishsaggi — Thu, 18 Aug 2016 20:36:52 GMT

How are your dates coming in your data model. If there are any missing gaps in the dates and if you want to use the Calendar object (where i technically use calendar object only when I want to see data with in a range of dates) you should have valid dates to be displayed in the calendar object for selections. Else the experts mentioned above should suffice your requirement.

Re: Input Parameter and drill down

Thu, 18 Aug 2016 20:59:47 GMT

Report is having Date range (From and To Date)

Re: Input Parameter and drill down

vishsaggi — Thu, 18 Aug 2016 21:07:20 GMT

So its always good to have a Calendar table in the Data model. Implement and try the solutions mentioned above and let us know if you still have any issues!!!

Re: Input Parameter and drill down

Mon, 22 Aug 2016 18:31:04 GMT

Do I need to implement calendar table in script, the date for which I want to create calendar object has gaps

Re: Input Parameter and drill down

vishsaggi — Mon, 22 Aug 2016 18:33:37 GMT

Yes and link that to your fact table.

Re: Input Parameter and drill down

Mon, 22 Aug 2016 18:43:18 GMT

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

Re: Input Parameter and drill down

vishsaggi — Mon, 22 Aug 2016 19:14:23 GMT

Yes PFA a sample Calendar i used some time ago.

Let me know if you get struck.

Thanks,
V.

Re: Input Parameter and drill down

Mon, 22 Aug 2016 19:18:23 GMT

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

Re: Input Parameter and drill down

vishsaggi — Mon, 22 Aug 2016 19:26:37 GMT

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;

Re: Input Parameter and drill down

Mon, 22 Aug 2016 20:46:20 GMT

[%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

Re: Input Parameter and drill down

Mon, 22 Aug 2016 20:53:11 GMT

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

Re: Input Parameter and drill down

vishsaggi — Mon, 22 Aug 2016 21:00:53 GMT

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

Re: Input Parameter and drill down

Mon, 22 Aug 2016 21:03:45 GMT

sorry I rechecked it is not selecting end date correctly either

Re: Input Parameter and drill down

vishsaggi — Mon, 22 Aug 2016 21:10:42 GMT

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