Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

shubham_kumar
Contributor III

Two input parameter To Date and From Date

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

12 Replies
Not applicable

Re: Two input parameter To Date and From Date

see file attached.

Regards

Rahul

shubham_kumar
Contributor III

Re: Two input parameter To Date and From Date

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

Not applicable

Re: Two input parameter To Date and From Date

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

shubham_kumar
Contributor III

Re: Two input parameter To Date and From Date

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

Not applicable

Re: Two input parameter To Date and From Date

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.

shubham_kumar
Contributor III

Re: Two input parameter To Date and From Date

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

Not applicable

Re: Two input parameter To Date and From Date

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

shubham_kumar
Contributor III

Re: Two input parameter To Date and From Date

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

Not applicable

Re: Two input parameter To Date and From Date

Hope it helps!

Community Browser