How to counting comments in a Colum

[mandilicious]

Hi Champs 

Still new, i would like to implement below scenario from excel to qliksense.

First i need to count customer comments and get the number of comments, then sum number of comments to get Total number of comments. Then after get the percentage by doing like this Number of Comments(1) / Total number of comments(28) to get % = 3.57.

Regards

[HeshamKhja1 · Accepted solution]

Hi @mandilicious ,

No, it should be one field. Like this:

Pick(WildMatch( "Overall Comment", '*latency*', '*Incomplete*', '*Not Delivered*', '*No Communication*', '*Price*')
, 'Latency', 'Incomplete', 'Not Received', 'Lack of communication', 'Total Price') AS CommentKeyWords

The order is important as WildMatch() is returning numbers corresponding to the order of match. if latency matches --> 1, if Not Delivered matches --> 3, etc.

Pick() takes number n and returns the n attribute. E.g. WildMatch() returns 2, Pick() returns 'Incomplete' (the second attribute).

[mandilicious]

Hi Heshamkhja,

Which chat can i use for such queries?

[HeshamKhja1]

As you are interested in the percentage of each comment category in respect to all comments, I think pie chart is best suited.

[mandilicious]

Hi Heshmkhja

What will be my dimension and Measure based on above info?

Regards

[HeshamKhja1]

Hi @mandilicious ,

Dimension: CommentKeywords (The new field)

Measure: Count(CommentKeywords)

The chart will calculate the percentages % and present it.

[Aasir]

1. Count Customer Comments:
Count(CommentField)
2. Sum of Number of Comments:
Sum(Count(CommentField))
3. Calculate the Percentage:
(Count(CommentField) / Sum(Count(CommentField))) * 100

Remember to replace CommentField with the actual field name where your customer comments are stored in your Qlik Sense data model.