Solved: Set analysis, string search - Qlik Community - 980143

Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.

Skip to main content

Qlik.com | Qlik Services| Qlik Help |

Ask a Question

Hi,

need to sum (AMOUNT) if string 'XXXXX' can be found in field: DESCRIPTION.

Any suggestions?

1 Solution

Accepted Solutions

Hi,

Try this.

Sum({<Description = {"*XXXX*"}>}Amount)

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

View solution in original post

2 Replies

Hi,

Try liek this

=Sum({<DESCRIPTION={''*XXXXX*"}>} AMOUNT)

Edit: Missed Quote in set analysis expression

Hope this helps you.

Regards,

Jagan.

Hi,

Try this.

Sum({<Description = {"*XXXX*"}>}Amount)

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!