Nested aggregation

[PrashantRupani]

I am new to Qlik Sense. Trying to figure out nested aggregations . 

I need to create a table with two columns : Order Status , Order Count

I have an expression - if ( $(var_name) >0,1,0) . I need to sum all 1's .

I am trying to do sum(if ( $(var_name) >0,1,0) ) . It says nested aggregation not allowed . var_name is a variable expression - sum({<Datetype={'OrderDT'}>}Order_Count)

How should I resolve this?

TIA

[Vegar · Accepted solution]

Try to aggregate it on your desired dimension, like this.

sum(if (aggr(sum({<Datetype={'OrderDT'}>}Order_Count),Order_Status) >0,1,0))

[PrashantRupani]

Thanks for your reply. Sorry I was out of town so replying to your message so late

Your solution helps. Thanks.