topic Re: Replace multiple values to one value in QlikView

Replace multiple values to one value

Fri, 21 Aug 2015 07:03:26 GMT

how to set two values in variable for text object action?

Select Variable: vCountry

Select Value: 'India' and 'BHARAT' it does not work for me tried pick match but still not working

i have India and BHARAT in my Region field, i mean some file has BHARAT and some files has India.

i want when BHARAT is selected it should show India\BHARAT same when BHARAT selected show India\BHARAT in button.

can we replace two values with one value by using REPLACE function?

Re: Replace multiple values to one value

Kushal_Chawda — Fri, 21 Aug 2015 07:08:30 GMT

In script create a new field

if(match(lower(Region),'india','bharat','India',Region) as New_Region

Re: Replace multiple values to one value

Fri, 21 Aug 2015 07:21:18 GMT

hi kush,

thanks for your reply, but it does not work, cant we do in text object action?

Re: Replace multiple values to one value

jagan — Fri, 21 Aug 2015 07:27:24 GMT

HI,

Try like this in script

LOAD

if(match(lower(Region),'india','bharat','India',Region) as New_Region

FROM DataSource;

No use New_Region field as filter.

Hope this helps you.

Regards,

Jagan.

Re: Replace multiple values to one value

Kushal_Chawda — Fri, 21 Aug 2015 07:27:40 GMT

I quite don't understand if user is going to select the Region from listbox then why you need text object and button

Re: Replace multiple values to one value

Fri, 21 Aug 2015 07:32:55 GMT

Hi,

If your intention is to combine two values into one, then below script will help you.

=Replace(Replace(Country,'Bharat','INDIA'),'India','INDIA / BHARAT') as Region,

If you take the list box REGION the you will seen combined value for India and Bharat as INDIA / BHARAT.

Regards,

Pavan.

Re: Replace multiple values to one value

sasiparupudi1 — Fri, 21 Aug 2015 09:47:58 GMT

use an if condition

if (lower(region)='india' or lower(region)='bharat','india\BHARAT',region)

hth

Sasi

Re: Replace multiple values to one value

jsingh71 — Fri, 21 Aug 2015 09:52:55 GMT

See this:

=if(Region = 'India' or Region ='Bharat', 'India/Bharat',Region)

Re: Replace multiple values to one value

veidlburkhard — Fri, 21 Aug 2015 10:09:52 GMT

Hi Nilanjan,

you have to enter your selections like this:

Hope this helps

Burkhard

Re: Replace multiple values to one value

Fri, 21 Aug 2015 10:10:17 GMT

Hi guys thanks a lot for all the useful answers.