Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.


Opening Balance to Calculate and Show

Dear Experts,

I have made an analysis using text and image option and each line showing a different figure from a different qvd. It is also working for applying filter for example JUL-2017 and show figures for the period of Jul-2017. Now i want to add a line showing opening balance for 01-JUL-2017 i mean all transactions less than 01-JUL-2017. What can be the approach.

Details of report are given below:

Year: 2017 Month: Jul

Sales: 100 (for the period of Jul-2017)

Exp:       50 (for the period of Jul-2017)

Net:        50 (for the period of Jul-2017)

Opening: 100 (Less than 01-Jul-2017)

Closing:   150 (For month end Jul-2017)

Now the question is how to effeciently and effectively we can calculate Opening everything below 01-Jul-2017


Zahid Rahim