Forum Discussion

Bakhtawar's avatar
Bakhtawar
Post Patron
6 years ago

variable in formula

hi all first i am going to you what i have in qliksense i create a varaible VPEDate.. in that i do this =if(GetSelectedCount(PE_DATE)>0,Date(Max(GetFieldSelections(PE_DATE))),Date(max(PE_DATE))) ...
Need Help
Show and Tell
Tutorial Requests
Icey's avatar
Icey
Community Support
6 years ago

Hi Bakhtawar ,

Please check:

v_Earn_Factor =
VAR MIN1 =
    MINX (
        'calender',
        DATEDIFF ( 'calender'[POLICY_EFFECTIVE_DATE], 'calender'[POLICY_END_DATE], DAY ) + 1
    )
VAR MIN2 =
    MINX (
        'calender',
        DATEDIFF ( 'calender'[POLICY_EFFECTIVE_DATE], [VPEDate], DAY ) + 1
    )
VAR MAX1 =
    IF ( MIN1 > MIN2, MIN1, MIN2 )
VAR MAX2 =
    IF ( MAX1 > 0, MAX1, 0 )
VAR Result =
    DIVIDE (
        MAX2,
        DATEDIFF ( 'calender'[POLICY_EFFECTIVE_DATE], 'calender'[POLICY_END_DATE], DAY ) + 1
    )
RETURN
    Result

Premium_earned = SUMX ( 'calender', GROSS_PREMIUM * [vEarnedFactor] )

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.