Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

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

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

Contributor II
Contributor II

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