Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

juleshartley
Valued Contributor

Count records based on count of another field

Hi All,

I have a requirement to bring back the following:

- Distinct count of client records who have had a

- Visit that was part of more than one distinct activity

- Within a preiod of time

I tried the follwing, which seemed to bring something back but when I tried to add set analysis to display data year to date, the date field was ignored (I guess due to the aggr function)...

Any help gratefully received!

Thanks

J

 

 

count

(distinct

{$
<
cRecordType={"Client"}
>
}


if
(
aggr(count(DISTINCT
visActivity),#cID )>1,
     #cID

   ,
)
)

Tags (2)
1 Solution

Accepted Solutions
juleshartley
Valued Contributor

Re: Count records based on count of another field

Think I've answered my own question - when adding the set analysis for dates I need to put it within the aggr function as well as outside...

Thanks all!

1 Reply
juleshartley
Valued Contributor

Re: Count records based on count of another field

Think I've answered my own question - when adding the set analysis for dates I need to put it within the aggr function as well as outside...

Thanks all!

Community Browser