Classification using operators

Wed, 06 Nov 2013 18:08:52 GMT

Hey guys,

I have some Excels with classifications like the following one:

Field1	Field2	Field3	Field4	Concat Key	Result
Y	N	Entity1	0.5	Y\|N\|Entity1\|0.5	Line1
N	*	Entity2	*	N\|\|Entity2\|	Line2

What I do is:

Create a concat key using fields from my dataset -> Field1&|&Field2&|&Field3&|&Field4 as Concat
Store Concat Key and Result fields from Excel file into variables
Apply a Pick+Wildmatch function

In fact, I am using "mappingwithwildcards.qvw" from Downloads - Rob Wunderlich Qlikview Consulting website.

The BIG issue is with this classification:

Field1	Field 2	Field 3	Field 4	Field 5	Result
= N	<> Y	= Entity7	= 0.5	= N	Line20
<> N	= N	<> Entity1	<> 0	= Y	Line30

I managed to separate the operator and the value like:

Operator_Field3	Field3
<>	Entity1

But now I have no idea on how to perform the matching. I can not simply modify the excel file lane by lane adding new rows for ALL the possible values because some fields have more than 50 different values... Nor using a concat key because operator can not be interpreted. It should be something dynamic.

Keep in mind that all the fields used in the Excel classification DO exist in my dataset. And the classification output must be Result value.

Any help would be really appreciated!

Re: Classification using operators

Thu, 07 Nov 2013 07:39:49 GMT

Any idea?

topic Re: Classification using operators in QlikView

Classification using operators

Re: Classification using operators