Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
breno_morais
Partner
Partner

Match with contains

Hello,

I have field 'Custo_Folha' with values and I need to take this values where 'Evento_Folha' contains name "HORAS EXTRAS", see:

Qlik Sense Desktop.jpg

Any help is appreciated

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Use an aggregation function like Sum() or what is appropriate to 'take the values' with a set expression or an if() statement, something like

=Sum(If(Evento_Folha Like '*HORAS EXTRA*', Custa_Folha))

or

=Sum({<Evento_Folha = {"*HORAS EXTRA*"}>} Custa_Folha)

View solution in original post

4 Replies
Or
Master II
Master II

Looks like you just need WildMatch() - what seems to be the problem?

MarcoWedel

Where do you need to take those values?

swuehl
MVP
MVP

Use an aggregation function like Sum() or what is appropriate to 'take the values' with a set expression or an if() statement, something like

=Sum(If(Evento_Folha Like '*HORAS EXTRA*', Custa_Folha))

or

=Sum({<Evento_Folha = {"*HORAS EXTRA*"}>} Custa_Folha)

View solution in original post

breno_morais
Partner
Partner
Author

Thank you!! It's this