Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
YG
Contributor III
Contributor III

Qlik Sense rename with IF works for some but not others?

Hi All,

 

I am having a dilemma with renaming with IF condition and when I use with some operators (wildmatch)  with many IF conditions it works but couple of conditions it doesn't. 

 

Below Yellow highlighted names I want to change it to just "Failed" and "Success"

YG_0-1677735846223.png

This is what I tried so far,

YG_1-1677735912257.png

=if(wildmatch(event_type, 'AddPasswordSuccess'), 'Success',
     if(wildmatch(event_type, 'AddPasswordFailed'),'Failed'))

= if (event_type='AddPasswordSuccess', 'Success',
      if(event_type='AddPasswordFailed', 'Failed'))

NON of the above works,  BUT below is working for another Dimension

=if(wildmatch(channel_function,'reg-pin*'),'reg-pin',
if(wildmatch(channel_function,'reg-pwd*'),'reg-pwd'))

I dont understand how this Dimensions are similar but one works but the other. Anyone who can help would be really appreciated. Thanks in advance 

 

 

Labels (4)
11 Replies
henrikalmen
Specialist
Specialist

Look at your replace-statement again in the expression. You have not written it correctly.

YG
Contributor III
Contributor III
Author

I have no Idea Why but Used the same expression before,

 

=if (event_type=('AddPasswordSuccess'), 'Success',
if(event_type=('AddPasswordFailed'), 'Failed'))

 

But wanted the fields displayed to the "Right" and it is working, But don't understand why not in bottom

 

YG_0-1678062414633.png