Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

count 2 column values Qlik Sense Desktop

I would count how many times appears in the Status column "WAITING" and "CLOSE" when the reference is "Preventive Based on Time" column in TipoManutenção

     

StatusSchedule StartResponsávelTurnoTipoManutencao
WAITING31.01.2016ANDERSON LEITE DE LIMATURMA APreventiva Baseada no Tempo
CLOSE ORLANDO DA SILVA PORTOTURMA DPreventiva Baseada no Tempo
CLOSE ORLANDO DA SILVA PORTOTURMA DPreventiva Baseada no Tempo
CLOSE PATRICK TRINDADE OLIVEIRATURMA BPreventiva Baseada no Tempo
CLOSE MAIKO ALVES SANTOSTURMA CPreventiva Baseada no Tempo
CLOSE PATRICK TRINDADE OLIVEIRATURMA BPreventiva Baseada no Tempo
CLOSE ANDERSON LEITE DE LIMATURMA APreventiva Baseada no Tempo
CLOSE PATRICK TRINDADE OLIVEIRATURMA BPreventiva Baseada no Tempo
CLOSE ARLEY RODRIGUES DA SILVAMAN MECPreventiva Baseada no Tempo
CLOSE ARLEY RODRIGUES DA SILVAMAN MECPreventiva Baseada no Tempo
CLOSE ANDERSON LEITE DE LIMATURMA APreventiva Baseada no Tempo
CLOSE ARLEY RODRIGUES DA SILVAMAN MECPreventiva Baseada no Tempo
CLOSE MAIKO ALVES SANTOSTURMA CPreventiva Baseada no Tempo
CLOSE ORLANDO DA SILVA PORTOTURMA DPreventiva Baseada no Tempo
8 Replies
sunny_talwar

May be like this:

Count({<Status = {'CLOSE', 'WAITING'}, TipoManutencao = {'Preventiva Baseada no Tempo'}>}Status)

Not applicable
Author

Thank Sunny T and adding another Type column with the value "Operation", as would be the expression?

sunny_talwar

May be this:

Count({<Status = {'CLOSE', 'WAITING'}, TipoManutencao = {'Preventiva Baseada no Tempo'}, Type = {'Operation'}>}Status)

Not applicable
Author

Thanks Sunny T!

I would like to sum the Horas column when the reference TipoManutencao column is "Preventiva Baseada no Tempo"

Can you help me?     

TipoManutencaoMotivopostergaçãoDias PostergadosHorasMonth
Preventiva Baseada no Tempo 0,00January
Preventiva Baseada na Condição 2,00March
Corretiva 0,00March
Preventiva Baseada no Tempo 0,00March
Preventiva Baseada no Tempo 0,00April
Preventiva Baseada no Tempo 0,00April
Preventiva Baseada no Tempo 0,00April
Preventiva Baseada no Tempo 0,00March
Preventiva Baseada no Tempo 0,00March
Preventiva Baseada no Tempo 0,00April
Preventiva Baseada no Tempo 0,00April
Preventiva Baseada no Tempo 0,00March
Corretiva 13,47March
sunny_talwar

You want to Sum or Count?

For sum you can do this:

Sum({<TipoManutencao = {'Preventiva Baseada no Tempo'}>}Status)

But this will give 0 for your current sample

Or this for count:

Count({<TipoManutencao = {'Preventiva Baseada no Tempo'}>}Status)

Not applicable
Author

I want sum, however making reference to Hours column, plis!

sunny_talwar

This isn't working?

Sum({<TipoManutencao = {'Preventiva Baseada no Tempo'}>}Status)

Not applicable
Author

Thank Sunny T!

You have some content of sample count and sum of expressions to help in my visions?

Thanks in advance!