topic Count Field in QlikView

Count Field

upaliwije — Tue, 06 Jun 2017 04:12:06 GMT

Hi Friends

I have attached my QV document with some claim data. My pivot table looks as follows

I want to add another coloum to this with Nos. That if int_month=Prv_mon I want add 1 my output table should look like below.pls help me to, accomplish this task

Re: Count Field

tresB — Tue, 06 Jun 2017 04:32:33 GMT

PFA

Re: Count Field

upaliwije — Tue, 06 Jun 2017 04:41:28 GMT

Thanks for your reply, But here the total does not display for Nos

Re: Count Field

Anil_Babu_Samineni — Tue, 06 Jun 2017 04:43:48 GMT

May be this for Nos

If(SUM(PROVISION)>0 and PRV_MON = INT_MON,1,'No Records Matching')

Re: Count Field

Anil_Babu_Samineni — Tue, 06 Jun 2017 04:50:01 GMT

This?

Sum(Aggr(If(SUM(PROVISION)>0 and PRV_MON = INT_MON,1), CLAIM_NO, INT_MON, PRV_MON))

Re: Count Field

tresB — Tue, 06 Jun 2017 04:53:32 GMT

Just put sum() around the expression like:

Sum(If( PRV_MON=INT_MON,1))