Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
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
raman_rastogi
Partner - Creator III
Partner - Creator III

Channa
Specialist III
Specialist III

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

Channa