topic Re: Range sum prbolem in QlikView

Range sum prbolem

swarnendu — Wed, 25 Nov 2020 16:16:04 GMT

Hello guys,

I am facing a problem need some help.

I am just calculate like

sum(total qty)*80/100.

I am fetching data from excel.I want to pick the actual nearest qty from excel and with respect this i want to calculate the value .

example: 80% of my total quantity is let 1500

i am using range sum above function.I need the value near of 1500 which is taken from qty field from raw excel.

but the fact is its not working for me.

i am just attach screenshot please check this and if you have any solution then please provide me.

MK_QSL — Fri, 16 Mar 2018 12:14:11 GMT

you will get little idea from this..

sunny_talwar — Fri, 16 Mar 2018 12:14:27 GMT

I am not sure I understand the issue, but would you be able to share the Excel file to look at it.

PrashantSangle — Fri, 16 Mar 2018 12:46:22 GMT

To achieve it You have to perform complex logic.

Possible logic could be

create a variable which store your value to which you want to compare

then crate a temp table which contain difference between actual qty and compare qty.

then organize it asc order, using order by on newly compare qty.

then using peek() take 1st row or rank() to achieve your desired requirement.

Regards,

swarnendu — Sat, 17 Mar 2018 13:26:23 GMT

Thanks for your reply.

i need to calculate cumulative sum using expression