Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Not applicable

Counting Occurrences of a Word in a String in each Row

Hi,

I have  data Which consists the patient experiences for a Hospitals regarding particular services, The patient experiences is in the form of sentences, now I want to count the key words in  patient answers like " usually, sometimes, medium" into one category (medium), "always, high, yes" should be counted as (Strong) and "low, never, no" should be counted as (Weak).  I want this to show patient experience in a pie chart for strong, weak , medium measures.

Can anyone help me to solve this ?

  

QuestionPatient Experience
How often did patients receive help quickly from hospital staff?Patients usually received help as soon as they wanted
How often was patients pain well controlled?Pain was always well controlled
How often was patients pain well controlled?Pain was sometimes or never well controlled
How often was patients pain well controlled?Pain was usually well controlled
How often did staff explain about medicines before giving them to patients?Staff always explained
How often did staff explain about medicines before giving them to patients?Staff sometimes or never explained
How often did staff explain about medicines before giving them to patients?Staff usually explained
Were patients given information about what to do during their recovery at home?No, staff did not give patients this information
Were patients given information about what to do during their recovery at home?Yes, staff did give patients this information
How do patients rate the hospital overall?Patients who gave a rating of 6 or lower (low)
How do patients rate the hospital overall?Patients who gave a rating of 7 or 8 (medium)
How do patients rate the hospital overall?Patients who gave a rating of 9 or 10 (high)
How often was the area around patients rooms kept quiet at night?Always quiet at night
How often was the area around patients rooms kept quiet at night?Sometimes or never quiet at night
How often was the area around patients rooms kept quiet at night?Usually quiet at night
Would patients recommend the hospital to friends and family?NO, patients would not recommend the hospital (they probably would not or definitely would not recommend it)
Would patients recommend the hospital to friends and family?YES, patients would definitely recommend the hospital
Would patients recommend the hospital to friends and family?YES, patients would probably recommend the hospital

Regards,

Sharath.

Tags (1)
2 Replies
Highlighted
MVP
MVP

Re: Counting Occurrences of a Word in a String in each Row

see attachment for an idea

Highlighted
Employee
Employee

Re: Counting Occurrences of a Word in a String in each Row

How should a reply like "Sometimes or never quiet at night" be categorized, when it contains keywords from different categories?