Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Save data from QV report

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 

0 Replies