topic Script in QlikView https://community.qlik.com/t5/QlikView/Script/m-p/1265267#M398626 <HTML><HEAD></HEAD><BODY><P>I have a field called [Ticket Base Price] that has various values, however, I specifically want to call out when this field has a value of 0.00.</P><P></P><P>I want to do this in my script so as to be able to use this in my application.</P><P></P><P>Currently, I tried to do this:</P><P></P><TABLE><TBODY><TR><TD>IF([Ticket Base Price]='0.00', 'COMP',)</TD><TD></TD><TD></TD><TD></TD><TD>AS</TD><TD>Grouping,</TD></TR></TBODY></TABLE><P></P><P>However this does not pull in any data.</P><P></P><P>Any suggestions on what I am doing wrong or how to better approach this?</P></BODY></HTML> Fri, 24 Feb 2017 19:25:19 GMT evansabres 2017-02-24T19:25:19Z Script https://community.qlik.com/t5/QlikView/Script/m-p/1265267#M398626 <HTML><HEAD></HEAD><BODY><P>I have a field called [Ticket Base Price] that has various values, however, I specifically want to call out when this field has a value of 0.00.</P><P></P><P>I want to do this in my script so as to be able to use this in my application.</P><P></P><P>Currently, I tried to do this:</P><P></P><TABLE><TBODY><TR><TD>IF([Ticket Base Price]='0.00', 'COMP',)</TD><TD></TD><TD></TD><TD></TD><TD>AS</TD><TD>Grouping,</TD></TR></TBODY></TABLE><P></P><P>However this does not pull in any data.</P><P></P><P>Any suggestions on what I am doing wrong or how to better approach this?</P></BODY></HTML> Fri, 24 Feb 2017 19:25:19 GMT https://community.qlik.com/t5/QlikView/Script/m-p/1265267#M398626 evansabres 2017-02-24T19:25:19Z Re: Script https://community.qlik.com/t5/QlikView/Script/m-p/1265268#M398627 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try below expression. Remove the Comma after the string.</P><P>If([Ticket Base Price]='0.00','COMP') as Grouping</P></BODY></HTML> Fri, 24 Feb 2017 19:28:24 GMT https://community.qlik.com/t5/QlikView/Script/m-p/1265268#M398627 krishnacbe 2017-02-24T19:28:24Z Re: Script https://community.qlik.com/t5/QlikView/Script/m-p/1265269#M398628 <HTML><HEAD></HEAD><BODY><P>This returns no value. The structure allows me to reload the data, however when I look at the table preview, there is no value.</P></BODY></HTML> Fri, 24 Feb 2017 19:31:48 GMT https://community.qlik.com/t5/QlikView/Script/m-p/1265269#M398628 evansabres 2017-02-24T19:31:48Z Re: Script https://community.qlik.com/t5/QlikView/Script/m-p/1265270#M398629 <HTML><HEAD></HEAD><BODY><P>I made a small error when I entered your suggestion. You were correct, thank you.</P></BODY></HTML> Fri, 24 Feb 2017 19:33:36 GMT https://community.qlik.com/t5/QlikView/Script/m-p/1265270#M398629 evansabres 2017-02-24T19:33:36Z