topic Re: Using + in If function in QlikView

Using + in If function

madhuqliklondon — Wed, 25 Nov 2020 16:16:04 GMT

I am trying to divide the column data into filter value can I use + with if example: can I use the following script??

if ([Brand]='so', 'sony', if([Brand]='lg', 'lg',if([Brand]='ss'+'sp'+'sm','samsung', 'Other'))) as "Brand name"

Re: Using + in If function

antoniotiman — Wed, 05 Jul 2017 13:42:20 GMT

Hi,

maybe & instead of +

'ss'&'sp'&'sm' -> ssspsm.

However i'm not sure this is what You need.

Regards,

Antonio

Re: Using + in If function

sergio0592 — Wed, 05 Jul 2017 13:44:24 GMT

What is the expected meaning or using + ?? Is it if ([Brand]= 'ss' or 'sp' or 'sm', 'Samsung', 'Others') ?

Re: Using + in If function

stigchel — Wed, 05 Jul 2017 13:45:20 GMT

I think you're looking for soemthing like this:

if([Brand]='ss' or [Brand]='sp' or [Brand]='sm','samsung'

Re: Using + in If function

ahaahaaha — Wed, 05 Jul 2017 13:46:00 GMT

Hi,

Try

if ([Brand]='so', 'sony', if([Brand]='lg', 'lg',if([Brand]='ss' Or [Brand]='sp' Or [Brand]='sm','samsung', 'Other'))) as "Brand name"

Re: Using + in If function

effinty2112 — Wed, 05 Jul 2017 13:46:31 GMT

Hi Madhu

try:

Pick(Match(Brand, 'so','lg','ss','sp','sm'),'sony','lg','samsung','samsung','samsung')

Edit: to take care of 'Other'

Pick(1+Match(Brand, 'so','lg','ss','sp','sm'),'other','sony','lg','samsung','samsung','samsung')

Re: Using + in If function

jmvilaplanap — Wed, 05 Jul 2017 13:46:55 GMT

Hi, Madhu

I think you must to split the values of "Samsung", you mus to write this

if ([Brand]='so', 'sony', if([Brand]='lg', 'lg',if([Brand]='ss' or [Brand]='sp' or ='sm','samsung', 'Other'))) as "Brand name"

Regards

Re: Using + in If function

juan_patrick — Wed, 05 Jul 2017 13:47:12 GMT

Hi Mafhu!

Try this:

if (match([Brand],'so'), 'sony',

if(match([Brand]='lg'), 'lg',

if(match([Brand], 'ss', 'sp', 'sm'),'samsung', 'Other'))) as "Brand name"

¡Good luck!

Re: Using + in If function

madhuqliklondon — Wed, 05 Jul 2017 13:47:37 GMT

Hi,

where ever in that field it says 'ss' or 'sp' or 'sm' they should go under 'samsung'.

Re: Using + in If function

stigchel — Wed, 05 Jul 2017 13:51:24 GMT

Instead of the nested if's it would be better practice to use a map for this:

Map:

Mapping Load * Inline [From, To

'so', 'sony'

'lg', 'lg'

'ss','samsung'

'sp','samsung'

'sm','samsung'

];

And then where you load the brand field use

Applymap('Map',BrandField,'Other') as [Brand name]

Re: Using + in If function

madhuqliklondon — Wed, 05 Jul 2017 14:33:32 GMT

there is small issue which I forgot , there is a another column where they made in ‘made in’ for LG

I want only ‘made in’ ‘UK’ or ‘EU’ for brands remaining it’s fine. For now this is my script

if ([Brand]='so', 'sony', if([Brand]='lg', 'lg',if([Brand]='ss' Or [Brand]='sp' Or[Brand]='sm','samsung', 'Other'))) as "Brand name"

I want to use ‘match’ ’made in’ UK or EU if([brand]=’lg’ ,’lg’.

Re: Using + in If function

jmvilaplanap — Wed, 05 Jul 2017 14:41:06 GMT

You can add this new condition to the line, comparing the "country" column. For example

if(Brand = 'sm' and Country='UK', 'samsung', 'Other') as "Brand name"

Re: Using + in If function

effinty2112 — Wed, 05 Jul 2017 14:42:06 GMT

Hi Madhu,

try

Pick(1+Match(Brand,'lg'),'UK','EU')

EDIT: Misread your message and got things backward

Pick(1+Match(Brand,'lg'),'EU','UK')

Re: Using + in If function

madhuqliklondon — Wed, 05 Jul 2017 14:45:50 GMT

Hi,

is' made in' column name is not required in script?

Re: Using + in If function

effinty2112 — Wed, 05 Jul 2017 15:17:54 GMT

Hi,

If you have a chart with dimension Brand then

Pick(1+Match(Brand,'lg'),'EU','UK')

will work as an expression.

Putting it in the script instead does makes sense. Then you'll have [Made In] as a dimension in your data model.

cheers

Andrew

Re: Using + in If function

madhuqliklondon — Wed, 05 Jul 2017 15:20:08 GMT

Hi Andrew,

I am writing this in script level.

Re: Using + in If function

stigchel — Wed, 05 Jul 2017 15:29:23 GMT

If I understand you correctly that would be

if ([Brand]='so', 'sony', if([Brand]='lg' and ([made in]='UK' or [made in]='EU'), 'lg',if([Brand]='ss' Or [Brand]='sp' Or[Brand]='sm','samsung', 'Other'))) as "Brand name"

Re: Using + in If function

madhuqliklondon — Wed, 05 Jul 2017 15:51:12 GMT

Hi,

Is match is not required???

Re: Using + in If function

stigchel — Wed, 05 Jul 2017 16:08:54 GMT

That depends on the contents of the [made in] field, I don't know your data and/or data model. The = operator will only be true for exact matches, if [made in] is for example a concatenated string of countries you could use

WildMatch([made in],'*EU*','*UK*')>0