Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

If condition in load

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

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: If condition in load

HI,

Try liek this

LOAD

*,

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

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


Regards,

Jagan.

4 Replies
MVP
MVP

Re: If condition in load

HI,

Try liek this

LOAD

*,

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

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


Regards,

Jagan.

jyothish8807
Honored Contributor II

Re: If condition in load

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

KC


Best Regards,
KC

Re: If condition in load

Hi

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,

Regards,
Prashant Sangle
sujeetsingh
Honored Contributor III

Re: If condition in load

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.

Community Browser