topic Re: Update new Column Based on the condtion in QlikView

Update new Column Based on the condtion

Wed, 10 Aug 2016 09:11:43 GMT

Hi All,

I have a scenario as below.

There are two column [Report Due Date] and [Revenue In Rs].

The column [revenue in Rs] to be updated the last date was 06/08/2016 (6th August) but it was not update hence i should see a message as SLA breached.Attached the sample input and output data.

Can someone pls help me with this.

Thanks

Re: Update new Column Based on the condtion

sunny_talwar — Wed, 10 Aug 2016 09:14:23 GMT

May be like this:

If(Len(Trim([Revenue In Rs])) = 0, 'SLA Breached') as [NEW COLUMN]

Re: Update new Column Based on the condtion

Wed, 10 Aug 2016 09:48:37 GMT

We have to consider the Report due date also. If the report due date was 6th Aug and the [Revenue in Rs] was not updated then a msg to appear as SLA breached.

Such as below condition

IF Systemdate>Reveneue Due Date and Revenue in Rs is null or = 0 then update as SLA BREACHED else do nothing.

Re: Update new Column Based on the condtion

sunny_talwar — Wed, 10 Aug 2016 10:16:08 GMT

May be this:

If(

(Len(Trim([Revenue In Rs])) = 0 or [Revenue In Rs] = 0)

and

Today() > [Reveneue Due Date], 'SLA Breached') as [NEW COLUMN]

Re: Update new Column Based on the condtion

Wed, 10 Aug 2016 10:30:49 GMT

Sunny it worked perfectly. Thanks again

Re: Update new Column Based on the condtion

sunny_talwar — Wed, 10 Aug 2016 10:36:56 GMT

No problem, I am glad I was able to help once again