topic How to exclude negative date difference in App Development

How to exclude negative date difference

deeavhad — Mon, 21 Mar 2022 13:31:47 GMT

my Expression is below which is showing error

Avg({<[Docs Pending Status]-={'Declined / Rejected / Withdrawn'}>}{<[Talent Segment]-={'*Tupe*'}>}{<[Hiring Date]-={" "},[Hiring Date] - [Created_SP]={"<0"}>}
if(([Hiring Date] - [Created_SP])>90,90,[Hiring Date] - [Created_SP]))

By using this expression I want to remove negative values of [Hiring Date] - [Created_SP] these 2 dates difference

Please guidee

Re: How to exclude negative date difference

rwunderlich — Mon, 21 Mar 2022 23:39:30 GMT

You have a number of syntax problems there. I believe the correct expression would look like:

=Avg(
{<
[Docs Pending Status]-={'Declined / Rejected / Withdrawn'}
,[Talent Segment]-={"*Tupe*"}
,[Hiring Date]-={' '}
,ID={"=[Hiring Date] >= [Created_SP]"}
>}
RangeMin([Hiring Date] - [Created_SP], 90)
)

Replace "ID" with a primary identifier fieldname from your data, like EmployeeId.

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com