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: 
krish2459
Creator
Creator

Current Version - Pervious version Quantity

Hi,

I Want to compare the Compare the current version - Previous vesion quantity  as below.

krish2459_0-1651726326149.png

Uploading the sample data.

 

Thanks..

Labels (1)
2 Replies
vinieme12
Champion III
Champion III

As below

if(rowno()=1, Sum([Balance Quantity to Deliver])
,above(Sum([Balance Quantity to Deliver])) - Sum([Balance Quantity to Deliver]) )

 

qlikCommunity1.PNG

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
krish2459
Creator
Creator
Author

Hi Vineeth,

I'm not able to get the output.

Attaching the QVF.Please check once.

Thanks....