Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
NickBentley
Contributor III
Contributor III

Calculated Dimension

I am trying to make a calculated dimension from my 'Customer' dimension which only displays the customers that have the contain the word 'value' in their title. 

I have tried the expression below, but this in just giving me a 1 / 0 result (which I am assuming is yes / no) but would like the list of the 25 or so customers that I know have 'value in their name. 

=Wildmatch(Customer,'value*')

Thanks. 

 

1 Solution

Accepted Solutions
Vikash
Contributor III
Contributor III

Hi Nick,

Please try the below expression as your calculated dimension-

=If(Wildmatch(Customer,'value*'), Customer)

Regards,

VK

View solution in original post

2 Replies
Vikash
Contributor III
Contributor III

Hi Nick,

Please try the below expression as your calculated dimension-

=If(Wildmatch(Customer,'value*'), Customer)

Regards,

VK

NickBentley
Contributor III
Contributor III
Author

Thanks for the reply VK. 

 

Worked a treat! 

 

Cheers,

 

Nick