topic Re: Multiple IF statements expression in QlikView https://community.qlik.com/t5/QlikView/Multiple-IF-statements-expression/m-p/104612#M751528 <HTML><HEAD></HEAD><BODY><P>What if conditions and what output you are expecting in the parameters?</P></BODY></HTML> Tue, 06 Nov 2018 04:20:20 GMT Anil_Babu_Samineni 2018-11-06T04:20:20Z Multiple IF statements expression https://community.qlik.com/t5/QlikView/Multiple-IF-statements-expression/m-p/104609#M751525 <HTML><HEAD></HEAD><BODY><P>Hi guys, need some help here with if statement logics.&nbsp;&nbsp;&nbsp;&nbsp; </P><P>i have 2 date fields&nbsp;&nbsp;&nbsp;&nbsp; </P><P> 1. createdDate&nbsp;&nbsp; </P><P> 2. BookingDate&nbsp;&nbsp;&nbsp;&nbsp; </P><P></P><P>conditions&nbsp; </P><P>1. createdDate should be lesser than BookingDate </P><P>2. createdDate to BookingDate range must not be more than 1 year.&nbsp;&nbsp;&nbsp;&nbsp; </P><P></P><P>How do i achieve this? need help cause am newbie here</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Multiple-IF-statements-expression/m-p/104609#M751525 awalhashim 2020-11-25T16:16:04Z Re: Multiple IF statements expression https://community.qlik.com/t5/QlikView/Multiple-IF-statements-expression/m-p/104610#M751526 <HTML><HEAD></HEAD><BODY><P>Not sure i understand any deeper complexity but taking your post at face value</P><P>if(BookingDate-createdDate&gt;365,'More than a year','Less than a year')</P></BODY></HTML> Mon, 05 Nov 2018 20:45:10 GMT https://community.qlik.com/t5/QlikView/Multiple-IF-statements-expression/m-p/104610#M751526 dplr-rn 2018-11-05T20:45:10Z Re: Multiple IF statements expression https://community.qlik.com/t5/QlikView/Multiple-IF-statements-expression/m-p/104611#M751527 <HTML><HEAD></HEAD><BODY><P>Are you trying to achieve this in the layout or the Datamodel?</P><P></P><P>i.e. Are you trying to restrict the data in the load itself or in the chart?</P></BODY></HTML> Mon, 05 Nov 2018 22:03:47 GMT https://community.qlik.com/t5/QlikView/Multiple-IF-statements-expression/m-p/104611#M751527 Anonymous 2018-11-05T22:03:47Z Re: Multiple IF statements expression https://community.qlik.com/t5/QlikView/Multiple-IF-statements-expression/m-p/104612#M751528 <HTML><HEAD></HEAD><BODY><P>What if conditions and what output you are expecting in the parameters?</P></BODY></HTML> Tue, 06 Nov 2018 04:20:20 GMT https://community.qlik.com/t5/QlikView/Multiple-IF-statements-expression/m-p/104612#M751528 Anil_Babu_Samineni 2018-11-06T04:20:20Z