# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
cancel
Showing results for
Did you mean:
Creator II

## Expression assistance required

Hi ,

Please kindly assist me in my below expression - I need to get the % value

Dimension : variable - [\$(vDisplayedBy)],Phase_Outcome_Status, Clinical_pain

value : Phase_Outcome_Status - Phase Start , Phase End

Value : Clinical_pain - Met , Not Met

Expression used :

to get outcome -

if(Phase_Outcome_Status='Phase Start',

if(Clinical_Pain='Pain Outcomes (Met)',Sum({<Episode_Phase_seq={1}>} Measure_PCPSS_Clinician_Rated_Pain_N),Sum({<Episode_Phase_seq={1}>}Measure_PCPSS_Clinician_Rated_Pain_D)- Sum({<Episode_Phase_seq={1}>}Measure_PCPSS_Clinician_Rated_Pain_N))
,
if(Clinical_Pain='Pain Outcomes (Met)',Sum({<Episode_Phase_seq_rev={1}>} Measure_PCPSS_Clinician_Rated_Pain_N),Sum({<Episode_Phase_seq_rev={1}>}Measure_PCPSS_Clinician_Rated_Pain_D)- Sum({<Episode_Phase_seq_rev={1}>}Measure_PCPSS_Clinician_Rated_Pain_N))

)

to get the % I am struggling - divide by Total and group by Phase_Outcome_Status

if(
Phase_Outcome_Status='Phase Start',

Sum({<Episode_Phase_seq={1}>} Measure_PCPSS_Clinician_Rated_Pain_N)/Sum({<Episode_Phase_seq={1}>} Total <[\$(vDisplayedBy)]> Measure_PCPSS_Clinician_Rated_Pain_D)
,
Sum({<Episode_Phase_seq_rev={1}>} Measure_PCPSS_Clinician_Rated_Pain_N)/Sum({<Episode_Phase_seq_rev={1}>} Total <[\$(vDisplayedBy)]> Measure_PCPSS_Clinician_Rated_Pain_D)

)

0 Replies
Community Browser