Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
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

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 III
Specialist III

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

Highlighted

Where do you need to take those values?

Highlighted
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

Highlighted
Partner
Partner

Thank you!! It's this