Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculating business growth

Hi,

Not sure if anyone will be able to answer this but I will try to explain the best I can.  I need to calculate business growth and ideally show this on a bar chart, I want to be able to say:

if financial year = 147 sum sales MINUS if financial year = 146 sum sales.  Then DIVIDE financial year = 146 sum sales

(Example:

146 = 300,000

147 = 250,000

Business Growth = -16.76%)

2 Replies
Not applicable
Author

Does anyone know of an expression I can use?

Not applicable
Author

Try

(sum({1<'Financial Year' = {147}>}sales) - sum{1<'Financial Year' = {146}>}sales))/(sum{1<'Financial Year' = {146}>}sales))