Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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