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

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to Splitting Data

I´m starting in QV an I´ve a problem...

In a field A I´ve n result of n test, each character represented a value of an examen (between 0 and 5) por example (5412032.....)

and I´ve a another table B

5, excellent

4, very good

3, good

....

0, .....

I need to show Test1: excellent

                        Test2: very good

                     ...........

Any idea?

Thanks


10 Replies
stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi there - I have uploaded the solution as a shared QlikView, and this can be downloaded from here:

QlikView App: Split Values from a String and ApplyMap to Results

This version is Personal Edition compatible.

Steve