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

    Date problem using Set Analysis


      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:



      ( {$<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,