Multiple if statement with AND/OR

z_z — Mon, 12 Apr 2021 08:35:45 GMT

Hello ,

I try to follow the evolution of the rate of use for a product, I used this query on excel and I obtain the desired result :

=SI(OU(DATE_HEURE_DEPART>=J+1;DATE_HEURE_RETOUR<J);0;
SI(ET((DATE_HEURE_RETOUR-DATE_HEURE_DEPART)>1;DATE_HEURE_DEPART<=J;DATE_HEURE_RETOUR>=J+1);1;
SI(ET((DATE_HEURE_RETOUR - DATE_HEURE_DEPART)<=1;DATE_HEURE_DEPART>=J ;DATE_HEURE_RETOUR<J+1);(DATE_HEURE_RETOUR - DATE_HEURE_DEPART);
SI(DATE_HEURE_DEPART>=J ;1-(HEURE(DATE_HEURE_DEPART)/24);
SI(DATE_HEURE_RETOUR<J+1;DATE_HEURE_RETOUR-J;0)))))

==> the percentage of use per day, for example, if the product has been used all day = 1 otherwise 0 , if it was used a few hours during the day I calculate the percentage.

I tried this code on qlik to get the same results but I don't get what I want :

IF(([DATE_HEURE_DEPART_RENTAL]>=(J+1)) OR ([DATE_HEURE_RETOUR_RENTAL]< J), 0

,IF(([DATE_HEURE_RETOUR_RENTAL]-[DATE_HEURE_DEPART_RENTAL])>1 AND ([DATE_HEURE_DEPART_RENTAL]<=J)

AND ([DATE_HEURE_RETOUR_RENTAL]>=(J+1)), 1

,IF(([DATE_HEURE_RETOUR_RENTAL]-[DATE_HEURE_DEPART_RENTAL])<=1
and[DATE_HEURE_DEPART_RENTAL]>=tranche and [DATE_HEURE_RETOUR_RENTAL]<J+1,([DATE_HEURE_RETOUR_RENTAL]-[DATE_HEURE_DEPART_RENTAL])

,IF( [DATE_HEURE_DEPART_RENTAL]>=J,(1-(Hour([DATE_HEURE_DEPART_RENTAL]/24)))
,IF([DATE_HEURE_RETOUR_RENTAL]<(J+1),([DATE_HEURE_RETOUR_RENTAL]-J),0)

) )))

Any help please

topic Multiple if statement with AND/OR in Search the Community

Multiple if statement with AND/OR