So, as you can see, trough low Scores there are bad Reasons, and through good Scores - good Reasons. Of course, number of Reasons a litle more, then I described, but not so much, I can describe them in Qlik's Script or Chart.
And now, I have to count theese Reasons one by one 🙉
How many "Low speeds", "Bad services", etc. through Scores from 1 till 4?
And how many good Reasons: "Great services", "Fast speeds" etc. through Scores 5?
I understand that I can restrict the chasing of Reasons by Scorse using COUNT(IF(SCORE = 5,REASON),
But I don't know, how to count Reason's value one by one?
Hope someone have any idea to make it. Please help))
You'll need to break the Reason field up into multiple reasons using SubField(). You'll also need an identifier for each row to link the "OneReason" back to the Score. Like this:
You'll need to break the Reason field up into multiple reasons using SubField(). You'll also need an identifier for each row to link the "OneReason" back to the Score. Like this:
