Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Time series graph from start date to date provided Qlikview

Hi All,

I have created a line chart which has dates on X-axis and amounts on Y-axis and also displayed dates as a table to choose a particular date. The dates are ranging from 01-01-2010 to 01-01-2017 and the line chart is displayed perfectly.

Now my requirement is to get the line chart till a particular date selected i.e. if I select the date as 12-12-2015 then the line chart should be displayed from 01-01-2010 to 12-12-2015. Can you please help me with this.

Thanks in advance.

1 Solution

Accepted Solutions
Highlighted

Re: Time series graph from start date to date provided Qlikview

Use this in your expression

Sum({<dim_date = {"<=$(=Max(dim_date))"}>}Revenue)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

13 Replies
Highlighted

Re: Time series graph from start date to date provided Qlikview

Just do like below

Sum({<DateField = {'<= $(=Max(DateField))'}>}Sales)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Creator II
Creator II

Re: Time series graph from start date to date provided Qlikview

hi,

Enter in the calculation:


sum({<data={"<= $ (= (Max (data))) "}>}field_calculation)

Highlighted
Not applicable

Re: Time series graph from start date to date provided Qlikview

Which Tab should i Enter it in? Can you please give me a screenshot?

Highlighted

Re: Time series graph from start date to date provided Qlikview

Tab for what? I am initiating to use in Line chart of your measures?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Creator II
Creator II

Re: Time series graph from start date to date provided Qlikview

Attach your qvw

Highlighted
Not applicable

Re: Time series graph from start date to date provided Qlikview

Hi,

I am new to Qlikview and still exploring and learning.

Here is a attached sample file. In this file if I choose the date as 1/10/2015, then the line chart should be displayed from 1/1/2015 to 1/10/2015 . Appreciate your help.

Highlighted

Re: Time series graph from start date to date provided Qlikview

Use this in your expression

Sum({<dim_date = {"<=$(=Max(dim_date))"}>}Revenue)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

Highlighted
Creator II
Creator II

Re: Time series graph from start date to date provided Qlikview

segue anexo

Highlighted
Not applicable

Re: Time series graph from start date to date provided Qlikview

Thanks a lot Anil and Marcel.

Can you please also let me know if I need to choose a date range say if I choose start date as 1/3/2015 and end date as 1/10/2015 and If I need chart only for these selected date ranges ? Kindly help

Thanks