Discussion board where members can get started with QlikView.
Ex : if(M_NO=FirstsortedValue(M_NO),-Aggr(avg(T_Time),M_NO,P_ID),Count(B_ID))
In an table we are calculated the min of avg against the M_NO and P_ID.
i tried by above expression by count against the M_NO and Min of avg .
May be this
Sum(Aggr(If(M_NO = FirstsortedValue(TOTAL <B_ID> M_NO, -Aggr(Avg(T_Time), M_NO, P_ID), 1, 0), M_NO, B_ID))
Are you getting an error like nested aggr not allowed. May be try like
= Count(Aggr( if(M_NO=FirstsortedValue(M_NO, -Aggr(avg(T_Time),M_NO,P_ID), B_ID), M_NO))
We are not getting the count for above expression.
Dimension is P_ID.
We want Count of b_id against the min of avg of M_ID,P_ID.
may be like this
can you share a sample to look into? And your expected output.
we tried above expression. we are not getting the output