topic Re: Two input parameter To Date and From Date in QlikView

Two input parameter To Date and From Date

Anonymous — Thu, 09 Aug 2012 13:29:37 GMT

Hi,

To filter the data between these two parameter like input criterea or can say two date selection period, in QlikView need help with a basic example.

Requirement: From Date : DD/MMM/YYYY

: To Date : DD/MMM/YYYY

Then the data should be within those period.

Best Regards,

Shubham

Re: Two input parameter To Date and From Date

Thu, 09 Aug 2012 14:54:22 GMT

see file attached.

Regards

Rahul

Re: Two input parameter To Date and From Date

Anonymous — Fri, 10 Aug 2012 06:58:19 GMT

Thanks Rahul,

I need one more help. I have too many fields in my database related to dates, and all are required for some particular calculation. Please tell me how to make link between those date fields to the master table.

best regards,

Skumar

Re: Two input parameter To Date and From Date

Fri, 10 Aug 2012 07:25:34 GMT

I have linked the master table and the inline table. Hope it helps!

Re: Two input parameter To Date and From Date

Anonymous — Fri, 10 Aug 2012 08:14:09 GMT

Hi,

I think you have copied the same qvw and there is no change. Please let me know if you have done any changes, and one more thing I want to link more than one date fields in the master calender.

Thanks,

Skumar

Re: Two input parameter To Date and From Date

Fri, 10 Aug 2012 09:09:39 GMT

I have refreshed the qvw and sent back. Thought it was connected before.

Rename the other fields as 'Date' which will help you to connect to the master calendar.

Re: Two input parameter To Date and From Date

Anonymous — Sat, 11 Aug 2012 06:50:37 GMT

I tried but it's not working...it doesn't change while changing the two date parameter created with the help of above example.

Re: Two input parameter To Date and From Date

Mon, 13 Aug 2012 08:29:18 GMT

Hi,

In each of the table create an additional date field and in the example i posted change the varMinDate and varMaxDate variables to following:

LET varMinDate = Num(rangemin(Peek('DateName1', 0,'TableName1'), Peek('DateName2', 0,'TabbleName2'), Peek('DateName3', 0,'TableName3')));

LET varMaxDate = Num(rangemax(Peek('DateName1', -1,'TableName1'), Peek('DateName2', -1,'TabbleName2'),Peek('DateName3', -1,'TableName3')));

Where DateNameX and TableNameX have to be replaced with field names from your data model.

By doing the above two steps you will:

1. Have a key field date, which you can use on the front end as a selection and would work with all your table

2. By mantaining the original date field you can use those indipendently as you use now

3. By changing the Max and Min variable you wil be able to auto genrate dates between the dates that exist in your table

Hope this help.

Regards

Rahul

Re: Two input parameter To Date and From Date

Anonymous — Mon, 13 Aug 2012 09:19:14 GMT

Hi Rahul,

Thanks for your reply. The date name and table name which you are referring should be original name as coming from database or what we have renamed in our qlikview script. and once that done do I need to use varMaxDate & varMinDate as from and to date calender object?

Need advise, since it's not changing as intended.

Best Regards,

Skumar

Re: Two input parameter To Date and From Date

Tue, 14 Aug 2012 10:33:35 GMT

Hope it helps!

Re: Two input parameter To Date and From Date

Anonymous — Thu, 30 Aug 2012 08:06:00 GMT

Hi Rahul, Please find the attached document and help me in implementing from and to date in fron end with master calender. Best Regards, Shubham

Re: Two input parameter To Date and From Date

Thu, 05 Sep 2013 06:34:11 GMT

HI Rahul,

Can u please tell me how did u create variables (ex.vToDate,vFromDate) in qlikview (Test4.qvw) as I am new to this.

Thank you

Re: Two input parameter To Date and From Date

techvarun — Thu, 05 Sep 2013 07:18:18 GMT

Easy Date Range Selection with Qlikview | Min-Maxing Check Dis

Regards