Qlik Community

Qlik Sense App Development

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

Highlighted
ramanarayan
New Contributor III

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

Tags (1)
Labels (1)
4 Replies
Somasundaram
Contributor III

Re: help with set analysis expression

Hi,,

 

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

 


-Somasundaram
Partner
Partner

Re: help with set analysis expression

let's try using:
rangesum( above( sum(Demand), 0, RowNo() ) )
as expression
ramanarayan
New Contributor III

Re: help with set analysis expression

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
New Contributor III

Re: help with set analysis expression

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.

Tags (1)