topic Search fields, Create Flag in QlikView

Search fields, Create Flag

Anonymous — Thu, 06 Apr 2017 12:12:28 GMT

I have a list of 5 fields which contain lapse times. These are loaded as part of the load script. My report has a table which averages the lapse times as an expression. I have created an error code 999 to identify some specific issues with the lapse times fields.

What I need to do is create a table which looks at any of the lapse times fields and shows a flag to identify if any of the fields have code 999.

Can anyone help me do this?

Dimension:

CustomerRef,

JobRef

Expression:

Lapse_A

Lapse_B

Lapse_C

Lapse_D

Lapse_E

If any of the Lapse fields in my table contain '999', then flag for the customer ref

Any thoughts?

Cheers

Phil

Re: Search fields, Create Flag

m_woolf — Thu, 06 Apr 2017 12:37:30 GMT

=if(Lapse_A='999' or Lapse_B='999' or

Lapse_C='999' or Lapse_D='999' or Lapse_E='999',

1,0) as Flag,

Re: Search fields, Create Flag

Anil_Babu_Samineni — Thu, 06 Apr 2017 12:42:50 GMT

Or This?

=if(Lapse_A='999', If(Lapse_B='999', If(Lapse_C='999', If(Lapse_D='999', If(Lapse_E='999',1,0))))) as Flag,

Re: Search fields, Create Flag

el_aprendiz111 — Thu, 06 Apr 2017 12:56:39 GMT

Hi,

IF(RangeSum(Lapse_A,Lapse_B,Lapse_C,Lapse_D,Lapse_E)=999*5,1,0) AS FLAG;

Re: Search fields, Create Flag

Anonymous — Thu, 06 Apr 2017 13:09:41 GMT

Sorted. I thought there might be an easier way. Cheers Phil