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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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