Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
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