topic dynamic threshold value in QlikView https://community.qlik.com/t5/QlikView/dynamic-threshold-value/m-p/703747#M541727 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en"><SPAN class="hps">Hello everyone,</SPAN> <SPAN class="hps">I would</SPAN> <SPAN class="hps">need</SPAN> <SPAN class="hps">in</SPAN> <SPAN class="hps">a bar chart</SPAN> <SPAN class="hps">where</SPAN> <SPAN class="hps">I run</SPAN> <SPAN class="hps">for</SPAN> <SPAN class="hps">a</SPAN> <SPAN class="hps">confornto</SPAN> <SPAN class="hps">in 2 years</SPAN> <SPAN class="hps">grouped by</SPAN> <SPAN class="hps">size, enter</SPAN> <SPAN class="hps">a threshold value</SPAN> <SPAN class="hps">(line or</SPAN> <SPAN class="hps">point</SPAN> <SPAN class="hps">data)</SPAN> <SPAN class="hps">dynamically for each</SPAN> <SPAN class="hps">value</SPAN> <SPAN class="hps">of the dimension.</SPAN> <BR /><BR /><SPAN class="hps">In practice</SPAN> <SPAN class="hps">I would get</SPAN> <SPAN class="hps">the green lines</SPAN> <SPAN class="hps">in the chart</SPAN> <SPAN class="hps">included</SPAN> <SPAN class="hps">in the annex.</SPAN> <BR /><BR /><SPAN class="hps">I could</SPAN> <SPAN class="hps">insert a</SPAN> <SPAN class="hps">3</SPAN> <SPAN class="hps">expression</SPAN> <SPAN class="hps">with the value</SPAN> <SPAN class="hps">of the threshold and</SPAN> <SPAN class="hps">represent it</SPAN> <SPAN class="hps">as a symbol</SPAN><SPAN>.</SPAN> <SPAN class="hps">the problem</SPAN> <SPAN class="hps">is that I should</SPAN> <SPAN class="hps">change the type of</SPAN> <SPAN class="hps">chart</SPAN> <SPAN class="hps">by inserting</SPAN> <SPAN class="hps">the stack</SPAN> <SPAN class="hps">losing</SPAN> <SPAN class="hps">the grouping</SPAN> <SPAN class="hps">for</SPAN> <SPAN class="hps">the comparison between the</SPAN> <SPAN class="hps">two years</SPAN>. <BR /><BR /><SPAN class="hps">could someone give me</SPAN> <SPAN class="hps">a hand?</SPAN> <BR /><BR /><SPAN class="hps">thanks</SPAN> <BR /><BR /><SPAN class="hps">Andrea</SPAN></SPAN></P></BODY></HTML> Wed, 18 Jun 2014 14:27:01 GMT warrentk80 2014-06-18T14:27:01Z dynamic threshold value https://community.qlik.com/t5/QlikView/dynamic-threshold-value/m-p/703747#M541727 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en"><SPAN class="hps">Hello everyone,</SPAN> <SPAN class="hps">I would</SPAN> <SPAN class="hps">need</SPAN> <SPAN class="hps">in</SPAN> <SPAN class="hps">a bar chart</SPAN> <SPAN class="hps">where</SPAN> <SPAN class="hps">I run</SPAN> <SPAN class="hps">for</SPAN> <SPAN class="hps">a</SPAN> <SPAN class="hps">confornto</SPAN> <SPAN class="hps">in 2 years</SPAN> <SPAN class="hps">grouped by</SPAN> <SPAN class="hps">size, enter</SPAN> <SPAN class="hps">a threshold value</SPAN> <SPAN class="hps">(line or</SPAN> <SPAN class="hps">point</SPAN> <SPAN class="hps">data)</SPAN> <SPAN class="hps">dynamically for each</SPAN> <SPAN class="hps">value</SPAN> <SPAN class="hps">of the dimension.</SPAN> <BR /><BR /><SPAN class="hps">In practice</SPAN> <SPAN class="hps">I would get</SPAN> <SPAN class="hps">the green lines</SPAN> <SPAN class="hps">in the chart</SPAN> <SPAN class="hps">included</SPAN> <SPAN class="hps">in the annex.</SPAN> <BR /><BR /><SPAN class="hps">I could</SPAN> <SPAN class="hps">insert a</SPAN> <SPAN class="hps">3</SPAN> <SPAN class="hps">expression</SPAN> <SPAN class="hps">with the value</SPAN> <SPAN class="hps">of the threshold and</SPAN> <SPAN class="hps">represent it</SPAN> <SPAN class="hps">as a symbol</SPAN><SPAN>.</SPAN> <SPAN class="hps">the problem</SPAN> <SPAN class="hps">is that I should</SPAN> <SPAN class="hps">change the type of</SPAN> <SPAN class="hps">chart</SPAN> <SPAN class="hps">by inserting</SPAN> <SPAN class="hps">the stack</SPAN> <SPAN class="hps">losing</SPAN> <SPAN class="hps">the grouping</SPAN> <SPAN class="hps">for</SPAN> <SPAN class="hps">the comparison between the</SPAN> <SPAN class="hps">two years</SPAN>. <BR /><BR /><SPAN class="hps">could someone give me</SPAN> <SPAN class="hps">a hand?</SPAN> <BR /><BR /><SPAN class="hps">thanks</SPAN> <BR /><BR /><SPAN class="hps">Andrea</SPAN></SPAN></P></BODY></HTML> Wed, 18 Jun 2014 14:27:01 GMT https://community.qlik.com/t5/QlikView/dynamic-threshold-value/m-p/703747#M541727 warrentk80 2014-06-18T14:27:01Z Re: dynamic threshold value https://community.qlik.com/t5/QlikView/dynamic-threshold-value/m-p/703748#M541728 <HTML><HEAD></HEAD><BODY><P>La mia idea è quella di aggiungere una tabella (load * inline) con i calori delle dimensioni e delle soglie e mostrare queste ultime come espressioni lineari (combo box) legate ad ogni soingola dimensione</P><P></P><P>Fammi sapere</P><P></P><P>Ciao</P></BODY></HTML> Wed, 18 Jun 2014 14:32:01 GMT https://community.qlik.com/t5/QlikView/dynamic-threshold-value/m-p/703748#M541728 alexandros17 2014-06-18T14:32:01Z Re: dynamic threshold value https://community.qlik.com/t5/QlikView/dynamic-threshold-value/m-p/703749#M541729 <HTML><HEAD></HEAD><BODY><P>Ciao Alessandro ti ringrazio per la risposta.</P><P></P><P>provo a vedere se cosi funziona, nel frattempo riesci ad inviarmi un esempio con dei dati di test?</P><P></P><P>Ti ringrazio</P><P></P><P>Andrea</P></BODY></HTML> Wed, 18 Jun 2014 14:50:18 GMT https://community.qlik.com/t5/QlikView/dynamic-threshold-value/m-p/703749#M541729 warrentk80 2014-06-18T14:50:18Z Re: dynamic threshold value https://community.qlik.com/t5/QlikView/dynamic-threshold-value/m-p/703750#M541730 <HTML><HEAD></HEAD><BODY><P>Purtroppo adesso non riesco, se non riesci in serata riscrivi domattina e cercherò di aiutarti ...</P></BODY></HTML> Wed, 18 Jun 2014 15:17:45 GMT https://community.qlik.com/t5/QlikView/dynamic-threshold-value/m-p/703750#M541730 alexandros17 2014-06-18T15:17:45Z