Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Line Chart- How to see historical data if we select any month from filter pane?

Hi,

I have line chart which has "Month" in X-Axis and measure in Y-Axis. If I select any month from filter pane I should see historical data till that selected month. For example if I select "DEC-16" I should see data which is available before Dec-16 including December data in the line chart.

2 Replies
aarkay29
Specialist
Specialist

May be this

Give the expression as Sum({<Month={'<=$(=Max(Month))'}>}Field)

ahaahaaha
Master
Master

Hi Pradeep,

It can be so


Sum({<Month={"<=$(=Month(GetFieldSelections(Date)))"}>}Field)


I do not know how the date fields are organized.


Regards,

Andrey