1 Reply Latest reply: Aug 25, 2014 6:10 PM by Oswaldo Vasquez RSS

    Dúvida de Iniciante

      Primeiro - Senhores, venho pesquisando em blogs e Forum, mas ainda não consegui encontrar algum curso prático de Qlik aqui no RJ ou On-Line.

       

      Poderia me indicar algum?

       

      Segundo - Estou querendo criar um gráfico de barras que separe por um período de 12 meses chamados por status.

      Exemplo:

       

      Ticket     Description          Status      Open Date     Close Date

      0001       Criar usuário         Closed     01/01/2014     03/01/2014

      0002       Erro de API           Open       03/02/2014     05/02/2014

      0003       Criar usuário         Closed     01/01/2014     03/01/2014

      0004       Reset Senha         Open       01/04/2014     03/04/2014

       

      Barras.jpg

        • Re: Dúvida de Iniciante

          Hi,

           

          To create a rolling 12 like your image you need 3 formulas, something like thhis:

           

          Combo Chart:

          Dimension: Period

          Expression1: Opened

          Count({<Status = {'Opened'}, Period= {">=$(=AddMonths(Max(Period),-11))<=$(=Max(Period))"}, DateField=, MonthField=, YearField=>}DISTINCT Ticket)

           

          Expression1: Closed

          Count({<Status = {'Closed'}, Period= {">=$(=AddMonths(Max(Period),-11))<=$(=Max(Period))"}, DateField=, MonthField=, YearField=>}DISTINCT Ticket)

           

          Expression1: Back log // If Back Log is a value of status field

          Count({<Status = {'Back log'}, Period= {">=$(=AddMonths(Max(Period),-11))<=$(=Max(Period))"}, DateField=, MonthField=, YearField=>}DISTINCT Ticket)

           

          You need create a Period Field based on main date field (Open Date or Close Date) with funtion MonthName, something  like this:

          Load

              Ticket,

              Description,

              Status,

              [Open Date],

              [Close Date]

              MonthName(DateField) as Period // DateField can be Open Date or Close Date

          From MyData.qvd;

           

          With this you select a year and a month and you get 12 months rolling back based on your selection:)

           

          Best regards.

           

          Rolling12.png