Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rafaeloneil
New Contributor III

Help to group data in a PivotTable

Good afternoon Guys,

I have the following table and I'm breaking my head to account for my data correctly:

Tabela4.png


I need to count only the chassis that had lows (Date_Baixa = null) and group them by mm / yyyy of low and Uf of origin


it would be something like this:


TabelaResultado.png


Can you give me an orientation?

4 Replies
ogautier62
Valued Contributor II

Re: Help to group data in a PivotTable

Hi,

use cod_cliente, Uf, yearMonth as dimension,

and in your expression :

count({<NuChassi = E({<Date_Baixa = {'*'} >} ) >}  NuChassi)

E() is to exclude, '*' for all whiche as a value :  so you gat only nullvalues for date

regards

narayanamsn
New Contributor III

Re: Help to group data in a PivotTable

Can you please share excel sheet instead of snapshot? I will share the solution

thiago_justen
Valued Contributor III

Re: Help to group data in a PivotTable

Rafael,

Você pode criar uma pivot table com:

Dimensões:

mês/ano - supondo que você a tenha criado no script monthname(Campo_Data);

cod_cliente;

uf;

Expressão:  NullCount(data_baixa)

Abs e Sucesso!!

Thiago Justen Teixeira Gonçalves
WhatsApp: 24 98152-1675
Skype: justen.thiago
rafaeloneil
New Contributor III

Re: Help to group data in a PivotTable

Thank you guys, It worked well.

Community Browser