Combining more then one calculated field into single field

[sakshikaul]

Hi,

I have a data source as a excel files. I have to apply same conditions as applied in excel into Qlikview.

so Following are conditions given in excel format:-

1. excel-

=IF(AF2<=0,'Exclude','check'')

Qlikview script for above excel condition will be as follows:-

if ([cost excl tax]<=0,'excluded',' check') as debit_note;

similarly I have few more conditions in excel which I have  written in qlikview

2.Excel-

if(and(e22<>1,a22<=1000,"exclude","check")

Qlikview:-

if(damage_tag<>1 and ([cost excl tax]/quantity<=1000   ,'Exclude','check)  as [exclude from pack]

3.Excel- IfError(vlookup(v22,master!A:C,3,0),"check")

qlikview- applymap('claim,claimtype,'check') as excluded_claim_type

Please check the last point(3rd point) can I write the expression in qlikview as it is written ?

[sakshikaul]

and also want to combine all the three points and create a new field.

[anushree1]

Hi Sakshi,

The code snippet put by you should be fine on qlik

[sakshikaul]

Thanks. 

Also, I want to combine all the the below conditions and create a single field 

1. if( [Cost  excl. Tax]<=0,'Excluded','Check') as [Debit note/cancelled claim ( - cost values)],
2. if( [Damage Tag]<>1 and ([Cost  excl. Tax]/Quantity<=1000),'Excluded','check')as [Consequential parts:Per part cost<=1000 status],
 3. ApplyMap('Claim_Type',"Claim type [PAR]",'check') as [Excluded Claim type],
  4.   if([Damage Tag]<>1,ApplyMap('Part_Number',Material,'check')) as [Consequental parts]

How to combine above conditions?

[anushree1]

Well to combine multiple if statements you can use a nested if..

I find that all your if conditions are aliased into different fields so I do not understand the concept of having a single field 

[johnpaul]

It can be quite complex to nest too many if's into one and it's easy to mess it up. 

Have a look at: 

http://www.qlikblog.at/tools/Nested-If-Generator.html

[sakshikaul]

Hi,

I just have doubt in the below condition.

I have condition given to me in excel iferror(vlookup(v22,master!A:C,3,0),"check') so how to write this condition in qlikview syntax?

[sakshikaul]

Th main purpose to combine all if statements is that after I will combine all if statement that field is to be shown in UI design ie after the user will select the final status field he will be able to get filtered data