Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Equion with avg working in text object but equation with sum not working please help me to solve error.
=AVG(if(EffectiveDate=Date(today() -1),CurrentIPLOS))
=sum({<EffectiveDate={"$Date(today() ))"} >}CurrentIPLOS)
Found answer my self here is the working equation
=count({<ReportDate ={">=$(=PatientEncounter.ForwardClinicStartDATE)"} ,ReportDate ={"<=$(=PatientEncounter.ForwardClinicEndDATE)"} >}PatientID)
Your $-expansion is missing a "(";
sum({<EffectiveDate={"$(Date(today() ))"} >}CurrentIPLOS)
Use the measures editor preview to see the expanded version of your expression.
You might also have problem with the date, often it needs to be in its text representation to work in set-analysis.
sum({<EffectiveDate={"$(Text(Date(today() )))"} >}CurrentIPLOS)
Might actually need a '=' also in the expansion;
sum({<EffectiveDate={"$(=Date(today() ))"} >}CurrentIPLOS)
Thank you.
Thank you
one more if equation where i want to convert into Qlick view equation.
*********************************************************************************
IF equation
COUNT( DISTINCT(IF(ReportDate>=PatientEncounter.ForwardClinicStartDATE AND ReportDate<= PatientEncounter.ForwardClinicEndDATE ,PatientID)))
*******************************************************
Below equation not working
COUNT({<ReportDate={"$(>PatientEncounter.ForwardClinicStartDATE"} >}PatientID)
Found answer my self here is the working equation
=count({<ReportDate ={">=$(=PatientEncounter.ForwardClinicStartDATE)"} ,ReportDate ={"<=$(=PatientEncounter.ForwardClinicEndDATE)"} >}PatientID)