How to create Date Range selection and connect it to data

[#1]

Hello there, I am new to QlikView and this Forum, I would very much like your help on the following matter:

I am developing a report (tap) in a QlikView file that already contains other reports (taps)

in this report I am extracting a table lets call it table X and in this table I have data fields and 2 of those fields are Valid_From and  Valid_To  ,   now those 2 date fields are requested to be in 2 calendar object where Valid_From is to be Start Date and Valid_To is to be End Date.

This might have nothing to do with anything but a master calendar already exists for the other reports (taps) which I am not planing to use.

1- Could you please help me create a Start Date and an End Date calendar object that can control the content of the extracted data from table X?

2- What is the best object to use to show these data sets? the customer requests it to be in a table format.

Thank you

[vikasmahajan]

Hii

Find attachment of calender object  -> define start and end date in variables and use this to display in charts.

Vikas

[stigchel]

Check the code of Calendar in qlikview components made by RobWunderlich

qlikview-components - A script library for Qlikview development - Google Project Hosting

[#4]

Hello Vikas,

i know how to create the object, I have declared Variables as well, but I cannot get the end and start dates to take effect in the other data coming from the same table

[richard_pearce6]

Hi,

Have you created a data island for this new section of the dashboard? In other words is the data you're using separate (no links) to the other data and subsequent calendar table that already exists?

Richard

[stigchel]

You can use the variables in an expression with set analysis:

Sum({<Date = {'>=$(=Date(vStartDate))<=$(=Date(vEndDate))'} >}  Sales)

[#7]

Hello Richard,

No this table is connected to the other data available in the Data Model, however it comes with its own set of dates that are much wider in range then the existing data.

Moaath

[#8]

I'll give that a try and get back to you.

thanks

[Gysbert_Wassenaar]

See this tutorial video: Selecting Arbitrary Date Ranges

[#10]

This is a very great video but the problem is he uses OrderDate as the one field for dates to build his logic around, the OrderDate field is the one field that is providing all the dates for his report. My problem is that I have 2 fields that feed me dates ValidFrom and ValidTo. They both contain their own sets of dates that have nothing to do with the master calendar and are only connected to the data in this report (or in other words, these fields are only connected to the data in the same table they come with) and i need to use these two fields to create a date selecting range.