Condition

[narender123]

Hi All,

I have two column

1)Status

2) Paid_Status

i want

If(Status=1,'Approved',

if(Status=2,'Pending',

if(Status=3,'Completed',

if(Status=4,'Paid',

if(Status=1 and Paid_Status=6,'OutStanding'))))) as newstatus,

Result in filter is showing like

Approved

Pending

Completed

Paid

but not shows Outstanding

Why??

I have shown the table box with Status and Paid_Status dimention  in attachment.

Thanks

[narender123]

Hi Vishwaranjan.

thanks for reply.

But i want where

Status=1 and Paid_Status=6, then outstanding

[CELAMBARASAN]

Hi,

I think in your image it Paid_Status is paid_status. I pointing out because qlikview is case sensitive can you confirm that?. Other than that I hope expression is fine.

Regards,

Celambarasan

[narender123]

Hi Mohit,

You mean to say at status 1 we have to require two paid status.

But as i shown in attachment there is 2 condition in table box

1)status 1 with paid status 6

2)status 1 with -

it means different condition already??

Thanks

[narender123]

Thanks Celambarasan.

i know i have written it Paid_Status by mistake.

But the problem is not that.

[narender123]

Hello Mohit,

As you have shown

status  paid status

1          6

1         45

It is not showing OutStanding.

Same case is here

What i have to do in such condition????

[narender123]

Actually paid status'-' is showing in table box with status ,but in actual paid status didnt have '-'.

paid status have only 0,2,5,6

[narender123]

Please see my attachment.

The condition is same as i said.

[jonathandienst · Accepted solution]

Hi

You just have to evaluate the more specific condition first:

if(Status=1 and Paid_Status=6,'OutStanding',

if(Status=1,'Approved',

if(Status=2,'Pending',

if(Status=3,'Completed',

if(Status=4,'Paid',

))))) as newstatus,

Regards

Jonathan

[er_mohit]

i can't open your file

as im using personal edition i change my paid status to null

then see the code

A:

LOAD

If(Status=1 and Paid_status='','Approved',

if(Status=2,'Pending',

if(Status=3,'Completed',

if(Status=4,'Paid',if(Status=1 and Paid_status=6,'OutStanding'))))) as newstatus

, * Inline [

Paid_status,Status

6,1

12,2

3,3

4,4

,1

];