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

# 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

• ###### 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:

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.