# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for
Did you mean:
Not applicable

## Varience Expression

How could I create an expression for the variance that would solve this?  I need to show it in the bar chart with Year-Quarter as Dimension and it has data up to 2010 totally i need to show 24 bars in the variance chart ,This is the equation we currently use in excel: for variance calculation (Q3 2015-Q3 2014)/Q3 2014. can any one help me on this?

1 Solution

Accepted Solutions
MVP

Hi John,

Try this expression

=(Sum(Sales)/Alt(Above(Sum(Sales), 4), 0)) - 1

Regards,

jagan.

12 Replies
Specialist III

Hi John,

Thanks,

Miguel

Specialist III

I John,

current vs previous quarter sales

Hope it helps

Creator II

Hi,

Didn't got Your query right. Can You please explain clearly what you want to obtain.

Thanks,

Bunny

Not applicable
Author

Hi Miguel,

If you see image there in the dimension, I have taken the Fiscal quarter ,which displays all the quarters from starting year to latest year,  now I want a bar chart with variance calculation in it, the calculation formula is

variance= (current quarter sales/previous year same quarter value)  -1.

Hope you got it!.

Regards

John

Not applicable
Author

MVP

Hi John,

Try this expression

=(Sum(Sales)/Alt(Above(Sum(Sales), 4), 0)) - 1

Regards,

jagan.

Specialist III