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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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 II
Specialist II

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 II
Specialist II

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