Discussion board where members can get started with Qlik Sense.
Hello. My question on picture:
Go to Solution.
Try this with changing underlined values according to your requirement
If(Dimensionality()=2,rangesum(above( sum(NormalValue), 0, rowno() )),aggr( rangesum(above( sum(NormalValue), 0, rowno() )),Month ) )
change your expression as follow:
if(dimensionality()=2, your expression))
thanks. but I need calculate month values also with accumulation
What value you want to display at months.exactly??
if(Dimensionality()=1,aggr(rangesum(Above(aggr(Sum(CA),Month),0,RowNo())),Month), rangesum(Above( Sum(CA),0,RowNo())))
Per analogy, I would have:
Glad it helped you