Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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