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:-
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
if(damage_tag<>1 and ([cost excl tax]/quantity<=1000 ,'Exclude','check) as [exclude from pack]
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 ?
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?
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
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?
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