Formula with Count function in Script

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

Hi,

Need urgent help here.

Hope All doing good

I am having a scenario like below by using the field OD_Details

Total_OD = count (OD transactions (OD_detail=”OD”)) +count (recovered transactions (OD_detail=”Recovered”))

Total_recovered = count (recovered transactions (OD_detail=”Recovered”))

Total non OD= Non OD transactions (OD_detail =”Not OD”)

In the OD_Details field. I am having values 'NOT OD', 'OD' and 'Recovered'

By using that values we have to create three fields Total_OD, Total_recovered and Total non OD as shown in Above

we create like below.

load link_Cust_Cont_Mort,

Count(OD_Details='OD')+count(OD_Details='Recovered') as Total_OD,

Count(OD_Details='Recovered')+count(OD_Details='NOT OD') as Total_Recovered

Resident Transaction1 Group by link_Cust_Cont_Mort;

But it is not looking fine.

How we can achieve

Thanks In Advance.

topic Formula with Count function in Script in QlikView