QlikView App Dev

hemeshreddy · ‎2017-08-21

Hi guys PFA,

In this for year 2016 i am getting wrong accumulated sum

Regards,

Hemesh

Anil_Babu_Samineni · ‎2017-08-22

Use this?

RangeSum(above(TOTAL sum(Sale),0,RowNo(TOTAL)))

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

Anil_Babu_Samineni · ‎2017-08-22

Which graph we need to look? There is 2 graphs

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

hemeshreddy · ‎2017-08-22

second graph

Anil_Babu_Samineni · ‎2017-08-22

What's wrong here?

I used this?

RangeSum(Above(Sum(Sale),0,RowNo(TOTAL)))

And enable Full accumulation radio button

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

hemeshreddy · ‎2017-08-22

i need without checking the full accumulation radio button.

Anil_Babu_Samineni · ‎2017-08-22

Use this?

RangeSum(above(TOTAL sum(Sale),0,RowNo(TOTAL)))

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

hemeshreddy · ‎2017-08-22

it is giving the correct result

May i know what is wrong in that expression which i written

Anil_Babu_Samineni · ‎2017-08-22

May be TOTAL Keyword missing, And one blog is there for the same. You can read that blog to understand whole

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

hemeshreddy · ‎2017-08-22

after giving Total key word also it's giving wrong result,

can u share me the blog URL

Anil_Babu_Samineni · ‎2017-08-22

Read this?

What does the TOTAL qualifier do?

And, FFor explanation in my way is TOTAL keyword can store the TOTAL sales and then we are displaying to each row level until RowNo(TOTAL) -- How many rows?

And read this too Missing Manual - Above() and Below()

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

QlikView App Dev

Rangesum function error