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))

     

amitchandak's avatar
amitchandak
Super User
6 years ago

Based on what I can understand

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

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    oh, something was missing

     


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

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

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

  • Bakhtawar's avatar
    Bakhtawar
    Post 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
    Super 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))