topic Re: Cash Flow in QlikView

Cash Flow

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

Hi guys

my customers whats a cash flow documents

I get ( enclosed a file )

list of expenses with dates , sum and type of expense

I need to create an object that give me the expected cash for a certain date

I do not know how to get data from one cell up in an object

thanks

gidon

PrashantSangle — Mon, 29 Oct 2018 16:15:51 GMT

Please find attachment.

Regards,

gidon500 — Mon, 29 Oct 2018 17:35:05 GMT

thank you very much for your fast response

it seems not to work in my models

the command

Above(isnull(DATE))

does no seem to work

do I need to define any documents parametrs

the test you sent me works great

thanks

gidon

gidon500 — Mon, 29 Oct 2018 17:53:33 GMT

enclosed is my docs , can you see why it does not work

thanks

gidon

sunny_talwar — Mon, 29 Oct 2018 18:30:48 GMT

You can also try this

25248 - RangeSum(Above(Sum(TotalShekel), 0, RowNo()))