topic Re: Convert If expression to Qlick view expression in Management & Governance

Convert If expression to Qlick view expression

chetanpatel — Fri, 26 Aug 2022 06:48:13 GMT

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)

Re: Convert If expression to Qlick view expression

Anders_Eriksson — Fri, 26 Aug 2022 06:55:45 GMT

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)

Re: Convert If expression to Qlick view expression

Anders_Eriksson — Fri, 26 Aug 2022 06:56:47 GMT

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

Re: Convert If expression to Qlick view expression

chetanpatel — Wed, 31 Aug 2022 18:26:50 GMT

Thank you.

Re: Convert If expression to Qlick view expression

chetanpatel — Tue, 06 Sep 2022 00:04:04 GMT

Thank you

Re: Convert If expression to Qlick view expression

chetanpatel — Thu, 22 Sep 2022 01:32:50 GMT

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)

Re: Convert If expression to Qlick view expression

chetanpatel — Thu, 22 Sep 2022 02:06:48 GMT

Found answer my self here is the working equation

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