Discussion Board for collaboration related to QlikView App Development.
Hi Everyone,
I would like to understand the logic behind my expression. Could you please help me to understand the logic behind calculation . Below is my expression.
count({<POrganization = {"=avg({<PDataPoint = {1210},[Answer Flag]={1}>}Score)
< floor(avg({<PDataPoint = {1210},[Answer Flag]={1}>}total Score)) and avg({<PDataPoint = {1209},[Answer Flag]={1}>}Score)
< avg({<PDataPoint = {1210},[Answer Flag]={1}>} Score)"} >}distinct POrganization)
Thanks in advance.
I would describe your expression like this:
You are calculating the Count of POrganization WHERE the average score for PDataPoint 1210 is less than the total average (rounded down to nearest integer) AND the average score for PDataPoint 1210 is larger than the average score for PDataPoint 1209.
I would describe your expression like this:
You are calculating the Count of POrganization WHERE the average score for PDataPoint 1210 is less than the total average (rounded down to nearest integer) AND the average score for PDataPoint 1210 is larger than the average score for PDataPoint 1209.