topic If condition with two columns joining together in QlikView https://community.qlik.com/t5/QlikView/If-condition-with-two-columns-joining-together/m-p/743951#M471823 <HTML><HEAD></HEAD><BODY><P>Good day experts,</P><P></P><P>I have a very simple question but with Qlikview it seems not that simple. I have two columns the NPS column is aggregated and I have to calculate that on the montly basis. The problem I am facing in joining the data from two different tables. I have to make the line graph to show the development of both the question _name. for example I want to have</P><P></P><P>" if(question_name='nps' and ROUND(sum(if(NPS='Promotor',1)) / count(TOUCHPOINT)*100</P><P>- (sum(if(NPS='Detractor',1)) / count(TOUCHPOINT)*100))</P><P></P><P>The statement which starts from round gives me aggregated value which I have to use.</P><P>Similarly I want the same from other question name as well</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 365px;"><TBODY><TR><TD height="20" width="109">QUESTION_NAME</TD><TD width="64">NPS</TD></TR><TR><TD>NPS</TD><TD>Promotor</TD></TR><TR><TD>NPS</TD><TD>detractor</TD></TR><TR><TD>TNPS</TD><TD>promotor</TD></TR><TR><TD>TNPS</TD><TD>detractor</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 18 Feb 2015 09:57:19 GMT 2015-02-18T09:57:19Z If condition with two columns joining together https://community.qlik.com/t5/QlikView/If-condition-with-two-columns-joining-together/m-p/743951#M471823 <HTML><HEAD></HEAD><BODY><P>Good day experts,</P><P></P><P>I have a very simple question but with Qlikview it seems not that simple. I have two columns the NPS column is aggregated and I have to calculate that on the montly basis. The problem I am facing in joining the data from two different tables. I have to make the line graph to show the development of both the question _name. for example I want to have</P><P></P><P>" if(question_name='nps' and ROUND(sum(if(NPS='Promotor',1)) / count(TOUCHPOINT)*100</P><P>- (sum(if(NPS='Detractor',1)) / count(TOUCHPOINT)*100))</P><P></P><P>The statement which starts from round gives me aggregated value which I have to use.</P><P>Similarly I want the same from other question name as well</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 365px;"><TBODY><TR><TD height="20" width="109">QUESTION_NAME</TD><TD width="64">NPS</TD></TR><TR><TD>NPS</TD><TD>Promotor</TD></TR><TR><TD>NPS</TD><TD>detractor</TD></TR><TR><TD>TNPS</TD><TD>promotor</TD></TR><TR><TD>TNPS</TD><TD>detractor</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 18 Feb 2015 09:57:19 GMT https://community.qlik.com/t5/QlikView/If-condition-with-two-columns-joining-together/m-p/743951#M471823 2015-02-18T09:57:19Z