topic Re: Date Range in Line Chart in QlikView

Date Range in Line Chart

Anonymous — Tue, 05 May 2015 20:06:20 GMT

I have a problem. I have a field loaded from an excel file with a list of dates in the following format ----> 12/1/2013

I am using this date field in a Line chart as a calculated dimension and Sales as expression.

Out of all the dates in the field, I only want a selected range of dates to display Sales for that range of dates on the line chart.

The field has dates for the year 2013 and 2014, but I just need the date range of 11/1/2013 - 3/1/2014. Thanx.

Re: Date Range in Line Chart

sunny_talwar — Tue, 05 May 2015 20:24:43 GMT

Use this in as a set analysis statement in your expression

{<Date = {">=11/1/2013<=3/1/2014"}>}

If the above two dates are dynamic, then probably you need to use two variables which the user can have the ability to select and then you will need something like this:

{<Date = {"$(='<=' & $(vStartDate) & '>=' & $(vEndDate))"}>}

I hope this guides you in the right direction.

Best,

Sunny

Re: Date Range in Line Chart

maxgro — Tue, 05 May 2015 21:34:06 GMT

calculated dimension

=if(Date<='02/02/2014' and Date>='01/01/2014', Date)

suppress when value is null

Re: Date Range in Line Chart

Tue, 05 May 2015 21:53:24 GMT

Try this one

{<Date = {"$(='<=' & $(vStartDate) & '>=' & $(vEndDate))"}>}