Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
RangeSum(Above(Sum({<[Budget Type Code]={'Actual'}>}Expense), 0, RowNo()))
RangeSum(Above(Sum(Sales), 0, RowNo()))
RangeSum(Above(Sum({<[Budget Type Code]={'Actual'}>}Expense), 0, RowNo()))
RangeSum(Above(Sum(Sales), 0, RowNo()))
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.
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.
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
Qlik sense you can't void poopup
but you an build meshups using java script there you can restrict or you can control poopups