2 Replies Latest reply: Oct 9, 2015 8:50 AM by Usama Anwar RSS

    how to use previous date in Set Analysis

    Usama Anwar

      Hi All,

       

      I am facing a small challenge in set analysis.

       

      I have loaded three dates from Data ware house in QlikView,

       

      - 30-Sep.

      - 31-Aug

      - 31-Jul

       

      I want a comparative analysis in a chart. By using set analysis, I got the latest (MAX) date balance i-e- 30-Sep and by using MIN function I got the 31-JUL balances.

       

      Syntax for both are as follows:

       

      For September:

      =sum({<UPDATE_DATE={'$(=MAX(UPDATE_DATE))'},Deposit_Product_Nature ={'CURRENT ACCOUNT'}>}AMOUNT_LCY)

      For July:

      =sum({<UPDATE_DATE={'$(=MIN(UPDATE_DATE))'},Deposit_Product_Nature ={'CURRENT ACCOUNT'}>}AMOUNT_LCY)

       

      What the syntax would be to present the 31-AUG balances?