Forum Discussion

Bakhtawar's avatar
Bakhtawar
Icon for Post Patron rankPost 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
Icon for Post Patron rankPost Patron
6 years ago

these 2 should be one measure .. i dont want to seprate

 

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

 

and what is this ?

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

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

amitchandak 

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
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))