Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm a beginner to Qlikview.
I'm trying to write an expression to calculate the annual cost differential (numerical and percentage), for every department.
Please find attached an example.
Any suggestions greatly appreciated.
Regards,
Andrea
See attached qvw for two options.
A more dynamic version that uses expressions only (above() function) and matches your layout.
Best,
Peter
thank you so much for your help!
thank you so much for your help!
Mark as answered if it was right for you!
Hi! How can I create a dashboard chart to show the annual cost differential (percentage)?
Thanking you in advance for your help!
Well basically there are two methods here:
All example charts contain expressions for both amount & percentage presentations of the Annual Cost Difference. Just copy the ones you like.
Good luck,
Peter
Hi! Thank you for your help!
I try to use expressions only(above() funtion) to calculate the difference of costs from 11/2011 to 03/2012 and from 11/2012 to 03/2013, but it doesnt work. Can you can a take a look to the example attached, please?
I really appreciate any help you can provide!