Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Group By

Hi all,

 

I'm trying to count the number of times a consultant (RACF) hits 20 surveys (ConExp) each month. My syntax is below. Key is a concatenate of RACF and Month.

 

QualifiedConsultant:

left join
load
Key,

 

 


if(count(ConExp)>=20, 'Qual','NotQual') as QualCon


Resident MyCustomer
group by Key
;


left join
Load

RACF,

count( distinct QualCon ) as QualVol


Resident MyCustomer

group by RACF;

 

See example below -

clipboard_image_0.png

The correct answer should be two because this consultant (RACF) has hit 20 surveys (ConExp) in both months, see below.

clipboard_image_1.png

The problem seems to be that it is counting each survey as Qualcon.

 

clipboard_image_2.png

1 Reply
Highlighted
Creator III
Creator III

Re: Group By

Looks like you need to add "where QualCon='Qual' " to your last load statement.