Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
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

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)