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: 
Vaku1606
Contributor III
Contributor III

How to break the link

Hello,

I following data:

Customer

Diameter

Length

Shape

Stock

Production quantity 

Production date

 

How can I set the formula, so that my stock does not change with the production date selection (because stock is as of today, regardless of the production date/month)?

Thanks in advance and regards

Labels (1)
1 Solution

Accepted Solutions
Or
MVP
MVP

Whatever the formula for stock is, add {< [Production Date] = >} to it. Example:

Sum( {< [Production Date] = >}  Stock)

 

View solution in original post

2 Replies
Or
MVP
MVP

Whatever the formula for stock is, add {< [Production Date] = >} to it. Example:

Sum( {< [Production Date] = >}  Stock)

 

Vaku1606
Contributor III
Contributor III
Author

thank you very much