topic Re: Multiple text search in set analysis in QlikView

Multiple text search in set analysis

udaya_kumar — Wed, 13 Sep 2017 06:50:43 GMT

Hi,

I have a field Role with values like

Tele India - Agent

Tele India - manager

SIT India - Manager

SIT India - Agent

Tele India Bangalore - Agent

..................

Here i want to sum the values in set analysis for only values where

Role is having India and Agent both

I have written exp like this

sum( {$<ROLE= {" India "}>} Value) - This will search for the rows which is having India in the Role field

But i want to have India and Agent both in the same row in the field ROLE.

How can i search for multiple values in set analysis? (It should work as "And" condition as the row should have both India and Agent)

Re: Multiple text search in set analysis

Anil_Babu_Samineni — Wed, 13 Sep 2017 06:57:11 GMT

May be this?

Load *, SubField(ROLE, ' ', 2) as ROLE_Country;

and expression should this?

Sum({<ROLE_Country = {'India'}>} Value)

Re: Multiple text search in set analysis

udaya_kumar — Wed, 13 Sep 2017 07:02:17 GMT

Hi Anil,

Thanks for the reply.

I want to have search for both India and Agent in ROLE field, not only India.

And i want it in set analysis.

Re: Multiple text search in set analysis

Anil_Babu_Samineni — Wed, 13 Sep 2017 07:03:43 GMT

First you need to split into different variations and can be achieve same

Re: Multiple text search in set analysis

tresB — Wed, 13 Sep 2017 07:10:26 GMT

May be like this?

sum( {$<ROLE= {"IndiaAgent*"}>} Value)

sum( {$<ROLE= {"India"}><ROLE= {"Agent*"}>} Value)

Re: Multiple text search in set analysis

udaya_kumar — Wed, 13 Sep 2017 07:16:22 GMT

Thank you very much Tresesco.

topic Re: Multiple text search in set analysis in QlikView

Multiple text search in set analysis

sum( {$<ROLE= {" *India* "}>} Value) - This will search for the rows which is having India in the Role field

Re: Multiple text search in set analysis

Re: Multiple text search in set analysis

Re: Multiple text search in set analysis

Re: Multiple text search in set analysis

sum( {$<ROLE= {"*India*Agent*"}>} Value)

sum( {$<ROLE= {"*India*"}>*<ROLE= {"*Agent*"}>} Value)

Re: Multiple text search in set analysis

sum( {$<ROLE= {" India "}>} Value) - This will search for the rows which is having India in the Role field

sum( {$<ROLE= {"IndiaAgent*"}>} Value)

sum( {$<ROLE= {"India"}><ROLE= {"Agent*"}>} Value)