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: 
fransnylin
Contributor II
Contributor II

Can I refernce value of previous field in Qlik Sense?

Hi,

Is it possible to reference the value of a calculation in another cell in a table/pivot (like done in Excel)?

I am developing a forecast and order plan app and its having some pretty advanced calculations. For example for each of the 12 coming months i calculate:

- Expected number of items in Stock (based on opening balance and average usage)

- I will then have to calculate when to order more products based on expected delivery time etc. This will then loop back to the expected balance once the products have come in to stock.

I do want to avoid to complex formulas and have more straight forward excel formulas as I expect them to be easier maintaining and debugging.

 

-

 

2 Solutions

Accepted Solutions
Channa
Specialist III
Specialist III

u can use Column(1) ,column(2)

Channa

View solution in original post

2 Replies
Channa
Specialist III
Specialist III

u can use Column(1) ,column(2)

Channa