Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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