topic Re: QlikView Sheet Object Properties in QlikView

QlikView Sheet Object Properties

Sat, 07 Dec 2013 01:10:09 GMT

I've seen several examples of setting sheet object properties using macros. The only problem is I don't know where to find a list of the properties of the objects. The QlikVIew API guide only shows the GetProperties member. Where can I find out what these properties actually are?

Thank you!

Re: QlikView Sheet Object Properties

afurtado — Sat, 07 Dec 2013 11:49:57 GMT

Hi John.

Could you write what do you want to set (sheet and objects)?

Is not possible with triggers?

Alessandro Furtado

Re: QlikView Sheet Object Properties

Gysbert_Wassenaar — Sat, 07 Dec 2013 11:55:47 GMT

If you have the same api guide qvw file that I have then you can find the information on the Automation Members tab. First select Sheet in the QV Object listbox. Then click on the ISheetProperties item in the Select Class from Parameter/Property Type listbox. You can then see the list of properties in the table All members + Parameters.

Re: QlikView Sheet Object Properties

Mon, 09 Dec 2013 03:36:44 GMT

On the Automation Members tab I select Straight Table from the QV Object list box then I select GetProperties from the Member list box. Where are the properties for the GetProperties member listed?

Re: QlikView Sheet Object Properties

Mon, 09 Dec 2013 03:40:34 GMT

Specifically I'm trying to turn off and on the Preserve Scroll Position on a Straight Table using a trigger and code but am also interested in knowing how to find all of the properties for any/all controls.

Re: QlikView Sheet Object Properties

Tue, 10 Dec 2013 19:08:34 GMT

Thanks Gysbert! While looking through the properties, I didn't see anything related to preserving scrolling on Straight Tables. Do you know if this property exists and if so, where I can find it?

Re: QlikView Sheet Object Properties

Fri, 29 Apr 2016 18:09:55 GMT

I have written a program to get Text field from a qlik view chart from an application and copy it to word document. Suppose the text field has name Alex. It copies the word successfully Alex to word. Now i want to save Alex(Text field in string) How to do that?

case 6: //text
   QVObject.GetSheet().Activate();
   ReportControl.QVApp.WaitForIdle();

   if (objectName == "TX01")
   {
   Console.WriteLine("I have found my fullname again");
   // copy text field in global object tamp_val ----> error here
tamp_val = QVObject.CopyTextToClipboard();
   Console.WriteLine(" this is my object type" + tamp_val);
   // QVObject.CopyTextToClipboard();
   }

   QVObject.CopyTextToClipboard();
   Console.WriteLine("Found TX item: {0}", objectName);
   //pasteToWord(item);

   break;