topic IF Statement in QlikView https://community.qlik.com/t5/QlikView/IF-Statement/m-p/224316#M76740 <HTML><HEAD></HEAD><BODY><P></P><P style="font-weight: bold"></P><P style="font-weight: bold">Would anyone be able to shed some light on the following expression. Its giving me a blank field on my Pivot Table. Is it a syntax error or something?</P><B></B><P style="font-weight: bold">if</P>(<B></B><P style="font-weight: bold"></P>( <P>(</P><P>Many thanks</P>Patient Id = '1000402' and Date = '09-11-2010' , sum(ReportingFee) = '15.00', sum(ReportingFee))<BR /><BR /> <BR /><BR /></BODY></HTML> Wed, 15 Dec 2010 16:51:55 GMT 2010-12-15T16:51:55Z IF Statement https://community.qlik.com/t5/QlikView/IF-Statement/m-p/224316#M76740 <HTML><HEAD></HEAD><BODY><P></P><P style="font-weight: bold"></P><P style="font-weight: bold">Would anyone be able to shed some light on the following expression. Its giving me a blank field on my Pivot Table. Is it a syntax error or something?</P><B></B><P style="font-weight: bold">if</P>(<B></B><P style="font-weight: bold"></P>( <P>(</P><P>Many thanks</P>Patient Id = '1000402' and Date = '09-11-2010' , sum(ReportingFee) = '15.00', sum(ReportingFee))<BR /><BR /> <BR /><BR /></BODY></HTML> Wed, 15 Dec 2010 16:51:55 GMT https://community.qlik.com/t5/QlikView/IF-Statement/m-p/224316#M76740 2010-12-15T16:51:55Z IF Statement https://community.qlik.com/t5/QlikView/IF-Statement/m-p/224317#M76741 <HTML><HEAD></HEAD><BODY><P>Please try this:</P><P></P><P>if([Patient Id] = '1000402' and Date = '09-11-2010' , '15.00', sum(ReportingFee))</P><P></P><P></P></BODY></HTML> Wed, 15 Dec 2010 17:00:29 GMT https://community.qlik.com/t5/QlikView/IF-Statement/m-p/224317#M76741 boorgura 2010-12-15T17:00:29Z IF Statement https://community.qlik.com/t5/QlikView/IF-Statement/m-p/224318#M76742 <HTML><HEAD></HEAD><BODY><P>works fine now, thanks for that!</P></BODY></HTML> Wed, 15 Dec 2010 17:10:05 GMT https://community.qlik.com/t5/QlikView/IF-Statement/m-p/224318#M76742 2010-12-15T17:10:05Z