Dúvida de Iniciante

Mon, 25 Aug 2014 20:34:51 GMT

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

Mon, 25 Aug 2014 22:10:10 GMT

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.