Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
daisy1438
Contributor III
Contributor III

help on expression for actual totals displayed cumulatively?

Hi All,

 

I have created one bar chart dimension is month and i am using below expression for actual.

Num(Sum({<[Budget Type Code]={'Actual'}>}Expense))  it showing the month wise actual values .

now i need cumulative actual values based on month.

 

example:my data like

month,actual

feb,10

apr,20

aug,30.

required out put:

feb=10

apr=feb+apr=30

aug=feb+apr+aug=60.

i am using range function but it not working properly.

please help on this.

1 Solution

Accepted Solutions
Channa
Specialist III
Specialist III

RangeSum(Above(Sum({<[Budget Type Code]={'Actual'}>}Expense), 0, RowNo()))

 

 

RangeSum(Above(Sum(Sales), 0, RowNo()))

Channa

View solution in original post

6 Replies
Channa
Specialist III
Specialist III

RangeSum(Above(Sum({<[Budget Type Code]={'Actual'}>}Expense), 0, RowNo()))

 

 

RangeSum(Above(Sum(Sales), 0, RowNo()))

Channa
daisy1438
Contributor III
Contributor III
Author

Hi chenna tahnks for your help.

i have one small issue on this.

i am using combo chart calculate the actual and budget based on month wise.

two bars not cumulative  (actual,budget)and two line is the cumulative (actual,budget).now iam getting correct result.

now i need colores for that.

1)actual bar and line need showing the one color and 2)budget bar and line showing another color.

means both actual bar and line one color and both budget bar and line show another color.

how to do this.in combo chart.i have attached the my original chart for reference.

daisy1438
Contributor III
Contributor III
Author

Hi chenna tahnks for your help.

i have one small issue on this.

i am using combo chart calculate the actual and budget based on month wise.

two bars not cumulative  (actual,budget)and two line is the cumulative (actual,budget).now iam getting correct result.

now i need colores for that.

1)actual bar and line need showing the one color and 2)budget bar and line showing another color.

means both actual bar and line one color and both budget bar and line show another color.

how to do this.in combo chart.i have attached the my original chart for reference.

Channa
Specialist III
Specialist III

You need to build master measures. There you can choose color

Channa
daisy1438
Contributor III
Contributor III
Author

Hi thanks for your help its working fine.

I have small issue.I have attached the one file.in that combo chart creating the actual and budget measures.

when i mouse over on the bar it showing all measure names and values.if i do mouse over the budget bar need to show only budget name and budget values.no need t show reaming measure names and values.is it possible to do this.

Thanks 

Channa
Specialist III
Specialist III

Qlik sense you can't void poopup

but you an build meshups using java script there you can restrict or you can control poopups 

Channa