topic Re: How to create Date Range selection and connect it to data in QlikView

How to create Date Range selection and connect it to data

Wed, 21 Aug 2013 07:42:47 GMT

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

Re: How to create Date Range selection and connect it to data

vikasmahajan — Wed, 21 Aug 2013 09:00:15 GMT

Hii

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

Vikas

Re: How to create Date Range selection and connect it to data

stigchel — Wed, 21 Aug 2013 10:08:07 GMT

Check the code of Calendar in qlikview components made by RobWunderlich

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

Re: How to create Date Range selection and connect it to data

Wed, 21 Aug 2013 10:33:41 GMT

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

Re: How to create Date Range selection and connect it to data

richard_pearce6 — Wed, 21 Aug 2013 11:08:04 GMT

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

Re: How to create Date Range selection and connect it to data

stigchel — Wed, 21 Aug 2013 11:19:43 GMT

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

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

Re: How to create Date Range selection and connect it to data

Sun, 25 Aug 2013 07:53:29 GMT

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

Re: How to create Date Range selection and connect it to data

Sun, 25 Aug 2013 07:55:06 GMT

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

thanks

Re: How to create Date Range selection and connect it to data

Gysbert_Wassenaar — Sun, 25 Aug 2013 09:41:39 GMT

See this tutorial video: Selecting Arbitrary Date Ranges

Re: How to create Date Range selection and connect it to data

Sun, 25 Aug 2013 11:04:34 GMT

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.

Re: How to create Date Range selection and connect it to data

Tue, 18 Feb 2014 15:19:58 GMT

Hey,this expression can be set in charts objects but if i want to filter records in table box object.Please tell me,how we can do that?

Re: How to create Date Range selection and connect it to data

Anonymous — Fri, 22 Dec 2017 07:19:33 GMT

i want to compare current sales with previous sales on basis of selection of date range from calendar

so following is the expression :-

Curr_Year=max(sold_year)

Prev_Year=max(sold_year)-1

bprev_Year=max(sold_year)-2

for current year expression

=sum({< Sold_Date = {'>=$(=Date(vstart),Curr_Year)<=$(Date(vend),Curr_Year)'} >}[inv value]/Sales_INR_Unit)

is this correct?