Inforce count - Insuaranc

[Anonymous]

Hello,

I am trying to calculate the inforce count using the link -  https://community.qlik.com/message/497885#497885

And I am unable to work out the set expression for LIVE, and DROPPED.

Dimensions: CalendatMonthAndYear

Expressions:

Started =count({<DateType={'Start'}>} distinct Policy)

Expired/Cancelled =count({<DateType={'End'}>} Policy)

Live =rangesum(Above(Live),Started)   -  This gives me Badfield name - Live,Started.

Dropped =rangesum(Above(Dropped),[Expired/Cancelled])

InForce =Live-Dropped

Errors:

Live =rangesum(Above(Live),Started)  

The above expression gives an error as  Badfield name - Live,Started.

similarly

Dropped =rangesum(Above(Dropped),[Expired/Cancelled])

The above expression gives an error as  badfield name - Dropped,[Expired/Cancelled].

[Anonymous]

so what is the way to work around?

could you give me a detailed explanation

[dwforest]

Instead of referencing Live in Live, you need to based it on the field that has your data.

To get more help, you'd have to post sample data and expected outcome.