Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

edugallowk
New 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,

 

🙂

1 Solution

Accepted Solutions
Gabriel_Santos
New Contributor

Re: Count IF Division and Aggregate

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

Re: Count IF Division and Aggregate

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