topic Conditional expressions in charts in QlikView https://community.qlik.com/t5/QlikView/Conditional-expressions-in-charts/m-p/1181567#M462410 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>i have got stuck on a chart were i want to build a pie chart that aslo can be used for drilldown analysis. data is from a production process.</P><P>ID ( is a uniq product individual)</P><P>ProcessStep what part of the production the temperature measurement have been done.</P><P></P><P>i need a piechart based on a specific Processstep ( ie 2), there the pie´s should be represented on temperature intervalls [A=0-35, B=36-70,C=71-200]</P><P></P><P>on this dashboard i also have a table that should list som details about the individuals that is included if you click on A for instance.</P><P></P><P>there for i can not use a simple count distinct.</P><P></P><P>could any one advise?</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); border-image: none; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>ID</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>ProcessStep</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Temperature</STRONG></TH></TR><TR><TD style="padding: 2px;">10555</TD><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">80</TD></TR><TR><TD style="padding: 2px;">10555</TD><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">54</TD></TR><TR><TD style="padding: 2px;">10666</TD><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">65</TD></TR><TR><TD style="padding: 2px;">10666</TD><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">35</TD></TR><TR><TD style="padding: 2px;">10654</TD><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">70</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE></BODY></HTML> Mon, 26 Sep 2016 06:17:26 GMT 2016-09-26T06:17:26Z Conditional expressions in charts https://community.qlik.com/t5/QlikView/Conditional-expressions-in-charts/m-p/1181567#M462410 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>i have got stuck on a chart were i want to build a pie chart that aslo can be used for drilldown analysis. data is from a production process.</P><P>ID ( is a uniq product individual)</P><P>ProcessStep what part of the production the temperature measurement have been done.</P><P></P><P>i need a piechart based on a specific Processstep ( ie 2), there the pie´s should be represented on temperature intervalls [A=0-35, B=36-70,C=71-200]</P><P></P><P>on this dashboard i also have a table that should list som details about the individuals that is included if you click on A for instance.</P><P></P><P>there for i can not use a simple count distinct.</P><P></P><P>could any one advise?</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); border-image: none; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>ID</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>ProcessStep</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Temperature</STRONG></TH></TR><TR><TD style="padding: 2px;">10555</TD><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">80</TD></TR><TR><TD style="padding: 2px;">10555</TD><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">54</TD></TR><TR><TD style="padding: 2px;">10666</TD><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">65</TD></TR><TR><TD style="padding: 2px;">10666</TD><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">35</TD></TR><TR><TD style="padding: 2px;">10654</TD><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">70</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE></BODY></HTML> Mon, 26 Sep 2016 06:17:26 GMT https://community.qlik.com/t5/QlikView/Conditional-expressions-in-charts/m-p/1181567#M462410 2016-09-26T06:17:26Z