Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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