Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I created an expression to calculate a score for users based on their responses to a questionnaire.
floor(100-((avg({ <[TASK NAME]= {'Questionnaire 2Year'}, [TASK - Statut]= {'*Done*'} >}[RESPONSE - Value])/4)*100))
-
floor(100-((avg({ <[TASK NAME= {'Questionnaire 1Year'}, [TASK - Statut]= {'*Done*'} >}[RESPONSE - Value])/4)*100))
Now, I'm looking to group the users into specific score ranges, such as 0-10, 10-20, and so on, up to 90-100.
My goal is to count how many patients fall into each of these score ranges.
Can anyone help me with the QlikView expression and dimensions I should use to accomplish this task effectively
Thank you for your help
Hi, not sure how it is different in QlikView, but in QlikSense this can be achieved with function class(). You can try something like this:
class(your_measure_expresion_you_wrote_above , 10)
But you'll get something like this '20<=x<30', so to look nicer, you can replace '<=x<' to '-', with something like this:
replace( class(your_measure_expresion_you_wrote_above , 10) , '<=x<', '-')
Hi ,
Thank you for your help,
I have to make this in dimention and count(users) in the expression ?
I believe yes, as in this way you'll see count(users) per each score 'bucket'.
Not working but thank you anyway @justISO