Qlik Community

Ask a Question

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 
Search instead 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
jagan
MVP
MVP

Hi John,

Try this expression

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

Regards,

jagan.

View solution in original post

12 Replies
miguelbraga
Specialist III
Specialist III

Hi John,

Could you please elaborate your problem? I'm not sure that I understood your needs.

Thanks,

Miguel

miguelbraga
Specialist III
Specialist III

I John,

See this thread:

current vs previous quarter sales

Hope it helps

bunnyv123
Creator II
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, Variance.png

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

Hi Bunny Thanks your Prompt response, Please find the explanation about the requirement on the above.

jagan
MVP
MVP

Hi John,

Try this expression

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

Regards,

jagan.

View solution in original post

miguelbraga
Specialist III
Specialist III

Please check the attached file:

miguelbraga
Specialist III
Specialist III

If you found usefull my binary qvw, please mark it as Usefull Have good job.

Not applicable
Author

Sorry Braga Miguel , I didn't find the option to give useful ,  I have already given to Jagan