Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
YG
Contributor III
Contributor III

Qlik Sense data categorizing to wildmatch

Hi All,

Thanks for taking time to look at this issue first of all, I am using a bar chart with WildMach expression. So I created a new dimension "App Login type" and included this below expression 

 =if(wildmatch(event_type,'AccessToken*'),'Access Token',
if(wildmatch(event_type,'VerifyFaceID*'),'Face ID',
if(wildmatch(event_type,'VerifyPin*'),'App Pin',
if(wildmatch(event_type,'VerifyTouchID*'),'Touch ID', event_type))))

 

Below is what i put in and bars appeared in 3 colours are correct and working.

YG_3-1677128957104.png

 

However, I am getting all the categories that "wildmatch " collecting from instead of the categories I want it to appear, Which is, below is my categories, 

'Access Token',
'Face ID',
'App Pin',
'Touch ID', 

But below is how results are appearing, which I don't want 

YG_4-1677129025563.png

 

But I actually want is something like this below,

YG_2-1677128721799.png

 

How do I make that change is my question, Any help would be really appreciated. Thanks in advance 

Labels (4)
1 Solution

Accepted Solutions
henrikalmen
Specialist
Specialist

Remove  the part I've marked in red.

=if(wildmatch(event_type,'AccessToken*'),'Access Token',
if(wildmatch(event_type,'VerifyFaceID*'),'Face ID',
if(wildmatch(event_type,'VerifyPin*'),'App Pin',
if(wildmatch(event_type,'VerifyTouchID*'),'Touch ID', event_type))))

View solution in original post

2 Replies
henrikalmen
Specialist
Specialist

Remove  the part I've marked in red.

=if(wildmatch(event_type,'AccessToken*'),'Access Token',
if(wildmatch(event_type,'VerifyFaceID*'),'Face ID',
if(wildmatch(event_type,'VerifyPin*'),'App Pin',
if(wildmatch(event_type,'VerifyTouchID*'),'Touch ID', event_type))))

YG
Contributor III
Contributor III
Author

@henrikalmen  Thank you so much works perfect now