Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

fmazzarelli
Contributor III

map tree

Hi Community,

how to group the entries that contain a number?


Immagine.png

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

ASSCLI

ASSREM

SPES16

ORDER  which includes A51351, F50092, E50050, A51047

1 Reply

Re: map tree

Try this as calculated dimension: If(len(KeepChar(VOICE, '0123456789')), 'ORDER', VOICE)


talk is cheap, supply exceeds demand
Community Browser