Discussion board where members can get started with Qlik Sense.
Can you do something in Qlik via a function/expression to determine if a character in a field is either a text or a number.
I have some postcode data like
I want to be able to say if the first character is a letter and the second is a number then do something. If the first character is a letter and the second character is also a letter then do something else..
Is there a function to do this by any chance?
we use applymap to do that and precalculate in the script.
It takes seconds to implement with excel
MAPPING LOAD * INLINE [
if(applymap('M',fieldname) = 1, 'Do sth', 'Do sth else')