Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
ABlancardi
Contributor
Contributor

Range sum of null datas

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 

ABlancardi_0-1678886065159.png

 

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 

 

 

Labels (1)
1 Reply
AfeefaTk
Support
Support

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