Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
I have the folowing formulas :
if(date(monthend(today(),-1),'YYYY/MMM') >= YearMonth,0,
if(Sum({<[Cost account L2]={'Internal'}>}[Quantity (k€)_CPhasing]) <> 0,
Rangesum(Above(Sum({<[Cost account L2]={'Internal'}>}
[Quantity (k€)_CPhasing]
),0,NoOfRows()))
+$(vForecast)))
VForecast in a variable.
The problem here, when I don't have datas for one month it shows me 0, I would like to have the sum of previous month instead . See example bellow
As you can on light green, for May I don't have any datas but I would like to have on my graph the sum of previous month.
I tried to to use a simple sum instead of a range sum and then accumulate, but in doing that my variable is not taking into account anymore ...
So my questions are :
Is there a link between variable and range(sum) function ?
How can I Make an accumulation including my variable ?
How can I make a range sum accumulation ?
Or how can I get the numeric value of my variable but without taking into account the formula of the baseline ? Is it possible ?
Thanks a lot for your help
Thanks
Hi @ABlancardi
It appears that this question has ended up in the wrong forum. In this forum, we're able to help you with Qlik Application Automation-related questions.
Qlik Application Automation provides a no-code visual interface that allows you quickly build automated analytics and data workflows.
Please post this question in the forum related to the product you are using and you will get help there.
Thanks