Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
kavyadwh91
Contributor II
Contributor II

Logic behind expression

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.

Labels (1)
1 Solution

Accepted Solutions
Vegar
Partner
Partner

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. 

 

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

1 Reply
Vegar
Partner
Partner

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. 

 

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post