topic Re: Condition in QlikView

Condition

narender123 — Fri, 12 Jul 2013 11:34:24 GMT

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

Re: Condition

narender123 — Fri, 12 Jul 2013 11:48:26 GMT

Hi Vishwaranjan.

thanks for reply.

But i want where

Status=1 and Paid_Status=6, then outstanding

Re: Condition

CELAMBARASAN — Fri, 12 Jul 2013 11:51:33 GMT

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

Re: Condition

narender123 — Fri, 12 Jul 2013 11:53:46 GMT

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

Re: Condition

narender123 — Fri, 12 Jul 2013 11:55:48 GMT

Thanks Celambarasan.

i know i have written it Paid_Status by mistake.

But the problem is not that.

Re: Condition

narender123 — Fri, 12 Jul 2013 12:01:02 GMT

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????

Re: Condition

narender123 — Fri, 12 Jul 2013 12:06:32 GMT

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

Re: Condition

narender123 — Fri, 12 Jul 2013 12:16:17 GMT

Please see my attachment.

The condition is same as i said.

Re: Condition

jonathandienst — Fri, 12 Jul 2013 12:18:06 GMT

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

Re: Condition

er_mohit — Fri, 12 Jul 2013 12:20:34 GMT

i can't open your file

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

then see the code

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

];

Re: Condition

narender123 — Fri, 12 Jul 2013 13:05:08 GMT

Thanks you very much but my case it not like your both diemntion .

But its really appreciated.

Through Jonathan Dienst i got my answer.

Re: Condition

narender123 — Fri, 12 Jul 2013 13:05:51 GMT

Thanks Jonathan.its working now.

Thanks to all.