Save data from QV report

Wed, 02 Nov 2011 08:19:24 GMT

Hi All

I need some help to store some figures from a report that I have. I need to store the figures in the speedometer marked with a purple circle (see attached file) = 76,9% and 90,1%. The figures are calculated as

=num(sum(aggr(count(Location.HEIGHT)*0.95/count(TransportUnitID)*sum(StockItems.AMOUNT*SKU.ITEMVOLUME/1000000000),Location.HEIGHT))/sum(aggr(1200*800*((If(Location.HEIGHT=1200, 1008,if(Location.HEIGHT=1700,1450,if(Location.HEIGHT=2200,1950,2300))))-144)/1000000000*count(Location.HEIGHT)*0.95,Location.HEIGHT)),'##,#%')

and

=num(sum(aggr(count(TransportUnitID),Location.HEIGHT))/sum(aggr(Count (Location.Location_Name),Location.HEIGHT)),'##,#%')

I need to store them with the date (today) so I in the furture can make a graph of the deveolpment in these figures like this..

Date Figure 1 Figure 2

02-11-2011 76,9% 90,1%

03-11-2011 77,2% 92,3%

04-11-2011 75,4% 91,7%

etc.

But how do I do that? think I should use something with a qvd file maybe?

Best regards

Bjarne

topic Save data from QV report in QlikView

Save data from QV report