topic Re: Pivot Table in QlikView https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/701063#M1066226 <HTML><HEAD></HEAD><BODY><P>Maybe if([PTL Start Date]=makedate(Year,Month,Day),1,if([PTL End Date]=makedate(Year,Month,Day),2))</P></BODY></HTML> Wed, 03 Sep 2014 13:45:11 GMT Gysbert_Wassenaar 2014-09-03T13:45:11Z Pivot Table https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/701062#M1066225 <HTML><HEAD></HEAD><BODY><P>hi guys,</P><P></P><P></P><P>need help</P><P>how can i fill up the text boxes with '1'</P><P>the expression is used is simple; if(current date= Start Date, 1 , if current date= End Date,2)</P><P></P><P><IMG alt="Gantt.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/65819_Gantt.png" style="width: 620px; height: 136px;" /></P><P> Regards</P></BODY></HTML> Wed, 03 Sep 2014 13:21:52 GMT https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/701062#M1066225 2014-09-03T13:21:52Z Re: Pivot Table https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/701063#M1066226 <HTML><HEAD></HEAD><BODY><P>Maybe if([PTL Start Date]=makedate(Year,Month,Day),1,if([PTL End Date]=makedate(Year,Month,Day),2))</P></BODY></HTML> Wed, 03 Sep 2014 13:45:11 GMT https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/701063#M1066226 Gysbert_Wassenaar 2014-09-03T13:45:11Z