Good morning, everyone.
I have a rather strange problem with an expression of a column I have defined. I have at my disposal a table to which I have added a dimension that is defined by this expression:
=(IF(peri = 'Occ' OR rdv = 'Sans' OR ISNULL(plage) OR plage > date
,if(date_terminee <= date_contrat,'Oui','Non')
,if(DATE(FLOOR(date_terminee)) <= DATE(FLOOR(date_rdv)),'Oui','Non')
))
The problem then occurs. When I want to filter on'No' for example. Qlik will apply all these conditions without taking into account my choice which will give me an erroneous result. I can't understand his logic.
I hope I have been clear enough because I cannot release data that is confidential. Thank you for your answer