Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

problem with aggr function (sum(aggr(count)

Hello all!



Help me please with problem.



I use this formula for get total info in first row. Total data is first row of table is correct




     count({&lt;order={0}, =&gt;} distinct  + order)</div>       <span style="font-size: 8pt;">+count({&lt;order -= {'0'}, =&gt;} distinct + order])












But if I want to use aggr formula, there is problem with figure.













     sum(aggr(count({&lt;order={0}, =&gt;} distinct  + order)</div> <div> <div> </div> </div> <div>      <span style="font-size: 8pt;">+count({&lt;order -= {'0'}, =&gt;} distinct + order]), Date, ))*


*


<span style="color: #00b400; font-size: 8pt;"><strong><span style="color: #00b400; font-size: 8pt;"> </span>






























































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































Attached please find word document with 2 pictures with 2 these case.



Thanks a lot for you help

Labels (1)
0 Replies