topic word cloud list word limit in QlikView

word cloud list word limit

felcar2013 — Mon, 26 Jan 2026 16:26:21 GMT

how can i Limit the number of words based on the frequency. The " words" field on properties shows the field with the words to be displayed in the Chart. i want to Limit it to the 100 more frequent words per filter set. It shall always be set at a max of 100 more frequent words, independently from the filters set

i tried using a variable in the words field but it did not work

thanks

felipe

Re: word cloud list word limit

simondachstr — Wed, 11 Dec 2013 20:14:33 GMT

Modify the extension object, that would be the best way to do this.

Re: word cloud list word limit

felcar2013 — Thu, 12 Dec 2013 08:18:31 GMT

you mean the Javascript code? i cannot write JavaScript code

Re: word cloud list word limit

ngulliver — Thu, 12 Dec 2013 10:06:57 GMT

I haven't found a way of doing this. However, by excluding a list of common words from the data, (you can find websites listing the most common words) usually the wordle drops below 100.

Regards,

Neil

Re: Re: word cloud list word limit

felcar2013 — Thu, 12 Dec 2013 10:53:11 GMT

i did this.

A subtable from a main customer table

//get customer and Rating data from loaded table

negativerating_tmp:

LOAD *, PurgeChar(negativeratingword_tmp,'!°^''..."§$%&/()=?#*,.-_<>´~`+:;1234567890€') as negativeratingword;

LOAD %contact__ID, if(len(negativerating)>3,SubField(lower(negativerating),' ')) as negativeratingword_tmp

Resident con_tmp where LEFT(%contact__ID,1)='a' and len(negativerating)>0 and country <> 'CN';

drop Field negativeratingword_tmp;

// i exported the list of words (more than 90,000 and will grow), and indexed words which are positive or negative. This is my comparison list, which i then load as excel

outer join(negativerating_tmp) negativerating_xls:

LOAD distinct *;

LOAD *, AutoNumber(negativeratingword) as %negativeratingword__ID;

LOAD PurgeChar(negativeratingword,'!°^''..."§$%&/()=?#*,.-_<>´~`+:;1234567890€') as negativeratingword

FROM [..\Data\FlatFile\NegativeTagCloud.xlsx] (ooxml, embedded labels, table is NegativeWord);

// i could not index the words in the first table, so that i can join a numeric. i join with text (the word).

// finally i concatenate the tables and exclude the words that i do not need

NoConcatenate negativerating:

load * resident negativerating_tmp where IsNull(%negativeratingword__ID) and Not IsNull(negativeratingword);

drop Table negativerating_tmp;

the field i am using in the Extension ist the negativeratingword. When getting the frequency words, i get aprox 11,200 different words (not necessarily different in meaning). i want to " dynamically" use the words. this is, i Need to Display in the Extension always 200 or less words, based on selected filter. according to the Extension from Brian Munz, the max data set in the Dimension are 700 words, i have more than that but i Need a dynamic filter. i try with a variable but it did not work how can i always Display 200 words or less, regardless the filter? thanks

Re: word cloud list word limit

felcar2013 — Thu, 12 Dec 2013 15:57:54 GMT

i got the Limit, using an if condition in the measurement with rank(Count(field))

the word cloud Chart is always full