Question about function Match

[pgalvezt]

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!

[MK_QSL · Accepted solution]

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....

[datanibbler]

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

[pgalvezt]

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')

[pgalvezt]

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