Discussion Board for collaboration on QlikView Layout & Visualizations.
I have survey responses like expert, beginner etc.
I want to convert all the text to numbers in qlikview
i loaded the file in qlikview but i need for eg expert as 5 beginner as 1
How do i do that.
Is there any function like setting up the value for these text
Use a mapping.Data Cleansing
Create a Mapping Load
LOAD * Inline [
ApplyMap('MappingTable', Level) as Number
You could map your values like
old, dual(old, number) AS new
Then in your survey table, use something like
ApplyMap('MAP', response) AS response
I've used a dual value, so you have both text and number at hand, using num() or text().
maybe an if or a pick/wildmatch or pick/match
pick(wildmatch(yourfield, 'expert', 'beginner', '*'), 5, 1, 0) as newfield,