Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Need expression for opening stock in inventory

Hi all,

i need expression for finding opening for stock calculation

now i have closing stock calculation

=sum({<CYYear=,CYMonth=,Period=,PostingDate={"<=$(#vInvDate1)"}>}Quantity) 

vInvDate1=  =date(max([Posting Date]),'DD/MM/YYYY')

kindly help to change the same expression into  opening stock calculation..

Advance thanks

Sirajahamed S

0 Replies