topic If else statement in direct discovery in QlikView https://community.qlik.com/t5/QlikView/If-else-statement-in-direct-discovery/m-p/644114#M678404 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>Can we apply any if else statement or case when condition inside direct query?</P><P>I realized if we apply if else statement in front end expression,we need to add dimension use in the expression.</P><P>For example <SPAN style="font-size: 10pt; line-height: 1.5em;">if(Counter='A',count(Ticket),0), </SPAN><SPAN style="font-size: 10pt; line-height: 1.5em;">in order to create a chart show no of ticket by Month, we need to add Counter in Dimension tab which is not suppose to.</SPAN></P></BODY></HTML> Fri, 23 May 2014 01:31:36 GMT 2014-05-23T01:31:36Z If else statement in direct discovery https://community.qlik.com/t5/QlikView/If-else-statement-in-direct-discovery/m-p/644114#M678404 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>Can we apply any if else statement or case when condition inside direct query?</P><P>I realized if we apply if else statement in front end expression,we need to add dimension use in the expression.</P><P>For example <SPAN style="font-size: 10pt; line-height: 1.5em;">if(Counter='A',count(Ticket),0), </SPAN><SPAN style="font-size: 10pt; line-height: 1.5em;">in order to create a chart show no of ticket by Month, we need to add Counter in Dimension tab which is not suppose to.</SPAN></P></BODY></HTML> Fri, 23 May 2014 01:31:36 GMT https://community.qlik.com/t5/QlikView/If-else-statement-in-direct-discovery/m-p/644114#M678404 2014-05-23T01:31:36Z