Convert If expression to Qlick view expression

[chetanpatel]

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)

[anderseriksson]

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)

[anderseriksson]

Might actually need a '=' also in the expansion;
sum({<EffectiveDate={"$(=Date(today() ))"} >}CurrentIPLOS)

[chetanpatel]

Thank you.

[chetanpatel]

Thank you

[chetanpatel]

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)

[chetanpatel · Accepted solution]

Found answer my self here is  the working equation

=count({<ReportDate ={">=$(=PatientEncounter.ForwardClinicStartDATE)"} ,ReportDate ={"<=$(=PatientEncounter.ForwardClinicEndDATE)"} >}PatientID)