Discussion board where members can get started with Qlik Sense.
I have a dimension called "Lead Source"some examples of each are THY DAT LBC etc I have one called LBC but it also has variants LB4, LB5, LB6, LB7 all under lead sourceI want to take LBC, Lb4, Lb5, LB6, LB7 and make them all one , they could all be LBCis there a way to merge these into one? They are all under Dimension called "Lead Source"Thanks
Sounds like you need to look at wildmatch - script and chart function ‒ Qlik Sense
Maybe something this in the load script
if ( Wildmatch ( [Lead Source] , 'LB*' ) , 'LBC' , [Lead Source] )
The function is case insensitive.
Yes; it would be sthing like:
'LBC' as NewLeadSource
from source where "Lead Source" in (LBC, Lb4, Lb5, LB6, LB7 );
"Lead Source" as NewLeadSource
from source where "Lead Source"not in (LBC, Lb4, Lb5, LB6, LB7 );
or in front end; create a new master dimension like follow:
if ( Wildmatch ( upper([Lead Source]) , 'LB*' ) , 'LBC' , [Lead Source] )
That worked perfectly! Thank you.