Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Stop accumulation ahead

Hi, I've been struggling for a while on this script. I have a calendar (Jan to Dec) as my X axis & value as Y axis.

I have  data for only a few months, Jan to Mar, however, the data accumulates all the way to the next month (April) even with background colors applied. It's always essentially showcasing data as the month in advance. 

See below expression.  

=num(SUM({<[New] = {'No'}, [Type] = {'Titan'}>}[Value]))

and background color applied.

if(num(sum({<[Type] = {'Titan'},[New] = {'No'}>}[Value])),rgb(128,0,255),white())
There is only data for 3 months. The background color restricts it, but only up until April (Month ahead, even though there is no data for that month !). Please advise. 

Labels (2)
2 Replies
OmarBenSalem

Can you please attach an image of what u have so that the explanation/expectation would be easier to understand?

Anonymous
Not applicable
Author

the example attached. I have  data from  September to November. No data for November whatsoever.