Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
See why BI users voted Qlik #1 in 11 categories. GET REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
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
Highlighted
Specialist II
Specialist II

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

Highlighted
Creator
Creator

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

Highlighted
Specialist III
Specialist III

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
Highlighted
Contributor III
Contributor III

Thank you guys, It worked well.