topic Re: Data Visualization in QlikView https://community.qlik.com/t5/QlikView/Data-Visualization/m-p/406515#M1158860 <HTML><HEAD></HEAD><BODY><P>The above table is my data.</P><P></P><P>I want that employee who has promotion ='f ' for year(2010,2011,2012) and that employee should also be active 'ac' in 2012 year</P></BODY></HTML> Wed, 09 Jan 2013 09:44:42 GMT 2013-01-09T09:44:42Z Data Visualization https://community.qlik.com/t5/QlikView/Data-Visualization/m-p/406513#M1158858 <HTML><HEAD></HEAD><BODY><P><STRONG>Dear QlikView Team,<BR />I want ur help<BR /><BR />i want those emp are 'ac' active for year 2012. and also have promotion 'f' for the following yrs </STRONG><STRONG>2010,2011,2012 </STRONG><STRONG><BR /><BR /><A _jive_internal="true" href="https://community.qlik.com/message/297842#297842" target="_blank">Re: Logic Problem</A> </STRONG>&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0"><TBODY><TR><TD height="17" style="border: 0px solid black;" width="64">Emp </TD><TD style="border: 0px solid black;" width="64">Name </TD><TD style="border: 0px solid black;" width="64">FinFlag</TD><TD style="border: 0px solid black;" width="64">Promotion</TD><TD style="border: 0px solid black;" width="64">Active</TD></TR><TR><TD align="right" height="17" style="border: 0px solid black;"> 1</TD><TD style="border: 0px solid black;">a</TD><TD align="right" style="border: 0px solid black;">2008</TD><TD style="border: 0px solid black;">f</TD><TD style="border: 0px solid black;">ac</TD></TR><TR><TD align="right" height="17" style="border: 0px solid black;"> 1</TD><TD style="border: 0px solid black;">a</TD><TD align="right" style="border: 0px solid black;">2009</TD><TD style="border: 0px solid black;">f</TD><TD style="border: 0px solid black;">ac</TD></TR><TR><TD align="right" height="17" style="border: 0px solid black;"> 1</TD><TD style="border: 0px solid black;">a</TD><TD align="right" style="border: 0px solid black;">2010</TD><TD style="border: 0px solid black;">f</TD><TD style="border: 0px solid black;">na</TD></TR><TR><TD align="right" height="17" style="border: 0px solid black;"> 1</TD><TD style="border: 0px solid black;">a</TD><TD align="right" style="border: 0px solid black;">2011</TD><TD style="border: 0px solid black;">f</TD><TD style="border: 0px solid black;">ac</TD></TR><TR><TD align="right" height="17" style="border: 0px solid black;"> 1</TD><TD style="border: 0px solid black;">a</TD><TD align="right" style="border: 0px solid black;">2012</TD><TD style="border: 0px solid black;">f</TD><TD style="border: 0px solid black;">ac</TD></TR><TR><TD align="right" height="17" style="border: 0px solid black;"> 2</TD><TD style="border: 0px solid black;">b</TD><TD align="right" style="border: 0px solid black;">2008</TD><TD style="border: 0px solid black;">f</TD><TD style="border: 0px solid black;">ac</TD></TR><TR><TD align="right" height="17" style="border: 0px solid black;"> 2</TD><TD style="border: 0px solid black;">b</TD><TD align="right" style="border: 0px solid black;">2009</TD><TD style="border: 0px solid black;">t</TD><TD style="border: 0px solid black;">ac</TD></TR><TR><TD align="right" height="17" style="border: 0px solid black;"> 2</TD><TD style="border: 0px solid black;">b</TD><TD align="right" style="border: 0px solid black;">2010</TD><TD style="border: 0px solid black;">t</TD><TD style="border: 0px solid black;">ac</TD></TR><TR><TD align="right" height="17" style="border: 0px solid black;"> 2</TD><TD style="border: 0px solid black;">b</TD><TD align="right" style="border: 0px solid black;">2011</TD><TD style="border: 0px solid black;">f</TD><TD style="border: 0px solid black;">ac</TD></TR><TR><TD align="right" height="17" style="border: 0px solid black;"> 2</TD><TD style="border: 0px solid black;">b</TD><TD align="right" style="border: 0px solid black;">2012</TD><TD style="border: 0px solid black;">f</TD><TD style="border: 0px solid black;">ac</TD></TR><TR><TD align="right" height="17" style="border: 0px solid black;"> 3</TD><TD style="border: 0px solid black;">c</TD><TD align="right" style="border: 0px solid black;">2008</TD><TD style="border: 0px solid black;">f</TD><TD style="border: 0px solid black;">ac</TD></TR><TR><TD align="right" height="17" style="border: 0px solid black;"> 3</TD><TD style="border: 0px solid black;">c</TD><TD align="right" style="border: 0px solid black;">2009</TD><TD style="border: 0px solid black;">t</TD><TD style="border: 0px solid black;">ac</TD></TR><TR><TD align="right" height="17" style="border: 0px solid black;"> 3</TD><TD style="border: 0px solid black;">c</TD><TD align="right" style="border: 0px solid black;">2010</TD><TD style="border: 0px solid black;">f</TD><TD style="border: 0px solid black;">ac</TD></TR><TR><TD align="right" height="17" style="border: 0px solid black;"> 3</TD><TD style="border: 0px solid black;">c</TD><TD align="right" style="border: 0px solid black;">2011</TD><TD style="border: 0px solid black;">f</TD><TD style="border: 0px solid black;">ac</TD></TR><TR><TD align="right" height="17" style="border: 0px solid black;"> 3</TD><TD style="border: 0px solid black;">c</TD><TD align="right" style="border: 0px solid black;">2012</TD><TD style="border: 0px solid black;">f</TD><TD style="border: 0px solid black;">ac</TD></TR><TR><TD align="right" height="17" style="border: 0px solid black;"> 4</TD><TD style="border: 0px solid black;">d</TD><TD align="right" style="border: 0px solid black;">2008</TD><TD style="border: 0px solid black;">f</TD><TD style="border: 0px solid black;">ac</TD></TR><TR><TD align="right" height="17" style="border: 0px solid black;"> 4</TD><TD style="border: 0px solid black;">d</TD><TD align="right" style="border: 0px solid black;">2009</TD><TD style="border: 0px solid black;">f</TD><TD style="border: 0px solid black;">ac</TD></TR><TR><TD align="right" height="17" style="border: 0px solid black;"> 4</TD><TD style="border: 0px solid black;">d</TD><TD align="right" style="border: 0px solid black;">2010</TD><TD style="border: 0px solid black;">f</TD><TD style="border: 0px solid black;">ac</TD></TR><TR><TD align="right" height="17" style="border: 0px solid black;"> 4</TD><TD style="border: 0px solid black;">d</TD><TD align="right" style="border: 0px solid black;">2011</TD><TD style="border: 0px solid black;">f</TD><TD style="border: 0px solid black;">ac</TD></TR><TR><TD align="right" height="17" style="border: 0px solid black;"> 4</TD><TD style="border: 0px solid black;">d</TD><TD align="right" style="border: 0px solid black;">2012</TD><TD style="border: 0px solid black;">f</TD><TD style="border: 0px solid black;">ac</TD></TR><TR><TD align="right" height="17" style="border: 0px solid black;"> 5</TD><TD style="border: 0px solid black;">e</TD><TD align="right" style="border: 0px solid black;">2008</TD><TD style="border: 0px solid black;">t</TD><TD style="border: 0px solid black;">na</TD></TR><TR><TD align="right" height="17" style="border: 0px solid black;"> 5</TD><TD style="border: 0px solid black;">e</TD><TD align="right" style="border: 0px solid black;">2009</TD><TD style="border: 0px solid black;">t</TD><TD style="border: 0px solid black;">na</TD></TR><TR><TD align="right" height="17" style="border: 0px solid black;"> 5</TD><TD style="border: 0px solid black;">e</TD><TD align="right" style="border: 0px solid black;">2010</TD><TD style="border: 0px solid black;">t</TD><TD style="border: 0px solid black;">ac</TD></TR><TR><TD align="right" height="17" style="border: 0px solid black;"> 5</TD><TD style="border: 0px solid black;">e</TD><TD align="right" style="border: 0px solid black;">2011</TD><TD style="border: 0px solid black;">f</TD><TD style="border: 0px solid black;">ac</TD></TR><TR><TD align="right" height="17" style="border: 0px solid black;"> 5</TD><TD style="border: 0px solid black;">e</TD><TD align="right" style="border: 0px solid black;">2012</TD><TD style="border: 0px solid black;">f</TD><TD style="border: 0px solid black;">ac</TD></TR><TR><TD align="right" height="17" style="border: 0px solid black;"> 6</TD><TD style="border: 0px solid black;">f</TD><TD align="right" style="border: 0px solid black;">2008</TD><TD style="border: 0px solid black;"><BR /></TD><TD style="border: 0px solid black;">ac</TD></TR><TR><TD align="right" height="17" style="border: 0px solid black;"> 6</TD><TD style="border: 0px solid black;">f</TD><TD align="right" style="border: 0px solid black;">2009</TD><TD style="border: 0px solid black;"><BR /></TD><TD style="border: 0px solid black;">ac</TD></TR><TR><TD align="right" height="17" style="border: 0px solid black;"> 6</TD><TD style="border: 0px solid black;">f</TD><TD align="right" style="border: 0px solid black;">2010</TD><TD style="border: 0px solid black;">f</TD><TD style="border: 0px solid black;">ac</TD></TR><TR><TD align="right" height="17" style="border: 0px solid black;"> 6</TD><TD style="border: 0px solid black;">f</TD><TD align="right" style="border: 0px solid black;">2011</TD><TD style="border: 0px solid black;">f</TD><TD style="border: 0px solid black;">ac</TD></TR><TR><TD align="right" height="17" style="border: 0px solid black;"> 6</TD><TD style="border: 0px solid black;">f</TD><TD align="right" style="border: 0px solid black;">2012</TD><TD style="border: 0px solid black;">f</TD><TD style="border: 0px solid black;">ac</TD></TR></TBODY></TABLE><P class="yj6qo ajU"></P><DIV class="ajR" id=":13s"><IMG class="ajT jiveImage" src="https://mail.google.com/mail/u/0/images/cleardot.gif" /><P></P></DIV></BODY></HTML> Wed, 09 Jan 2013 09:09:16 GMT https://community.qlik.com/t5/QlikView/Data-Visualization/m-p/406513#M1158858 2013-01-09T09:09:16Z Re: Data Visualization https://community.qlik.com/t5/QlikView/Data-Visualization/m-p/406514#M1158859 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>&nbsp; can you be more specific please? Do you need a script?</P><P>Is the table your source data? What is your goal?</P><P></P><P>Regards,</P><P>Daniele</P></BODY></HTML> Wed, 09 Jan 2013 09:34:37 GMT https://community.qlik.com/t5/QlikView/Data-Visualization/m-p/406514#M1158859 2013-01-09T09:34:37Z Re: Data Visualization https://community.qlik.com/t5/QlikView/Data-Visualization/m-p/406515#M1158860 <HTML><HEAD></HEAD><BODY><P>The above table is my data.</P><P></P><P>I want that employee who has promotion ='f ' for year(2010,2011,2012) and that employee should also be active 'ac' in 2012 year</P></BODY></HTML> Wed, 09 Jan 2013 09:44:42 GMT https://community.qlik.com/t5/QlikView/Data-Visualization/m-p/406515#M1158860 2013-01-09T09:44:42Z Re: Data Visualization https://community.qlik.com/t5/QlikView/Data-Visualization/m-p/406516#M1158861 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>=if(<SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">Active</SPAN>='ac' and <SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">FinFlag</SPAN>=2012 </P><P>or</P><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">Promotion</SPAN>='f' and<SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">FinFlag</SPAN>=2011</P><P> or</P><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">Promotion</SPAN>='f' and<SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">FinFlag</SPAN>=2012</P><P> or</P><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">Promotion</SPAN>='f' and<SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">FinFlag</SPAN>=2013</P><P></P><P>,<SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">Emp</SPAN>,Null())</P><P></P><P></P><P>use this expression in ur calculated dimension</P></BODY></HTML> Wed, 09 Jan 2013 09:46:49 GMT https://community.qlik.com/t5/QlikView/Data-Visualization/m-p/406516#M1158861 2013-01-09T09:46:49Z