Qlik Community

New to Qlik Community

Discussion board for questions on how to use Qlik Community and its features.

Announcements
This forum is for questions and information about how to use the Qlik Community.
Please do not post product related questions here.
Select the correct forum from: Qlik Product Forums
Not applicable

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

1 Solution

Accepted Solutions
Not applicable

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 selectionSmiley Happy

Best regards.

Rolling12.png

1 Reply
Not applicable

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 selectionSmiley Happy

Best regards.

Rolling12.png

Community Browser