topic Re: Re: relative position and values ​​between two graphs in Water Cooler https://community.qlik.com/t5/Water-Cooler/relative-position-and-values-between-two-graphs/m-p/606290#M2597 <HTML><HEAD></HEAD><BODY><P>I think so. I've 'pimped up' my example a bit. Play around with the list boxes to see what happens.</P></BODY></HTML> Wed, 05 Feb 2014 10:37:26 GMT Gysbert_Wassenaar 2014-02-05T10:37:26Z relative position and values ​​between two graphs https://community.qlik.com/t5/Water-Cooler/relative-position-and-values-between-two-graphs/m-p/606272#M2579 <HTML><HEAD></HEAD><BODY><P>Hi all.</P><P>I'd want to obtain this kind of graph</P><P></P><P></P><P><IMG alt="" class="jiveImage" height="221" src="https://community.qlik.com/legacyfs/online/52597_pastedImage_0.png" style="width: 524px; height: 220.986px;" width="524" /></P><P></P><P>the chart is easy to get. The problem is the line "Change(%)".</P><P>In this section, I want the % between a quarter and the previous quarter (7,4 is 29-27=2 and 2 is 7.4% of 27). The first value is always " - ", the others are according to the results of the graph.</P><P>Again, I'd want the numbers remain aligned to the quarter (1Q13, 1Q14 ...) of the X axis of the graph.</P><P>how can I do?</P><P></P><P>Many thanks in advance.</P><P>Luca</P></BODY></HTML> Tue, 04 Feb 2014 15:17:02 GMT https://community.qlik.com/t5/Water-Cooler/relative-position-and-values-between-two-graphs/m-p/606272#M2579 2014-02-04T15:17:02Z Re: relative position and values ​​between two graphs https://community.qlik.com/t5/Water-Cooler/relative-position-and-values-between-two-graphs/m-p/606273#M2580 <HTML><HEAD></HEAD><BODY><P>Put a straight table just below of your bar graph.</P><P>Mark it as "Horizontal" and use same dimension of your graph bar</P></BODY></HTML> Tue, 04 Feb 2014 15:51:55 GMT https://community.qlik.com/t5/Water-Cooler/relative-position-and-values-between-two-graphs/m-p/606273#M2580 Clever_Anjos 2014-02-04T15:51:55Z Re: relative position and values ​​between two graphs https://community.qlik.com/t5/Water-Cooler/relative-position-and-values-between-two-graphs/m-p/606274#M2581 <HTML><HEAD></HEAD><BODY><P>Well, not quite what you're asking for, but pretty close I think. See attached qvw.</P></BODY></HTML> Tue, 04 Feb 2014 15:55:04 GMT https://community.qlik.com/t5/Water-Cooler/relative-position-and-values-between-two-graphs/m-p/606274#M2581 Gysbert_Wassenaar 2014-02-04T15:55:04Z Re: Re: relative position and values ​​between two graphs https://community.qlik.com/t5/Water-Cooler/relative-position-and-values-between-two-graphs/m-p/606275#M2582 <HTML><HEAD></HEAD><BODY><P>PFA</P></BODY></HTML> Tue, 04 Feb 2014 15:56:12 GMT https://community.qlik.com/t5/Water-Cooler/relative-position-and-values-between-two-graphs/m-p/606275#M2582 Clever_Anjos 2014-02-04T15:56:12Z Re: relative position and values ​​between two graphs https://community.qlik.com/t5/Water-Cooler/relative-position-and-values-between-two-graphs/m-p/606276#M2583 <HTML><HEAD></HEAD><BODY><P>thanks, Clever.</P><P>% count is ok, but alignment is lost when data changes.<SPAN lang="en"><SPAN class="hps">How can I</SPAN> <SPAN class="hps">dynamically</SPAN> <SPAN class="hps">tune the</SPAN> <SPAN class="hps">size of the table</SPAN> <SPAN class="hps">with</SPAN> <SPAN class="hps">those</SPAN> <SPAN class="hps">of the graph</SPAN>?</SPAN></P><P><SPAN lang="en">luca<BR /></SPAN></P></BODY></HTML> Tue, 04 Feb 2014 16:18:39 GMT https://community.qlik.com/t5/Water-Cooler/relative-position-and-values-between-two-graphs/m-p/606276#M2583 2014-02-04T16:18:39Z Re: relative position and values ​​between two graphs https://community.qlik.com/t5/Water-Cooler/relative-position-and-values-between-two-graphs/m-p/606277#M2584 <HTML><HEAD></HEAD><BODY><P>You mean when showing less values?</P></BODY></HTML> Tue, 04 Feb 2014 16:22:07 GMT https://community.qlik.com/t5/Water-Cooler/relative-position-and-values-between-two-graphs/m-p/606277#M2584 Clever_Anjos 2014-02-04T16:22:07Z Re: relative position and values ​​between two graphs https://community.qlik.com/t5/Water-Cooler/relative-position-and-values-between-two-graphs/m-p/606278#M2585 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en"><SPAN class="hps">Yes,</SPAN> <SPAN class="hps">exactly</SPAN>. </SPAN></P><P><SPAN lang="en"><SPAN class="hps">if the values ​​are</SPAN> <SPAN class="hps">more</SPAN> <SPAN class="hps">(or less)</SPAN>, the alignment <SPAN class="hps">is lost.</SPAN></SPAN></P><P><SPAN lang="en"><SPAN class="hps">many thanks</SPAN></SPAN></P><P><SPAN lang="en"><SPAN class="hps">luca<BR /></SPAN></SPAN></P></BODY></HTML> Tue, 04 Feb 2014 16:25:21 GMT https://community.qlik.com/t5/Water-Cooler/relative-position-and-values-between-two-graphs/m-p/606278#M2585 2014-02-04T16:25:21Z Re: relative position and values ​​between two graphs https://community.qlik.com/t5/Water-Cooler/relative-position-and-values-between-two-graphs/m-p/606279#M2586 <HTML><HEAD></HEAD><BODY><P>I don´t see how I could do that</P></BODY></HTML> Tue, 04 Feb 2014 16:26:48 GMT https://community.qlik.com/t5/Water-Cooler/relative-position-and-values-between-two-graphs/m-p/606279#M2586 Clever_Anjos 2014-02-04T16:26:48Z Re: relative position and values ​​between two graphs https://community.qlik.com/t5/Water-Cooler/relative-position-and-values-between-two-graphs/m-p/606280#M2587 <HTML><HEAD></HEAD><BODY><P>is it possible get the position of the legend of the x axis (1Q13, 1Q14 ..) and on this build the table?</P></BODY></HTML> Tue, 04 Feb 2014 16:29:31 GMT https://community.qlik.com/t5/Water-Cooler/relative-position-and-values-between-two-graphs/m-p/606280#M2587 2014-02-04T16:29:31Z Re: relative position and values ​​between two graphs https://community.qlik.com/t5/Water-Cooler/relative-position-and-values-between-two-graphs/m-p/606281#M2588 <HTML><HEAD></HEAD><BODY><P>I´m almost sure not, you can´t get it</P></BODY></HTML> Tue, 04 Feb 2014 16:33:50 GMT https://community.qlik.com/t5/Water-Cooler/relative-position-and-values-between-two-graphs/m-p/606281#M2588 Clever_Anjos 2014-02-04T16:33:50Z Re: relative position and values ​​between two graphs https://community.qlik.com/t5/Water-Cooler/relative-position-and-values-between-two-graphs/m-p/606282#M2589 <HTML><HEAD></HEAD><BODY><P>ok, thank you very much</P><P></P><P>ciao</P><P>luca</P></BODY></HTML> Tue, 04 Feb 2014 16:34:38 GMT https://community.qlik.com/t5/Water-Cooler/relative-position-and-values-between-two-graphs/m-p/606282#M2589 2014-02-04T16:34:38Z Re: Re: Re: relative position and values ​​between two graphs https://community.qlik.com/t5/Water-Cooler/relative-position-and-values-between-two-graphs/m-p/606283#M2590 <HTML><HEAD></HEAD><BODY><P>A better solution...</P></BODY></HTML> Tue, 04 Feb 2014 16:37:51 GMT https://community.qlik.com/t5/Water-Cooler/relative-position-and-values-between-two-graphs/m-p/606283#M2590 Clever_Anjos 2014-02-04T16:37:51Z Re: relative position and values ​​between two graphs https://community.qlik.com/t5/Water-Cooler/relative-position-and-values-between-two-graphs/m-p/606284#M2591 <HTML><HEAD></HEAD><BODY><P>I think it depends on the size of the legend.. I'll try..</P><P></P><P>thanks</P><P>luca</P></BODY></HTML> Tue, 04 Feb 2014 16:44:05 GMT https://community.qlik.com/t5/Water-Cooler/relative-position-and-values-between-two-graphs/m-p/606284#M2591 2014-02-04T16:44:05Z Re: relative position and values ​​between two graphs https://community.qlik.com/t5/Water-Cooler/relative-position-and-values-between-two-graphs/m-p/606285#M2592 <HTML><HEAD></HEAD><BODY><P>Hi Clever.</P><P></P><P>Your solution is what I was looking for, thank you.</P><P>luca</P></BODY></HTML> Wed, 05 Feb 2014 08:20:30 GMT https://community.qlik.com/t5/Water-Cooler/relative-position-and-values-between-two-graphs/m-p/606285#M2592 2014-02-05T08:20:30Z Re: relative position and values ​​between two graphs https://community.qlik.com/t5/Water-Cooler/relative-position-and-values-between-two-graphs/m-p/606286#M2593 <HTML><HEAD></HEAD><BODY><P>Just curious, but... did you even look at my solution?</P></BODY></HTML> Wed, 05 Feb 2014 09:35:01 GMT https://community.qlik.com/t5/Water-Cooler/relative-position-and-values-between-two-graphs/m-p/606286#M2593 Gysbert_Wassenaar 2014-02-05T09:35:01Z Re: relative position and values ​​between two graphs https://community.qlik.com/t5/Water-Cooler/relative-position-and-values-between-two-graphs/m-p/606287#M2594 <HTML><HEAD></HEAD><BODY><P>Hi Gysbert.</P><P>Sure I looked at your solution (and thank you, of course!). It's a good example.</P><P>But my customer wants a graph as I posted: % (ok) and dinamic alignment (not possible, I think).</P><P></P><P>Grazie</P><P>Luca</P></BODY></HTML> Wed, 05 Feb 2014 09:50:57 GMT https://community.qlik.com/t5/Water-Cooler/relative-position-and-values-between-two-graphs/m-p/606287#M2594 2014-02-05T09:50:57Z Re: relative position and values ​​between two graphs https://community.qlik.com/t5/Water-Cooler/relative-position-and-values-between-two-graphs/m-p/606288#M2595 <HTML><HEAD></HEAD><BODY><P>What do you mean with dinamic alignment?</P></BODY></HTML> Wed, 05 Feb 2014 10:10:32 GMT https://community.qlik.com/t5/Water-Cooler/relative-position-and-values-between-two-graphs/m-p/606288#M2595 Gysbert_Wassenaar 2014-02-05T10:10:32Z Re: relative position and values ​​between two graphs https://community.qlik.com/t5/Water-Cooler/relative-position-and-values-between-two-graphs/m-p/606289#M2596 <HTML><HEAD></HEAD><BODY><P>In my graph, alignment between chart and %table is lost when data changes, i.e. <SPAN lang="en"><SPAN class="hps">if the values ​​are</SPAN> <SPAN class="hps">more</SPAN> <SPAN class="hps">(or less)..</SPAN></SPAN></P><P><SPAN lang="en"><SPAN class="hps">Have you a solution for this?</SPAN></SPAN></P><P><SPAN lang="en"><SPAN class="hps">luca</SPAN></SPAN></P></BODY></HTML> Wed, 05 Feb 2014 10:18:08 GMT https://community.qlik.com/t5/Water-Cooler/relative-position-and-values-between-two-graphs/m-p/606289#M2596 2014-02-05T10:18:08Z Re: Re: relative position and values ​​between two graphs https://community.qlik.com/t5/Water-Cooler/relative-position-and-values-between-two-graphs/m-p/606290#M2597 <HTML><HEAD></HEAD><BODY><P>I think so. I've 'pimped up' my example a bit. Play around with the list boxes to see what happens.</P></BODY></HTML> Wed, 05 Feb 2014 10:37:26 GMT https://community.qlik.com/t5/Water-Cooler/relative-position-and-values-between-two-graphs/m-p/606290#M2597 Gysbert_Wassenaar 2014-02-05T10:37:26Z Re: relative position and values ​​between two graphs https://community.qlik.com/t5/Water-Cooler/relative-position-and-values-between-two-graphs/m-p/606291#M2598 <HTML><HEAD></HEAD><BODY><P>it's an interesting solution, thanks!</P></BODY></HTML> Wed, 05 Feb 2014 10:58:31 GMT https://community.qlik.com/t5/Water-Cooler/relative-position-and-values-between-two-graphs/m-p/606291#M2598 2014-02-05T10:58:31Z