Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
breno_morais
Partner - Contributor III
Partner - Contributor III

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
MVP
MVP

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)

breno_morais
Partner - Contributor III
Partner - Contributor III
Author

Thank you!! It's this