topic Question about function Match in QlikView

Question about function Match

pgalvezt — Wed, 20 Nov 2013 13:28:22 GMT

Hello,

I have a problem with the match fuction:

I have this:

=Match(Account_Desc,'Sales','Details','','Revenue')

This works fine.

But in my dimension tab I put the next:(I filled the blank space with Total of values)

=If(Account_Desc='','Total of values', Account_Desc)

But my sort fuction left of work.

Account_Desc

Revenue

Details

Blank Space (Here there isn´t text)

So I put after the change:

=Match(Account_Desc,'Sales','Details','Total of values','Revenue').

But Still not working.

What do I doing wrong?

Thanks!

Re: Question about function Match

MK_QSL — Wed, 20 Nov 2013 13:34:20 GMT

if you have used

=If(Account_Desc='','Total of values', Account_Desc)

in the same script and same table... you can't use

=Match(Account_Desc,'Sales','Details','Total of values','Revenue') under same table script.

Load First the main table, name it TEMP and use first if.

Now load the same table using Resident load and define the second expression.

Now drop TEMP Table

This should work....

Re: Question about function Match

datanibbler — Wed, 20 Nov 2013 13:36:43 GMT

Hi Pablo,

try actually typing the BLANK into your function:

>>> IF(Account_Desc = ' ', 'Total of values', Account_Desc) <<<

I'm not quite sure of this, blank values are always problematic. You could also try

>>> IF(ISNULL(Account_Desc) ... ) <<<

In some cases, I even had to type the actual result of the ISNULL() function:

>>> IF(ISNULL(Account_Desc) = -1, ... ) <<<

HTH

Best regards,

DataNibbler

Re: Question about function Match

pgalvezt — Wed, 20 Nov 2013 17:06:13 GMT

Hi Manish,

Works, but dont respect the order

I want =Match(Account_Desc,'Sales','Details','Total of values','Revenue')

But QlikView gives:

=Match(Account_Desc,'Total of values','Revenue','Details','Sales')

Re: Question about function Match

pgalvezt — Wed, 20 Nov 2013 17:49:11 GMT

Finally I have to put another type of sorting and works!. Many Thanks Both of you.