Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
capriconuser
Creator
Creator

Replace names into another in qlikview script

 

Here i want to ask i have this line in qlivkiew script in that i want if there is "abc" or "def" available then i want to consider these as XYZ and if not available then want to consider as "NONE"

if(if(Filename = '1.xlsx','DR', 
 if(Filename = '2.xlsx','DR',
 if(Filename = '3.xlsx','DRD', 
 if(Filename = '4.xlsx', 'DRD',
  ApplyMap('Segm',Ext.,RGro') = 'abc' or 'def', 'XYZ','None')  as In_Flag

how i modified this line according to my requirement

how i do that

any idea about this condition ?

Labels (1)
1 Reply
sunny_talwar

May be this

If(Filename = '1.xlsx','DR',
If(Filename = '2.xlsx','DR',
If(Filename = '3.xlsx','DRD',
If(Filename = '4.xlsx', 'DRD',
If(ApplyMap('Segm',Ext.,RGro') = 'abc' or ApplyMap('Segm',Ext.,RGro') = 'def', 'XYZ', 'None') as In_Flag