Range sum of null datas

ABlancardi — Fri, 15 Nov 2024 21:59:41 GMT

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

Re: Range sum of null datas

AfeefaTk — Thu, 16 Mar 2023 04:21:05 GMT

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

topic Re: Range sum of null datas in App Development

Range sum of null datas

Re: Range sum of null datas