Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
SudharshanK
Creator
Creator

Question regarding word cloud chart

Hi,

 

I am using qliksense saas and trying to create a word cloud chart. However, I have only detailed sentences along with the score metrics and my boss wants me to create only word cloud and not sentence cloud. Is there any smart way to extract keywords from these sentences to create word cloud chart? I have provided examples below:

1st time home buyer  and sudan was very friendly and helpful. Even when she took vacation time  she made sure her coworkers were aware of the paperwork that needed to be completed and connected me with them for any questions : 10

20 years of great personal service : 10

 

Labels (1)
  • SaaS

1 Solution

Accepted Solutions
vinieme12
Champion III
Champion III

use subfield() to split the string by each word in a new row using the space as a delimiter during data load

 

subfield('String',' ') as  Words

https://help.qlik.com/en-US/qlikview/May2023/Subsystems/Client/Content/QV_QlikView/Scripting/StringF...

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

1 Reply
vinieme12
Champion III
Champion III

use subfield() to split the string by each word in a new row using the space as a delimiter during data load

 

subfield('String',' ') as  Words

https://help.qlik.com/en-US/qlikview/May2023/Subsystems/Client/Content/QV_QlikView/Scripting/StringF...

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.