Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
achates2008
Contributor III
Contributor III

how to get value in table column and use it in set analysis?

I have a report that will calculate by context as below.

The first Open Backlog is saved in database, then latter will be calculated as: Open Backlog + Order - Shipment = Backlog = Next Open Backlog.

Currently I am using expression as : If(RowNo(total)=1, Sum(Total Netbl),Above(TOTAL [Backlog],1))

The problem is, if I select year 2018, then I will lose the beginning backlog so the result will be wrong.

To solve this, I am thinking to calculate with a way like:

Backlog = Sum(Total Netbl) + Sum({<Week={'<current week'}>} Order) - Sum({<Week={'<current week'}>} Shipment)

So is there a way to get the value of "current week" which is presented in the column "week"?

Or is there other solution to avoid the issue?

backlog.png

0 Replies