Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Combining more then one calculated field into single field

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 ?

7 Replies
Highlighted
Creator II
Creator II

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

Highlighted
Specialist II
Specialist II

Hi Sakshi,

The code snippet put by you should be fine on qlik

Highlighted
Creator II
Creator II

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?

Highlighted
Specialist II
Specialist II

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 

Highlighted
Partner
Partner

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

Highlighted
Creator II
Creator II

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?

 

Highlighted
Creator II
Creator II

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