0 Replies Latest reply: Jun 12, 2018 2:32 PM by João Lucas Morais Carvalhido RSS

    Storage

    João Lucas Morais Carvalhido

      Guys, i need to make an in bar graph at QlikSense, showing the store of every month of the year (exemple image in annex), with the data:

      Num_Document;

      Entrence_Date;

      Decision_Date;

       

      The condicion will be:

      if the document has decision date, then every month since decison date -1 (becase if the document had decision at the month X so the month X can't be storage, that's why the -1), until the entrence date had this document like storage, Else every month until today has the document like storage.


      Document

      Entrence

      Decision

      Jan/17

      Feb/17

      Mar/17

      Apr/17

      May/17

      Jun/17

      X

      10/01/2017

      10/05/2017

      1

      1

      1

      1

      0

      0

      Y

      31/03/2017

      31/10/2017

      0

      0

      0

      1

      1

      1

      Z

      30/04/2017

      30/04/2017

      0

      0

      0

      0

      0

      0

      Storage:

      1

      1

      1

      2

      1

      1

       

      OBS: The Entrence date and Decision Date is uneven, change and repet depending on Entrence date and Decision Date, that is, in one day can entry alot of documents and in te other can be judge.

       

      what i got: if(IsNull(Decision_Date) = -1, 0, Decision_Date) as Judge,