Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
edugallowk
Contributor III
Contributor III

Count IF Division and Aggregate

Hello my friends!

I'm having difficulty constructing an expression, can you help me build it, both in the convetional method and in the set analysis?

I mounted the dimension this way and it worked:

DIM:

 

aggr(if(round(count(if(Events=1 or Events=11, Events))
/ 
count(distinct Date)) >=1,'Hiperconsultador',Null()), username)

 

I need to count the total number of users where the total of events dividing by total dates is equal to or greater than 1.

I thank the attention,

 

🙂

Labels (4)
1 Solution

Accepted Solutions
Gabriel_Santos
Contributor
Contributor

num(
count(distinct if(aggr(
	(count(if([Events]=1 or [Events]=11, [Cod_Events]))
    /
    count(distinct [Date])) > 1
, username), username))
,'###.###')

View solution in original post

1 Reply
Gabriel_Santos
Contributor
Contributor

num(
count(distinct if(aggr(
	(count(if([Events]=1 or [Events]=11, [Cod_Events]))
    /
    count(distinct [Date])) > 1
, username), username))
,'###.###')

View solution in original post