Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculating business growth


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


146 = 300,000

147 = 250,000

Business Growth = -16.76%)

2 Replies
Not applicable

Does anyone know of an expression I can use?

Not applicable


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