Discussion board where members can get started with Qlik Sense.
how to group the entries that contain a number?
I want to group all the items (a51351, f50092, e50050, a51047) in a single voice.
THE END RESULT SHOULD BE A TREE MAP WITH THE VOICES
ORDER which includes A51351, F50092, E50050, A51047
Try this as calculated dimension: If(len(KeepChar(VOICE, '0123456789')), 'ORDER', VOICE)