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: 
ramanarayan
Creator
Creator

help with set analysis expression

Hi Experts

Need help with an expression please.

 

In the chart named 'expression help' i have an expression which should give me the sum of demand + sum of demand where month = key + 1. 

I expect to see the value as 350 for the month of Aug.

I tried to use set analysis but i dont get the desired output. Can someone help please

Labels (1)
4 Replies
Somasundaram
Creator III
Creator III

Hi,,

 

Instead of Set Analysis, You can use Accumulate (in 2 steps)

 


-Somasundaram

If this resolves your Query please like and accept this as an answer.
agigliotti
Partner - Champion
Partner - Champion

let's try using:
rangesum( above( sum(Demand), 0, RowNo() ) )
as expression
ramanarayan
Creator
Creator
Author

Thanks for the reply.

If you can slightly tweak this expression in such a way that

For Aug, i need Aug+Sept values and for Sept i need Sept + Oct values.

 

If you can please help modify would be great.

ramanarayan
Creator
Creator
Author

Thanks for the reply.

If you can slightly tweak this expression in such a way that

For Aug, i need Aug+Sept values and for Sept i need Sept + Oct values.

 

If you can please help modify would be great.