Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey guys, does anyone know how to create a chart like this in Qlikview ??
Many thanks in advance!!
gchampion wrote:
The previous version doubles words when a word appears more than one time in a sentence (line of data) because of the autojoin.
Oops! I can't believe I didn't catch that. At least SOMEONE caught it. I think the best solution is a preceding load.
Words:
LOAD *
WHERE len(trim(Word))
;
LOAD ID, mapsubstring('TextMap',subfield(capitalize(keepchar(upper(Text),'ABCDEFGHIJKLMNOPQRSTUVWXYZ ')),' ')) as Word
RESIDENT Data
;
D V wrote:
Thank you John. But I am struggling to open these files. Please can you help?
I have no idea what problem you're having, or how I can help.