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
Anonymous's avatar
Anonymous
Not applicable
6 years ago

share your dataset and expected output.

 

Thanks & regards,

Pravin

Bakhtawar's avatar
Bakhtawar
Post Patron
6 years ago

i just want to be rewrite these formulas in dax expression ..  consider xyz table for ur  own

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    I don't know much about qlik.

     

    I hope getselectecount means user selected dates in slicers.

     

    VPEDate=IF(ISFILTERED(TEST1[Date]),CALCULATE(MAX(TEST1[Date]),ALLSELECTED(TEST1[Date])),MAX(TEST1[Date])

     

    Premium_earned=sum(GROSS_PREMIUM) * [vEarnedFactor]

     

    I am not sure what your second formula is doing.

     

    Thanks & regards,
    Pravin Wattamwar
    www.linkedin.com/in/pravin-p-wattamwar

     

    • Bakhtawar's avatar
      Bakhtawar
      Post Patron
      6 years ago

      i just want to know how i recall VPEDate in formula ?