topic Re: Macro selecting one value in one sheet and activating chart with expressions with second sheet in QlikView https://community.qlik.com/t5/QlikView/Macro-selecting-one-value-in-one-sheet-and-activating-chart-with/m-p/919864#M318782 <HTML><HEAD></HEAD><BODY><P>You set with "1" a string-value, try it without the quotes.</P><P></P><P>- Marcus</P></BODY></HTML> Wed, 29 Jul 2015 15:40:52 GMT marcus_sommer 2015-07-29T15:40:52Z Macro selecting one value in one sheet and activating chart with expressions with second sheet https://community.qlik.com/t5/QlikView/Macro-selecting-one-value-in-one-sheet-and-activating-chart-with/m-p/919863#M318781 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I'm new here and have a problem with my macro:</P><P></P><P>// First of all, i'm giving the value throw the input box and select other sheet in my application</P><P>Sub ChooseValue</P><P>Set q = ActiveDocument</P><P>q.ClearAll (false)</P><P>Set f = q.Fields("Obiekt CO_nr")&nbsp;&nbsp; </P><P>x = inputbox ("Enter product")</P><P>f.Select(x)</P><P>set s = q.Sheets("Analizator Typów Sprzedaży")</P><P>s.Activate</P><P></P><P>//now i have a problem:</P><P></P><P>I&nbsp; want to run chart with ID "CH171" with this selected value but chart is activating only when button "Wn" is choosed (please see the image attached) - so only if condition (vWn and vPor_okresow=0) is fullfilled.</P><P></P><P>vWn = -SubStringCount (concat (PrzekrojeID,'|'),1)*(GetSelectedCount(Przekroje)&gt;0)</P><P></P><P>vPor_okresow=0</P><P></P><P>How can i activate the chart? How can i enforce chart to show this one specific value?</P><P></P><P>I have already tried to use code below:</P><P></P><P>set v = ActiveDocument.Variables("vWn")</P><P>v.SetContent "1",true</P><P></P><P>But it doesnt work...</P><P></P><P>Thank you all for your support.</P><P>Best Regards</P><P>Jacek Antek</P></BODY></HTML> Wed, 29 Jul 2015 11:35:23 GMT https://community.qlik.com/t5/QlikView/Macro-selecting-one-value-in-one-sheet-and-activating-chart-with/m-p/919863#M318781 Anonymous 2015-07-29T11:35:23Z Re: Macro selecting one value in one sheet and activating chart with expressions with second sheet https://community.qlik.com/t5/QlikView/Macro-selecting-one-value-in-one-sheet-and-activating-chart-with/m-p/919864#M318782 <HTML><HEAD></HEAD><BODY><P>You set with "1" a string-value, try it without the quotes.</P><P></P><P>- Marcus</P></BODY></HTML> Wed, 29 Jul 2015 15:40:52 GMT https://community.qlik.com/t5/QlikView/Macro-selecting-one-value-in-one-sheet-and-activating-chart-with/m-p/919864#M318782 marcus_sommer 2015-07-29T15:40:52Z Re: Macro selecting one value in one sheet and activating chart with expressions with second sheet https://community.qlik.com/t5/QlikView/Macro-selecting-one-value-in-one-sheet-and-activating-chart-with/m-p/919865#M318783 <HTML><HEAD></HEAD><BODY><P>Hi Marcus,</P><P></P><P>thank you for your answer!</P><P></P><P>I did this, problem was... different alternative state on the second sheet and macro couldnt work around this.</P><P></P><P>Best Regards,</P><P>Jacek Antek.</P></BODY></HTML> Thu, 30 Jul 2015 08:15:56 GMT https://community.qlik.com/t5/QlikView/Macro-selecting-one-value-in-one-sheet-and-activating-chart-with/m-p/919865#M318783 Anonymous 2015-07-30T08:15:56Z