topic How to Add if condition for Firstsorted value count. in QlikView

How to Add if condition for Firstsorted value count.

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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 .

sunny_talwar — Wed, 24 Jan 2018 18:43:27 GMT

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))

vishsaggi — Wed, 24 Jan 2018 18:47:01 GMT

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))

Change accordingly.

Anonymous — Thu, 25 Jan 2018 06:27:51 GMT

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.

raman_rastogi — Fri, 02 Feb 2018 13:18:33 GMT

may be like this

=Aggr( if(M_NO=FirstsortedValue(M_NO),-avg(T_Time),Count(B_ID)),M_NO,P_ID)

vishsaggi — Fri, 02 Feb 2018 13:48:09 GMT

can you share a sample to look into? And your expected output.

Anonymous — Sat, 03 Feb 2018 04:43:30 GMT

we tried above expression. we are not getting the output