topic Re: Alternate rows sum in straight table in QlikView

Alternate rows sum in straight table

Wed, 18 Mar 2015 09:21:13 GMT

Hi QV,

I have below data :

Now in a straight table based on rank(value) I need table should look like below :

Could anyone tell me how to write expr for sum above.

here sum is calculated by adding the odd rows i.e. if rank equals to 1/3/5/7... then I need to sum the Value.

Thanks,

Ananth

tresB — Wed, 18 Mar 2015 09:41:41 GMT

Check attached sample.

Sum(total {<ID={"=Odd(Rank(Sum(Value)))"}>}Value)

Wed, 18 Mar 2015 09:48:58 GMT

Thank you very much, this is what exactly I want.