Dúvida de Iniciante

[#1]

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

[#2 · Accepted solution]

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.