Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
MVP
MVP

Re: Match with contains

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
Highlighted
Specialist II
Specialist II

Re: Match with contains

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

Highlighted

Re: Match with contains

Where do you need to take those values?

Highlighted
MVP
MVP

Re: Match with contains

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

Highlighted
Partner
Partner

Re: Match with contains

Thank you!! It's this