Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Opening Balances > Date Set Analysis

Hi Experts,

From data mentioned below, how can i get the opening balances (Based on column DocDate) for start of every month, for OBQtyOpening.

Perhaps I need a temporary table of dates for opening balance for which the script will get Lesser Than value comparing with column DocDate again, (just loud thinking)

e.g. getting value of column OBQtyOpening comparing with DocDate < 11/01/16 Opening Balance of:

  1. DocDate < 11/01/16
  2. DocDate < 12/01/16
  3. DocDate < 01/01/17

* OR YTD option may also help in this scenario i.e. e.g. a Date is selected 12/01/16. how can i get the value of OBQtyOpening lesser than selected date.

YearMonthDocDateOBQtyOpening
20161110/31/1610
20161110/31/1615
20161111/30/1611
20161212/31/1650
20161212/31/1635

Help Required Please!

4 Replies
sunny_talwar

I am not sure I understand what your expected output here is. Would you be able to provide some more example as to what you expect to see?

Not applicable
Author

Thanks, actually i have just decided to redesign the whole application.

Not applicable
Author

can you please guide me how can i see me previously posted questions / discussions?

sunny_talwar

Open this link: shazadnazir