topic Re: If condition in load in QlikView

If condition in load

Wed, 24 Sep 2014 10:12:40 GMT

Hi freiends,

I have a table like

A B C D E

1 2 3 sales Profit

2 3 4 Commisions Loss

6 8 9 Margin Profit

Now I have to load based on coumns D and E using resedent load.

If D= sales and e= Profit then A-B as xxxx

else if D=Commission and E = Loss as YYY etc

Thanks

Pavan

Re: If condition in load

jagan — Wed, 24 Sep 2014 10:15:51 GMT

HI,

Try liek this

LOAD

If (D= 'Sales' and E= 'Profit', A - B,

If(D='Commissions' and E = 'Loss', somecalculation)) AS XXXX

Regards,

Jagan.

Re: If condition in load

jyothish8807 — Wed, 24 Sep 2014 10:18:52 GMT

Hi pavan,

In the script.

Tab1:

Load your normal data from your sheet.

Tab2:

LOAD

If (D= 'Sales' and E= 'Profit', A - B, If(D='Commissions' and E = 'Loss', somecalculation)) AS New Field

resident Tab1;

Regards

Re: If condition in load

PrashantSangle — Wed, 24 Sep 2014 10:19:21 GMT

Try like this

LOAD

If (wildmatch(D,'Sales') and wildmatch(E,'Profit'), A - B,

If(wildmatch(D,'Commissions') and if(E,'Loss'), calculation)) AS NewField

Resident TableName

Regards,

Re: If condition in load

sujeetsingh — Wed, 24 Sep 2014 10:21:06 GMT

Jagan has given you the way to do so ,

May this in detail will make you clear

Table2:

load *

,If (D= 'Sales' and E= 'Profit', A - B,

If(D='Commissions' and E = 'Loss', somecalculation)) AS XXXX

resident Table1;

drop table Table1;

Now you can use one more resident load from table 2 if you want to exclude on basis of field XXXXX.