topic How to connect two sliders in QlikView https://community.qlik.com/t5/QlikView/How-to-connect-two-sliders/m-p/420667#M156591 <HTML><HEAD></HEAD><BODY><P>Hi all QV developers, would I ask you for help?</P><P></P><P>Is possible to make solution where are two interrelated sliders <SPAN class="short_text" id="result_box" lang="en"><SPAN class="hps">responding to</SPAN> <SPAN class="hps">each other? Picture is below.</SPAN></SPAN></P><P></P><P>Default state:</P><P></P><P>- upper slider shows %</P><P>- left slider shows whole numbers (integers)</P><P>- straight table contains products and their sales. Table is always sorted by sales size descending</P><P></P><P>Requirement:</P><P></P><P>1a)</P><P></P><P>When "x"% is selected in the upper slider then table show products whose sales are "x"% of total sales. - This works for me</P><P></P><P>1b)</P><P></P><P>Showing this "x"% in NUMBERS on the left slider - how many products makes this "x"%</P><P></P><P>This solution must work also in reverse.</P><P></P><P></P><P>THANKS YOU MUCH for any idea!</P><P></P><P>Mirek</P></BODY></HTML> Wed, 19 Sep 2012 09:22:24 GMT 2012-09-19T09:22:24Z How to connect two sliders https://community.qlik.com/t5/QlikView/How-to-connect-two-sliders/m-p/420667#M156591 <HTML><HEAD></HEAD><BODY><P>Hi all QV developers, would I ask you for help?</P><P></P><P>Is possible to make solution where are two interrelated sliders <SPAN class="short_text" id="result_box" lang="en"><SPAN class="hps">responding to</SPAN> <SPAN class="hps">each other? Picture is below.</SPAN></SPAN></P><P></P><P>Default state:</P><P></P><P>- upper slider shows %</P><P>- left slider shows whole numbers (integers)</P><P>- straight table contains products and their sales. Table is always sorted by sales size descending</P><P></P><P>Requirement:</P><P></P><P>1a)</P><P></P><P>When "x"% is selected in the upper slider then table show products whose sales are "x"% of total sales. - This works for me</P><P></P><P>1b)</P><P></P><P>Showing this "x"% in NUMBERS on the left slider - how many products makes this "x"%</P><P></P><P>This solution must work also in reverse.</P><P></P><P></P><P>THANKS YOU MUCH for any idea!</P><P></P><P>Mirek</P></BODY></HTML> Wed, 19 Sep 2012 09:22:24 GMT https://community.qlik.com/t5/QlikView/How-to-connect-two-sliders/m-p/420667#M156591 2012-09-19T09:22:24Z Re: How to connect two sliders https://community.qlik.com/t5/QlikView/How-to-connect-two-sliders/m-p/420668#M156592 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Hi Mirek,</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;"> </SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Please can you post the sample app and we can workout a solution for you.</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;"> </SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Thanks,</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">DV</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;"> </SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;"><A href="http://www.QlikShare.com">www.QlikShare.com</A></SPAN></P></BODY></HTML> Wed, 19 Sep 2012 09:38:59 GMT https://community.qlik.com/t5/QlikView/How-to-connect-two-sliders/m-p/420668#M156592 IAMDV 2012-09-19T09:38:59Z Re: How to connect two sliders https://community.qlik.com/t5/QlikView/How-to-connect-two-sliders/m-p/420669#M156593 <HTML><HEAD></HEAD><BODY><P>Hello Deepak,</P><P></P><P>I've created sample app. I hope that the descriptions in text objects will be understandable.</P><P></P><P>Thanks for your any help!</P><P></P><P>Mirek<A _jive_internal="true" class="font-color-meta advEditor" href="https://community.qlik.com///"><BR /></A></P></BODY></HTML> Wed, 19 Sep 2012 11:35:03 GMT https://community.qlik.com/t5/QlikView/How-to-connect-two-sliders/m-p/420669#M156593 2012-09-19T11:35:03Z Re: How to connect two sliders https://community.qlik.com/t5/QlikView/How-to-connect-two-sliders/m-p/420670#M156594 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P>Open Triggers page in Document Properties. </P><P>Take attention to the bottom, variable event triggers listbox.</P><P></P><P>For&nbsp; vFirstX variable add OnChange action.</P><P>Again click Add. Select External-&gt;SetVariable.</P><P>Input in Variable and Value correspondingly:</P><P>vTopN</P><P>=floor(Count(Author)*vFirstX)</P><P></P><P>Then for vTopN variable add OnChange action.</P><P>Again click Add. Select External-&gt;SetVariable.</P><P>Input in Variable and Value correspondingly:</P><P>vFirstX</P><P>=vTopN/Count(Author)</P><P></P><P>Now your variables is strongly conncected.</P><P>You should also play with min/max/step values in your sliders to get it work properly.</P><P>You could also add/change floor() function with slider step as <SPAN class="Italic">base parameter.</SPAN></P></BODY></HTML> Sun, 23 Sep 2012 15:54:21 GMT https://community.qlik.com/t5/QlikView/How-to-connect-two-sliders/m-p/420670#M156594 whiteline 2012-09-23T15:54:21Z Re: How to connect two sliders https://community.qlik.com/t5/QlikView/How-to-connect-two-sliders/m-p/420671#M156595 <HTML><HEAD></HEAD><BODY><P>Perfect, that's proper way how to connect sliders, thank you! I did not know that variables can have triggers.. wow <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P></P><P>I will try to handle it, Thank You!</P></BODY></HTML> Sun, 23 Sep 2012 19:41:05 GMT https://community.qlik.com/t5/QlikView/How-to-connect-two-sliders/m-p/420671#M156595 2012-09-23T19:41:05Z