Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
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.

13 Replies
marcelviegas
Creator II
Creator II

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

Anil_Babu_Samineni

This may helps you

Selecting Arbitrary Date Ranges - YouTube

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Not applicable
Author

Thank you.

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

Anil_Babu_Samineni

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful