Discussion Board for collaboration on QlikView Scripting.
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:
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,
Go to Solution.
(count(if([Events]=1 or [Events]=11, [Cod_Events]))
count(distinct [Date])) > 1
, username), username))