Forum Discussion

Bakhtawar's avatar
Bakhtawar
Post Patron
6 years ago
Solved

dax formula

I have this formula in qliksense ( RangeMax(0,RangeMin(( POLICY_END_DATE-POLICY_EFFECTIVE_DATE+ 1),(Date(vPE_Date) - POLICY_EFFECTIVE_DATE +1))) ) / (POLICY_END_DATE-POLICY_EFFECTIVE_DATE+ 1) i a...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

     One of them will give you result. That qlik funtion gives min max out of two, Tried that

     

    measure =
var _d1 =(datediff( POLICY_END_DATE,POLICY_EFFECTIVE_DATE,day)+ 1)
var _d2 = (datediff([vPE_Date].Date,POLICY_EFFECTIVE_DATE) +1)
return

divide(if(max(_d1) <max(_d2),max(_d1),max(_d2)),max(_d1))

     

    Or

    measure =
var _d1 =(datediff( POLICY_END_DATE,POLICY_EFFECTIVE_DATE,day)+ 1)
var _d2 = (datediff([vPE_Date].Date,POLICY_EFFECTIVE_DATE) +1)
return

divide(if(sum(_d1) <sum(_d2),sum(_d1),sum(_d2)),sum(_d1))

     

Bakhtawar's avatar
Bakhtawar
Post Patron
6 years ago

this part is related to earned days .. like how much days we earned .

RangeMax(0,RangeMin(( POLICY_END_DATE-POLICY_EFFECTIVE_DATE+ 1),(Date(vPE_Date) - POLICY_EFFECTIVE_DATE +1

 

and this part is realted to total days

 

POLICY_END_DATE-POLICY_EFFECTIVE_DATE+ 1

..  amitchandak