Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sakshikaul
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
sakshikaul
Creator II
Creator II
Author

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

anushree1
Specialist II
Specialist II

Hi Sakshi,

The code snippet put by you should be fine on qlik

sakshikaul
Creator II
Creator II
Author

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

johnpaul
Partner - Creator
Partner - Creator

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
Creator II
Creator II
Author

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
Creator II
Creator II
Author

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