topic Re: Is this possible? in QlikView

Is this possible?

nenadvukovic — Wed, 09 Dec 2015 22:17:06 GMT

Hi,

before getting a headache can you please tell me if something like this is possible to get in QlikView?

I got first 3 lines from QV but users want to have the 4th line present for each SKU, preferably in one line.

Thanks in advance. Cheers

Re: Is this possible?

swuehl — Wed, 09 Dec 2015 22:57:43 GMT

In general, it should be possible, since it's quite a common task to calculate something like that.

You should be able to find some similar stuff, e.g. searching for Running Balance:

Re: Calculate Running balance

Re: Bank Account Balance‌

Cumulative in pivot table (financial balance, debtors)

If you post a small sample QVW with some sample data, I believe someone around should be able to help you with the expressions.

Re: Is this possible?

nenadvukovic — Thu, 10 Dec 2015 11:44:28 GMT

Thanks Stefan. The "Cumulative in pivot table" article looks promising.

Re: Is this possible?

nenadvukovic — Thu, 10 Dec 2015 20:33:14 GMT

A strange thing happen. Around noon the QVapp from the Cumulative in pivot table (financial balance, debtors) worked and now it does not. I.e. it shows "Macro running" and nothing happens. Any idea why this happens?

Re: Is this possible?

swuehl — Thu, 10 Dec 2015 22:40:01 GMT

There is an OnOpen trigger that runs a Macro in the original poster's QVW document.

But I think all the macro code is not needed for the chart and cumulation, I suspect it's a relict of the original application of which the sample app has been derived from.

If you open the app, is there a dialog asking for system access permissions?

edit: I am reattaching the QVW, with all macros and triggers removed.

Re: Is this possible?

nenadvukovic — Mon, 14 Dec 2015 22:20:02 GMT

Thanks.

I got some running balances by weeks but am missing the Balance on hand and OnEarlier Orders to be used as an Opening Balance.

For example:

And a test file if you do not mind

Thanks

Re: Is this possible?

nenadvukovic — Mon, 14 Dec 2015 22:23:06 GMT

And the qvw

Re: Is this possible?

swuehl — Tue, 15 Dec 2015 00:55:23 GMT

Maybe like attached