This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I am attaching my excel,
here ws1 is the field which i need to devide based on quantity.
i am getting like this
i want output like below.
my alocated it has to show 158 because ws1 is 158.
outfield should get from quantity.
Hi Any idea.
For Straight table properties->Expressions->call "Quantity" as a expression and there you can find options Left hand side of your Expression name
Partial or some values Accumulation
then u need to select Full accumulation.
use full accumulation like below
thanks for replay,
this need to done in script
Thanks for replay,
This need to be done in script
What would be the output if you have multiple ws1?
ws1 is same for particular id
Try like this using Previous() like below
RangeSum(Previous(AccumSum), Quantity) AS AccumSum
RangeSum(Peek(AccumSum), Quantity) AS AccumSum
then try this
if(rowno()=1 or ws1<>previous(ws1),Quantity, rangesum(peek('Cumulative'),Quantity)) as Cumulative
order by ws1,[Posting Date] desc;
drop table Data;