Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

daisy1438
New Contributor

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
Valued Contributor III

Re: help on expression for actual totals displayed cumulatively?

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

 

 

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

Channa
6 Replies
Channa
Valued Contributor III

Re: help on expression for actual totals displayed cumulatively?

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

 

 

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

Channa
daisy1438
New Contributor

Re: help on expression for actual totals displayed cumulatively?

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
New Contributor

Re: help on expression for actual totals displayed cumulatively?

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
Valued Contributor III

Re: help on expression for actual totals displayed cumulatively?

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

Channa
daisy1438
New Contributor

Re: help on expression for actual totals displayed cumulatively?

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
Valued Contributor III

Re: help on expression for actual totals displayed cumulatively?

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