Count depending on two date fields ?

[suvechha_b]

Hi All ,

Is there any way to count policy number depending on policy inception date .

My Month period is fiscal period  i.e For Month Feb , My fiscal Period is "201908" .

How can I calculate for fiscal_period "201908" the policy_number whose policy_inception_date lies for month Feb .

How can it work for all the fiscal period ?

Thanks

[miskinmaz]

From script create new field of inception_date wherein it will be similar to the format of ur fiscal period. then write the set analysis like
count({<Month=("$(=max(Month))")>}distinct policy)

[PrashantSangle]

can you explain little bit more with sample data and expected output.

[suvechha_b · Accepted solution]

The solution I found -

If  POLICY_UW_MONTH_KEY  field is linked  to every month then , I used the below script and count the flag it is giving me the policies open for that month.

LOAD
"POLICY_UW_MONTH_KEY",
"POLICY_CURRENT_INCEPTION_DATE",
"PIN_IMPORT_DATE_BEGIN",
"PIN_IMPORT_DATE_END",
1 As FlagPolicyInception
FROM 'lib://QlikData/Model_PolicyInception.qvd' (qvd) where len(POLICY_CURRENT_INCEPTION_DATE) >0

Thanks