5 Replies Latest reply: Dec 12, 2013 10:57 AM by Felipe Carrera RSS

    word cloud list word limit

    Felipe Carrera

      wordcloud.png

      hi

      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
          Martin Mahler

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

            • Re: word cloud list word limit
              Felipe Carrera

              you mean the Javascript code? i cannot write JavaScript code

                • Re: word cloud list word limit
                  Neil Gulliver

                  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
                      Felipe Carrera

                      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