Logic behind expression

kavyadwh91 — Mon, 29 Mar 2021 03:17:04 GMT

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.

Re: Logic behind expression

Vegar — Mon, 29 Mar 2021 04:47:22 GMT

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.

topic Re: Logic behind expression in QlikView

Logic behind expression

Re: Logic behind expression