Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

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
Highlighted
Master
Master

Re: Sum the value of previously available date

try

Above(sum(closing_amount)) in expression

Highlighted
Creator II
Creator II

Re: Sum the value of previously available date

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

Highlighted
Master
Master

Re: Sum the value of previously available date

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

Highlighted
Master III
Master III

Re: Sum the value of previously available date

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

Highlighted
Creator II
Creator II

Re: Sum the value of previously available date

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

Highlighted
Master III
Master III

Re: Sum the value of previously available date

Sorry It should be

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