Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

nenadvukovic
Contributor III

Is this possible?

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.

2015-12-09_23-21-13.png

Thanks in advance. Cheers

1 Solution

Accepted Solutions
MVP
MVP

Re: Is this possible?

Maybe like attached

View solution in original post

7 Replies
MVP
MVP

Re: Is this possible?

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.

nenadvukovic
Contributor III

Re: Is this possible?

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

nenadvukovic
Contributor III

Re: Is this possible?

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?

MVP
MVP

Re: Is this possible?

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.

nenadvukovic
Contributor III

Re: Is this possible?

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:

2015-12-14_23-10-40.jpg

And a test file if you do not mind

Thanks

nenadvukovic
Contributor III

Re: Is this possible?

And the qvw

MVP
MVP

Re: Is this possible?

Maybe like attached

View solution in original post