topic Re: Wildmatch() in QlikView

Wildmatch()

gr_eldred — Wed, 30 Aug 2017 17:41:57 GMT

Good afternoon I have an error with the use of this Wildmatch when reloading data tells me that the syntax is incorrect is it possible to do this? What could be another option?

if( WildMatch( ApplyMap('Map_Clasific_art', %Art_ID,'N/A'), 'Iphone' ) and WildMatch( ApplyMap('Map_Subclasific_art', %Art_ID,'N/A'), 'iPhone 6', 'iPhone 6 Plus', 'iPhone 6S', 'iPhone 6S Plus', 'iPhone 7', 'iPhone 7 Plus', 'iPhone SE') , sum(Cantidad)

Re: Wildmatch()

felipedl — Wed, 30 Aug 2017 17:49:25 GMT

I believe you're missing the ending "if" parenthesis, like this:

(

WildMatch

(

ApplyMap('Map_Clasific_art', %Art_ID,'N/A'),

'Iphone'

)

and

WildMatch

(

ApplyMap('Map_Subclasific_art', %Art_ID,'N/A'),

'iPhone 6',

'iPhone 6 Plus',

'iPhone 6S',

'iPhone 6S Plus',

'iPhone 7',

'iPhone 7 Plus',

'iPhone SE'

) ,

sum(Cantidad)

) // This one is missing

Felipe.

Re: Wildmatch()

sunny_talwar — Wed, 30 Aug 2017 17:51:10 GMT

Check this

If(WildMatch(ApplyMap('Map_Clasific_art', %Art_ID, 'N/A'), 'Iphone') and WildMatch(ApplyMap('Map_Subclasific_art', %Art_ID,'N/A'), 'iPhone 6', 'iPhone 6 Plus', 'iPhone 6S', 'iPhone 6S Plus', 'iPhone 7', 'iPhone 7 Plus', 'iPhone SE'), Sum(Cantidad), 0) as YourFieldName

Also, I hope you are using Group By clause since you have Sum() in your load

Re: Wildmatch()

gr_eldred — Wed, 30 Aug 2017 17:58:41 GMT

sorry sorry The expression I am using is this.

Re: Wildmatch()

gr_eldred — Wed, 30 Aug 2017 17:58:49 GMT

sorry sorry The expression I am using is this.

Re: Wildmatch()

gr_eldred — Wed, 30 Aug 2017 18:00:49 GMT

Tells me that I have a syntax error but only when I add this wildmatch that is bold

if( WildMatch( ApplyMap('Map_Clasific_art', %Art_ID,'N/A'), 'Iphone' ) and WildMatch( ApplyMap('Map_Subclasific_art', %Art_ID,'N/A'), 'iPhone 6', 'iPhone 6 Plus', 'iPhone 6S', 'iPhone 6S Plus', 'iPhone 7', 'iPhone 7 Plus', 'iPhone SE') , sum(Cantidad) ,0) as cuota

Re: Wildmatch()

gr_eldred — Wed, 30 Aug 2017 18:01:12 GMT

Tells me that I have a syntax error but only when I add this wildmatch that is bold

Re: Wildmatch()

its_anandrjs — Wed, 30 Aug 2017 18:01:23 GMT

Another way for doing this is but question is will this is expression or the field you can use it on both ways

Expression:-

=Sum( if( WildMatch( ApplyMap('Map_Clasific_art', %Art_ID,'N/A'), 'Iphone' ) and

WildMatch( ApplyMap('Map_Subclasific_art', %Art_ID,'N/A'), 'iPhone 6', 'iPhone 6 Plus', 'iPhone 6S', 'iPhone 6S Plus', 'iPhone 7', 'iPhone 7 Plus', 'iPhone SE'), Cantidad ))

By Field:-

Load

...

Sum( if( WildMatch( ApplyMap('Map_Clasific_art', %Art_ID,'N/A'), 'Iphone' ) and

WildMatch( ApplyMap('Map_Subclasific_art', %Art_ID,'N/A'), 'iPhone 6', 'iPhone 6 Plus', 'iPhone 6S', 'iPhone 6S Plus', 'iPhone 7', 'iPhone 7 Plus', 'iPhone SE'), Cantidad )) as FieldNameHere

From Source

Group By ....;

Re: Wildmatch()

gr_eldred — Wed, 30 Aug 2017 18:01:34 GMT

Tells me that I have a syntax error but only when I add this wildmatch that is bold

Re: Wildmatch()

gr_eldred — Wed, 30 Aug 2017 18:05:42 GMT

I have more code below all this is considered I need help with what is in bold

Since adding the Wildmatch and mark me error as if it was not allowed

Re: Wildmatch()

sunny_talwar — Wed, 30 Aug 2017 18:09:30 GMT

Can you share a screenshot

Re: Wildmatch()

felipedl — Wed, 30 Aug 2017 18:12:25 GMT

As Sunny sugested, I believe you're missing a group by clause in your code.

This is what I tested

Mapping

Map_Clasific_art:

Load * inline

[

ID,Desc

1,Iphone

2,Android

];

Mapping

Map_Subclasific_art:

Load * inline

[

ID,Desc

1,iPhone 6

2,iPhone 6 Plus

3,iPhone 6S

4,iPhone 6S Plus

5,iPhone 7

6,iPhone 7 Plus

7,iPhone SE

8,Samsung J5

9,Samsung J7

];

data:

load * Inline

[

%Art_ID,Cantidad

1,1

2,2

3,3

4,4

5,5

6,1

8,10

9,100

];

temp:

Load

Type,

SubType,

if( WildMatch( Type, 'Iphone' ) and WildMatch( SubType, 'iPhone 6', 'iPhone 6 Plus', 'iPhone 6S', 'iPhone 6S Plus', 'iPhone 7', 'iPhone 7 Plus', 'iPhone SE') , sum(Cantidad) ,0) as cuota

group by Type,SubType;

Load

%Art_ID,

ApplyMap('Map_Clasific_art',%Art_ID,'N/A') as Type,

ApplyMap('Map_Subclasific_art',%Art_ID,'N/A') as SubType,

Cantidad

Resident data;

drop table data;

And it works fine (data may not make sense, but it works).

Felipe.

Re: Wildmatch()

gr_eldred — Wed, 30 Aug 2017 18:16:57 GMT

Of course for what is selected, in the penultimate if it is where I am interested to know if it is correct to have an and between two wildmatch

If (WildMatch (ApplyMap ('Map_Clasific_art',% Art_ID, 'N / A'), 'Iphone') y WildMatch (ApplyMap ('Map_Subclasific_art',% Art_ID, 'N / A' 6 Plus ',' iPhone 6S ',' iPhone 7 ',' iPhone 7 Plus ',' iPhone SE '), sum (Cantidad)

Re: Wildmatch()

gr_eldred — Wed, 30 Aug 2017 18:17:34 GMT

Re: Wildmatch()

its_anandrjs — Wed, 30 Aug 2017 18:19:28 GMT

Kindly check the fields that are used in the SUM() expression will they also used in the Group By or not if not you get this error and also rather than using Applymap inside of the SUM() you can used it before sum in the same field or you can use it by flagging on field and used on the expression.

Ex:-

Load

Id,Name,

Sum(Sales) as TotalSales

From Source

Group by

Id, //This is Important

Name; //This is Important

Re: Wildmatch()

sunny_talwar — Wed, 30 Aug 2017 18:30:59 GMT

Can you remove the highlighting, so that we can see the error?

Re: Wildmatch()

gr_eldred — Wed, 30 Aug 2017 18:40:44 GMT

Re: Wildmatch()

sunny_talwar — Wed, 30 Aug 2017 18:48:09 GMT

You seem to have parenthesis before if... these seems to be unnecessary... may be you are not closing them correctly?

Re: Wildmatch()

gr_eldred — Wed, 30 Aug 2017 19:58:45 GMT

Check the parenthesis but still continue the error I do not know if it is because I use two applymap of different fields.

Re: Wildmatch()

gr_eldred — Wed, 30 Aug 2017 20:00:44 GMT