https://community.qlik.com/t5/QlikView/Count-IF-Division-and-Aggregate/m-p/1585684#M596320 <P>Hello my friends!</P><P>I'm having difficulty constructing an expression, can you help me build it, both in the convetional method and in the set analysis?</P><P>I mounted the dimension this way and it worked:</P><P>DIM:</P><P>&nbsp;</P><LI-CODE lang="markup">aggr(if(round(count(if(Events=1 or Events=11, Events)) / count(distinct Date)) &gt;=1,'Hiperconsultador',Null()), username)</LI-CODE><P>&nbsp;</P><DIV class="tlid-input input"><DIV class="source-wrap"><DIV class="input-full-height-wrapper tlid-input-full-height-wrapper"><DIV class="source-input"><DIV class="source-footer-wrap source-or-target-footer"><DIV class="character-count tlid-character-count"><DIV class="cc-ctr normal"><SPAN>Now I must use the same concept, however, to calculate the number of people who fall into this criterion.</SPAN></DIV><DIV class="cc-ctr normal">&nbsp;</DIV></DIV></DIV></DIV></DIV></DIV></DIV><P>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.</P><P>I thank the attention,</P><P>&nbsp;</P><P><span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Sat, 16 Nov 2024 03:26:57 GMT edugallowk 2024-11-16T03:26:57Z https://community.qlik.com/t5/QlikView/Count-IF-Division-and-Aggregate/m-p/1585684#M596320 <P>Hello my friends!</P><P>I'm having difficulty constructing an expression, can you help me build it, both in the convetional method and in the set analysis?</P><P>I mounted the dimension this way and it worked:</P><P>DIM:</P><P>&nbsp;</P><LI-CODE lang="markup">aggr(if(round(count(if(Events=1 or Events=11, Events)) / count(distinct Date)) &gt;=1,'Hiperconsultador',Null()), username)</LI-CODE><P>&nbsp;</P><DIV class="tlid-input input"><DIV class="source-wrap"><DIV class="input-full-height-wrapper tlid-input-full-height-wrapper"><DIV class="source-input"><DIV class="source-footer-wrap source-or-target-footer"><DIV class="character-count tlid-character-count"><DIV class="cc-ctr normal"><SPAN>Now I must use the same concept, however, to calculate the number of people who fall into this criterion.</SPAN></DIV><DIV class="cc-ctr normal">&nbsp;</DIV></DIV></DIV></DIV></DIV></DIV></DIV><P>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.</P><P>I thank the attention,</P><P>&nbsp;</P><P><span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Sat, 16 Nov 2024 03:26:57 GMT https://community.qlik.com/t5/QlikView/Count-IF-Division-and-Aggregate/m-p/1585684#M596320 edugallowk 2024-11-16T03:26:57Z https://community.qlik.com/t5/QlikView/Count-IF-Division-and-Aggregate/m-p/1585756#M596323 <LI-CODE lang="markup">num( count(distinct if(aggr( (count(if([Events]=1 or [Events]=11, [Cod_Events])) / count(distinct [Date])) &gt; 1 , username), username)) ,'###.###')</LI-CODE> Tue, 28 May 2019 17:47:16 GMT https://community.qlik.com/t5/QlikView/Count-IF-Division-and-Aggregate/m-p/1585756#M596323 Gabriel_Santos 2019-05-28T17:47:16Z