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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources 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

0 Replies