topic Time series graph from start date to date provided Qlikview in QlikView

Time series graph from start date to date provided Qlikview

Tue, 22 Aug 2017 13:18:14 GMT

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.

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

Anil_Babu_Samineni — Tue, 22 Aug 2017 13:21:08 GMT

Just do like below

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

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

marcelviegas — Tue, 22 Aug 2017 13:23:17 GMT

hi,

Enter in the calculation:

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

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

Tue, 22 Aug 2017 13:34:19 GMT

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

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

Anil_Babu_Samineni — Tue, 22 Aug 2017 13:35:56 GMT

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

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

marcelviegas — Tue, 22 Aug 2017 13:37:55 GMT

Attach your qvw

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

Tue, 22 Aug 2017 13:58:18 GMT

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.

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

Anil_Babu_Samineni — Tue, 22 Aug 2017 14:01:35 GMT

Use this in your expression

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

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

marcelviegas — Tue, 22 Aug 2017 14:06:15 GMT

segue anexo

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

Tue, 22 Aug 2017 14:10:45 GMT

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

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

marcelviegas — Tue, 22 Aug 2017 14:12:00 GMT

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

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

Anil_Babu_Samineni — Tue, 22 Aug 2017 14:12:49 GMT

This may helps you

Selecting Arbitrary Date Ranges - YouTube

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

Tue, 22 Aug 2017 14:16:07 GMT

Thank you.

Can you also provide me with any starter material for set analysis, as I am relatively new to Qlikview.

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

Anil_Babu_Samineni — Tue, 22 Aug 2017 14:18:14 GMT

Start search in bing or google to relative SEO will come up to the vision