I have a personal edition, and I get a Notification "Your installation of Qlikview has exceeded the Maximum number of documents recoveries allowed for a personal edition licence" when I try to open any of the demos available in this forum, so I can not open the databases and see the solution, unfortunately.
My data is like this:
Date YearMonth Balance value
15/04/2014 2014-04 15032 3443,50
17/04/2014 2014-04 16000 968
19/04/2014 2014-04 15500 500
If the last row from april 2014 was 19/04/2014, I would like to see a line chart that gave the values like below:
Where the sums above was on the y axis, and the yearmonth was on the x axis.
The yearmonth is calculated on import.
Attached is some sample data from the Application:
This is the solution I am looking for:
The yellow row is selected because that is the last day there is a balance recorded for that month (march 2014), and then the value of the Balance 16378 is used in the chart for 2014-mar.
The green row is selected because that is the last day there is a Balance recorded (april 2014), and then the value of the Balance 18993 is used in the chart for 2014-apr.
So the chart I am looking for is like the chart on the right side. Of course With more yearmonth values. (like all for this current year).
Does anyone know how to do this in qlikview?
My data set is looking exactly like the data displayed on the left side of the Picture.