topic Re: Set analysis, string search in QlikView

Set analysis, string search

Mon, 24 Aug 2015 10:04:02 GMT

Hi,

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

Any suggestions?

jagan — Mon, 24 Aug 2015 10:08:07 GMT

Hi,

Try liek this

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

Edit: Missed Quote in set analysis expression

Hope this helps you.

Regards,

Jagan.

kaushiknsolanki — Mon, 24 Aug 2015 10:08:09 GMT

Hi,

Try this.

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

Regards,

Kaushik Solanki