Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Sum the value of previously available date

Hi,

I have data like below,

Date               closing_amount

22/03/2018           100

23/03/2018            1000

26/03/2018           500

27/03/2018            100


For each date I am creating new column which is previous day's closing amount.

If previous date is not there, then it should take previous to previous date, which i have achieved through variables.


But, how to dynamically find the previous available date in front end and use in set analysis.

sometimes the date difference be 3 or 4 , how to find the previous available date's closing_amount.


6 Replies
shiveshsingh
Master
Master

try

Above(sum(closing_amount)) in expression

Anonymous
Not applicable
Author

I cannot use above, at a time am showing only for one date in table.

shiveshsingh
Master
Master

Can you share the app and also highlight the expected output?

sasiparupudi1
Master III
Master III

sum({<Date={"$(=Max(Date,1))"}>}ClosingAmount)

Anonymous
Not applicable
Author

This isn't working, is there anyway to automatically take the previous available date

sasiparupudi1
Master III
Master III

Sorry It should be

sum({<Date={"$(=Max(Date,2))"}>}ClosingAmount)