topic Re: Issue with if Match function in Straight Table Dimension in QlikView

Issue with if Match function in Straight Table Dimension

AC — Wed, 22 Aug 2018 15:53:12 GMT

Hello,

I have an Issue with the If Match function, I have a field called Last_Ping_Status and the values are 1 DAY, 2 DAYS, 3 DAYS.....60 DAYS, OVER 60 DAYS and UNKNOWN from this I was trying to display first 7 DAYS (1 DAY, 2 DAYS...7 DAYS) and for that I am using below expression in my Straight Table dimension.

=if(match(Last_Ping_Status,'1 DAY','2 DAYS','3 DAYS','4 DAYS','5 DAYS','6 DAYS','7 DAYS'),Last_Ping_Status)

The above expression is not giving any error but I am not getting anything in the table see below.

I have tried with some sample data in another test qvw but the same if match condition is working there not sure why it is not working in my actual qvw and i have tried with wildmatch as well.

Re: Issue with if Match function in Straight Table Dimension

wdchristensen — Wed, 22 Aug 2018 18:59:47 GMT

Perhaps the values of "Last_Ping_Status" are not exactly the same as your match condition. The case could be off or leading or trailing spaces. Might try:

if(match(TRIM(UPPER(Last_Ping_Status)),'1 DAY','2 DAYS','3 DAYS','4 DAYS','5 DAYS','6 DAYS','7 DAYS'),Last_Ping_Status)

If the above upper and trim didn't fix the issue, might try the below and examine the output.

if(match(TRIM(UPPER(Last_Ping_Status)),'1 DAY','2 DAYS','3 DAYS','4 DAYS','5 DAYS','6 DAYS','7 DAYS'),Last_Ping_Status, '-' & Last_Ping_Status '-' & ' This should not include values between 1 and 7 days.')

Can you please post your load script? I have the free version of QlikView and can't open the QVF since I am not the creator.

Re: Issue with if Match function in Straight Table Dimension

AC — Wed, 22 Aug 2018 19:37:58 GMT

Thank you William, this is working perfectly but why the same working in my sample file with simple if match, in the sample file also i have different values

Re: Issue with if Match function in Straight Table Dimension

wdchristensen — Wed, 22 Aug 2018 19:39:33 GMT

Glad you got it working!