topic Re: Can i convert a button into a text box?? in QlikView

Can i convert a button into a text box??

Anonymous — Thu, 23 Mar 2017 08:16:41 GMT

Hi people,

Can I convert a button into a text box?? If not possible, What is the easiest way to shift all the triggers and properties i have on a button to that of a text box.

Creating another text box and creating the triggers all over again is the solution i know but looking if there is a better option.

Please help.

Re: Can i convert a button into a text box??

sunny_talwar — Thu, 23 Mar 2017 09:03:58 GMT

I have done this for something simpler, but I have made direct changes to the XML files in the past.... but my expertise are limited with changing XML, but if you find yourself knowledgeable in playing around with XML files... you might be able to copy paste stuff and make some modifications to make it work

Re: Can i convert a button into a text box??

MarcoWedel — Thu, 23 Mar 2017 09:12:56 GMT

Why are you trying to convert it?

Re: Can i convert a button into a text box??

Anonymous — Thu, 23 Mar 2017 14:45:58 GMT

Sunny, Can you please explain the process?? where to find the xml files etc??

Re: Can i convert a button into a text box??

Anonymous — Thu, 23 Mar 2017 14:48:02 GMT

Previously I created buttons, Marco. I just want to show to bring the feel of a list box now. list of buttons as a list box and if selected highlighted in green etc. So looks like text boxes are looking near to list box than buttons. So just checking if there is simpler way

Re: Can i convert a button into a text box??

sunny_talwar — Thu, 23 Mar 2017 14:52:42 GMT

Check here how to create prj folder.... this folder includes all the xml files

QlikView Video Tutorial: Creating prj Folder in QlikView - QlikView Blog, QlikView Videos and Tips at QlikShare

Re: Can i convert a button into a text box??

Peter_Cammaert — Thu, 23 Mar 2017 14:58:52 GMT

You will probably spend more time tweaking the XML code than it would cost you to recreate the set of buttons as one or more text boxes. Escpecially the first time you try to do this directly in XML.

In QlikView, there is always an elevated cost involved if you invested in building a solution and then you change your mind. Indeed, that's a pity but cannot be avoided in many cases...

Re: Can i convert a button into a text box??

sunny_talwar — Thu, 23 Mar 2017 15:18:11 GMT

Agreed and disagreed.... There was this one time, I saved 2-3 hours + avoided any mistakes because I had to add a set analysis to 72 expressions in 6 charts which were conditionally hiding/showing.... Doesn't mean its always easy to do... but there might be a time when doing it in XML might make sense

Re: Can i convert a button into a text box??

flipside — Thu, 23 Mar 2017 15:41:11 GMT

If you can use macros, then just use this ...

Sub ButtonToText

ActiveDocument.GetSheetObject("BU01").Press
end Sub

.. calling the macro from an action on the text object.

Re: Can i convert a button into a text box??

Peter_Cammaert — Thu, 23 Mar 2017 15:50:41 GMT

Why didn't you use Search+Replace in the Expression Overview?

In this case, we're not talking about repeatedly modifying pre-existing expressions. These are series of objects that need to be transmogrified into different objects with different properties. The cost increase will be relative if you have a large number of comparable/identical modifications to perform and the modifications can be automated somehow. If not, it may be better to do this in QV Desktop.

On top of that, if you need anything more than Ctrl-C + Ctrl-V, you may get fewer errors in QV Desktop than in a text editor or xml tool.

Re: Can i convert a button into a text box??

sunny_talwar — Thu, 23 Mar 2017 16:14:47 GMT

Did try doing that, but for some reason had a lot of trouble because there were few charts with the same kind of expression which did not need the update, but the other ones did... looking at all the objects from Expression Overview was problematic... where as XML files are for each object and copy pasting was easier.... There might be more than this, but it did me save a lot of time

Re: Can i convert a button into a text box??

Peter_Cammaert — Thu, 23 Mar 2017 16:19:30 GMT

Did you have many variations in those 72 expressions? Or could they be roughly divided in a limited number of groups?

In the latter case, defining your expressions as variables could have been helpful. On condition that there are not too many $-sign substitutions and quoted string nestings...

Re: Can i convert a button into a text box??

sunny_talwar — Thu, 23 Mar 2017 16:21:19 GMT

Hahahaha you are right.... didn't think of variable with parameters at that time... but have changed jobs since then...