Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.