Discussion board where members can get started with QlikView.
I have data like below,
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.
Above(sum(closing_amount)) in expression
I cannot use above, at a time am showing only for one date in table.
Can you share the app and also highlight the expected output?
This isn't working, is there anyway to automatically take the previous available date
Sorry It should be