topic If Statement in QlikView

If Statement

niharika1234 — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I am having trouble in finding Correct If else statements. My Logic is if M-TYPE is R or RE and M Status is populated then that column will be Closed Else Open . That means If M-Status has no value or Null the field should be Open. I have tried following script but looks like some error. Please suggest.

if (M_Type = 'R') OR IF (MOR_Type = 'RE')and Len(M_STATUS)>0, ' Closed' Else 'Open',

Re: If Statement

sunny_talwar — Thu, 01 Nov 2018 17:27:36 GMT

Try this

If(Match(M_Type, 'R', 'RE') and Len(Trim(M_STATUS)) > 0, 'Closed', 'Open')

Re: If Statement

niharika1234 — Thu, 01 Nov 2018 17:40:31 GMT

Thanks a lot Sunny.

Re: If Statement

niharika1234 — Thu, 01 Nov 2018 19:48:18 GMT

Hello Sunny,

I tried your suggestion and part of results are incorrect . I believe the column has many - - and that is causing Problem. The Logic is when when Incident type is R or RE and Mor-Category is populated, KPI should be closed. All other are Open.

If(Match(M_Type, 'R', 'RE') and Len(Trim(M_STATUS)) > 0, 'Closed', 'Open')

Thanks,

Niha

Re: If Statement

niharika1234 — Thu, 01 Nov 2018 20:03:35 GMT

Hello Sunny,

I tried your suggestion but Part of answer is incorrect. I

believe there are lot of _ that' s why it is . Logic is MOR_CATEGORY is Populated and Incident Type is R or RE , Closed and all other are Open. Please suggest.

Thanks,

Niha

Re: If Statement

sunny_talwar — Fri, 02 Nov 2018 00:20:12 GMT

Your field is not called M_STATUS and M_Type? May be use the correct fields...

If(Match([Incident Type], 'R', 'RE') and Len(Trim(MOR_CATEGORY)) > 0, 'Closed', 'Open')

or may be this

If(Match(Trim([Incident Type]), 'R', 'RE') and Len(Trim(MOR_CATEGORY)) > 0, 'Closed', 'Open')