5 Replies Latest reply: Jul 1, 2011 12:33 PM by cg-innova RSS

    Date problem using Set Analysis

    npeyroux

      Hi there,

      I'm new user of Qlikview and manage to do an analysis using dates and values.

      My data strucutre is a table with the following fields : DATE - Name - Account - CASH

      I tried to do an analysis based on the date for the cash field, e.g. having a column with cash for a selected date and another one for (selected date - 1).

      I've tried to do the following but it doesn't work:

       

      Sum

      ( {$<DATE=DATE>} CASH) --> for the selected date which works



      Sum({1<DATE =$(DATE-1)>} CASH) --> dosn't work. In fact, it gives the total sum of the CASH for all data.

      Could you please help me.

      Thx & Regards,