I have a table that consist of the following Fields (amongst others):
Date, year, month, yearmonth, day, week, description, balance, and some other Fields.
I would like to use yearmonth and the dimention, and the Balance as the Expression to display the chart With an overview of the Balance throughout the year.
But if I just use Balance in the expression, it chart is empty. If I use sum(Balance) the chart is populated, but of cource With the wrong values. (as it is already calculated prior to import). How should I use this to display the chart correctly? Anyone that can help??
Re: Dates and balance in line chart witout function?
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 15500500
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: