topic Re: How to change graph colors based on calculated dimension values in QlikView

topic Re: How to change graph colors based on calculated dimension values in QlikView https://community.qlik.com/t5/QlikView/How-to-change-graph-colors-based-on-calculated-dimension-values/m-p/431693#M566797 <HTML><HEAD></HEAD><BODY><P>HI</P><P></P><P>Can you explain more details? If possible, can you provide a sample file? </P></BODY></HTML> Wed, 12 Dec 2012 19:53:09 GMT MayilVahanan 2012-12-12T19:53:09Z How to change graph colors based on calculated dimension values https://community.qlik.com/t5/QlikView/How-to-change-graph-colors-based-on-calculated-dimension-values/m-p/431692#M566796 <HTML><HEAD></HEAD><BODY><P>I have a dimension that </P><P><SPAN style="color: #0000ff; font-size: 8pt;">  </SPAN><SPAN style="color: #0000ff; font-size: 8pt;"></SPAN></P><P>aggr</P><P></P><P></P><P><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;"> (</SPAN><SPAN style="color: #800000; font-size: 8pt;">Qtde</SPAN><SPAN style="font-size: 8pt;">) /<BR />(<BR /></SPAN><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;"> ({$<</SPAN><SPAN style="color: #800000; font-size: 8pt;">Ano_Mes</SPAN><SPAN style="font-size: 8pt;"> = {</SPAN><STRONG><EM style="color: #808080; font-size: 8pt;"><STRONG><EM style="color: #808080; font-size: 8pt;">$(=Max(Ano)&num(Max(Mes),'00') ) </EM></STRONG></EM></STRONG><SPAN style="font-size: 8pt;">} >}  </SPAN><SPAN style="color: #800000; font-size: 8pt;">[Expectativa Vendas]</SPAN><SPAN style="font-size: 8pt;">)<BR />* </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">num</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">MaxString</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Mês Filtro]</SPAN><SPAN style="font-size: 8pt;">))), </SPAN><SPAN style="color: #800000; font-size: 8pt;">PartNumber</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P></P><P></P><P><EM style="color: #808080; font-size: 8pt;"><EM style="color: #808080; font-size: 8pt;"> And  depends on the results I need   diferent collors in the pizza graphs. </EM></EM></P><P></P><P></P></BODY></HTML> Wed, 12 Dec 2012 19:43:24 GMT https://community.qlik.com/t5/QlikView/How-to-change-graph-colors-based-on-calculated-dimension-values/m-p/431692#M566796 2012-12-12T19:43:24Z Re: How to change graph colors based on calculated dimension values https://community.qlik.com/t5/QlikView/How-to-change-graph-colors-based-on-calculated-dimension-values/m-p/431693#M566797 <HTML><HEAD></HEAD><BODY><P>HI</P><P></P><P>Can you explain more details? If possible, can you provide a sample file? </P></BODY></HTML> Wed, 12 Dec 2012 19:53:09 GMT https://community.qlik.com/t5/QlikView/How-to-change-graph-colors-based-on-calculated-dimension-values/m-p/431693#M566797 MayilVahanan 2012-12-12T19:53:09Z Re: How to change graph colors based on calculated dimension values https://community.qlik.com/t5/QlikView/How-to-change-graph-colors-based-on-calculated-dimension-values/m-p/431694#M566798 <HTML><HEAD></HEAD><BODY><P>Click on the + in front of the dimension and select Background Color. Then click on the Edit button. Now you can add an expression that calculates the color.</P><P></P><P>If( some_epxr = 12, red(), if some_epxr = 18.5, green(), blue() ))</P><P></P><P>Replace some_expr with your expression for the calculated dimension and change the comparison values as needed. </P><P>If you have a lot of values, you might want to use a pick-match combination instead of a nested if.</P></BODY></HTML> Wed, 12 Dec 2012 19:55:47 GMT https://community.qlik.com/t5/QlikView/How-to-change-graph-colors-based-on-calculated-dimension-values/m-p/431694#M566798 Gysbert_Wassenaar 2012-12-12T19:55:47Z Re: How to change graph colors based on calculated dimension values https://community.qlik.com/t5/QlikView/How-to-change-graph-colors-based-on-calculated-dimension-values/m-p/431695#M566799 <HTML><HEAD></HEAD><BODY><P>I've already tried it, but haven't work. </P></BODY></HTML> Wed, 12 Dec 2012 20:11:32 GMT https://community.qlik.com/t5/QlikView/How-to-change-graph-colors-based-on-calculated-dimension-values/m-p/431695#M566799 2012-12-12T20:11:32Z Re: How to change graph colors based on calculated dimension values https://community.qlik.com/t5/QlikView/How-to-change-graph-colors-based-on-calculated-dimension-values/m-p/431696#M566800 <HTML><HEAD></HEAD><BODY><P>Sorry, unfortunately i have sensitive data and i cannot create a sample, however below i put more details</P><P></P><P><STRONG>Dimension </STRONG>:</P><P>= if(</P><P>aggr(sum (Qtde) /<BR /> (<BR />    sum ({$<Ano_Mes = {$(=Max(Ano)&num(Max(Mes),'00') )} >}</P><P>[Expectativa Vendas])<BR />       *  num(MaxString([Mês Filtro]))), PartNumber) </P><P><=Var_Cor_Penetracao_Amarelo,<BR />       <BR />dual('Crítico',1)  , <BR /> <BR />   if(<BR />   <BR />   aggr(sum (Qtde) /<BR /> (<BR />    sum ({$<Ano_Mes = {$(=Max(Ano)&num(Max(Mes),'00') )} >}</P><P>[Expectativa Vendas])<BR />       *  num(MaxString([Mês Filtro]))), PartNumber) </P><P><=Var_Cor_Penetracao_Laranja ,<BR />      <BR />dual('Regular',2),<BR /> <BR /> if(<BR />aggr(sum (Qtde) /<BR /> (<BR />    sum ({$<Ano_Mes = {$(=Max(Ano)&num(Max(Mes),'00') )} >}</P><P>[Expectativa Vendas])<BR />       *  num(MaxString([Mês Filtro]))), PartNumber) </P><P><=Var_Cor_Penetracao_Marinho,<BR />       <BR /> dual('Bom',3),<BR /> if(<BR />aggr(sum (Qtde) /<BR /> (<BR />    sum ({$<Ano_Mes = {$(=Max(Ano)&num(Max(Mes),'00') )} >}</P><P>[Expectativa Vendas])<BR />       *  num(MaxString([Mês Filtro]))), PartNumber) </P><P><=Var_Cor_Penetracao_Verde, <BR />       <BR />dual('Muito Bom',4),<BR /> <BR />  if(aggr(sum (Qtde) /<BR /> (<BR />    sum ({$<Ano_Mes = {$(=Max(Ano)&num(Max(Mes),'00') )} >}</P><P>[Expectativa Vendas])<BR />       *  num(MaxString([Mês Filtro]))), PartNumber)</P><P>>Var_Cor_Penetracao_Verde, <BR />       <BR />dual('Excelente',5)<BR />  <BR /> )<BR /> )<BR /> )<BR /> )<BR /> )</P><P></P><P><STRONG>Expression </STRONG>: Count (DISTINCT PartNumber)</P><P></P><P><EM>I've already tried put the same expession ,  only chaging dual function by the collor (red(), blue etc),  in the background color propertie from this dimension and also in the background collor from the expression.</EM></P></BODY></HTML> Wed, 12 Dec 2012 20:19:31 GMT https://community.qlik.com/t5/QlikView/How-to-change-graph-colors-based-on-calculated-dimension-values/m-p/431696#M566800 2012-12-12T20:19:31Z Re: How to change graph colors based on calculated dimension values https://community.qlik.com/t5/QlikView/How-to-change-graph-colors-based-on-calculated-dimension-values/m-p/431697#M566801 <HTML><HEAD></HEAD><BODY><P>HI</P><P></P><P>In background color, use like this </P><P></P><P>if(</P><P>   </P><P>   aggr(sum (Qtde) / (sum ({$<Ano_Mes = {$(=Max(Ano)&num(Max(Mes),'00') )} >}[Expectativa Vendas]) *  num(MaxString([Mês Filtro]))), PartNumber) <= Var_Cor_Penetracao_Laranja , red(), blue())</P><P></P><P>And test, it will show the red color for first dimension and remaining the blue color?</P><P></P><P>May be any bracket miss while changing the dual() to color function.</P></BODY></HTML> Wed, 12 Dec 2012 20:42:14 GMT https://community.qlik.com/t5/QlikView/How-to-change-graph-colors-based-on-calculated-dimension-values/m-p/431697#M566801 MayilVahanan 2012-12-12T20:42:14Z Re: How to change graph colors based on calculated dimension values https://community.qlik.com/t5/QlikView/How-to-change-graph-colors-based-on-calculated-dimension-values/m-p/431698#M566802 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I tried your instruction on both background collor properties (dimension and expression) and also in the collor set. </P><P>Didn't work!</P><P></P><P>It could be solved getting dimension values . for example : if (Dimesion.label = 'x', red(), blue() ) however QV does not allow make this kind of reference to a calculated dimension. It only works when you are referencing dimensions defined with table fields.</P></BODY></HTML> Thu, 13 Dec 2012 11:00:41 GMT https://community.qlik.com/t5/QlikView/How-to-change-graph-colors-based-on-calculated-dimension-values/m-p/431698#M566802 2012-12-13T11:00:41Z