Discussion Board for collaboration on QlikView Scripting.
I have the following table (simplified):
Using this expression in a text box, allows me to sum the amounts for any given date (vDate) over the entire range of records in my table (imagine many thousands of ID’s).
=Money(sum( if( Start_date<= vDate AND End_date>= vDate, [Amount_in_€]) ))
(which means that only a portion of the table is totalized, i.e. the records that meet the expression)
Now, what I’d like to do, is show the progression of the total from the expression over a range of dates (oldest Start_date up to today) in a line graph.
Thinking about this, I guess I will have to generate a new table, that would look something like this:
Could anyone help me make the script that builds this new table from the original one?
Many thanks in advance!