topic Re: TextAlign property handling in Integration, Extension & APIs

TextAlign property handling

andreas-hellquist-stratsys — Wed, 15 Feb 2023 09:08:34 GMT

I am struggling with how to handle text alignment from my hypercube. On measureinfo property there is a TextAlign property but that property value is wrong. My QlikSense object is aligning "Right" and that property is "Left". I have found a workaround where I read the entire JObject and from that pick out the Representation property which in turn contains an IndicatorProps.Position property where alignment is the correct value "Right". This is definately not how it is supposed to be done but I cant come up with any other solution. Would be forever grateful if someone has a solution for this so I can remove my custom code for fetching such a trivial design property.

Attaching some screenshots on the data

Re: TextAlign property handling

alex_colombo — Mon, 20 Feb 2023 09:02:32 GMT

Hi @andreas-hellquist-stratsys , could you please share which engine api methods are you using for reading this information?
I tried to create a simple table and aligh measure values to the right. Getting the object and getting the layout I have text align property with "right" value. Below engine API methods used by me:

GetObject: I'm getting my table
GetLayout: I'm reading current layout for the object where I can find text align property

Re: TextAlign property handling

andreas-hellquist-stratsys — Mon, 20 Feb 2023 09:13:16 GMT

Hi @alex_colombo ,

Attached screenshot is how i fetch my object. I fetch GenericObject and not Object like you if that is where I go wrong?

Re: TextAlign property handling

alex_colombo — Mon, 20 Feb 2023 09:28:06 GMT

After you fetch an generic object, use GetLayout method for reading the current layout and properties for this object

Re: TextAlign property handling

andreas-hellquist-stratsys — Mon, 20 Feb 2023 09:42:16 GMT

genericObject.Layout.As<TableLayout>()

This isn't enough?

Re: TextAlign property handling

alex_colombo — Mon, 20 Feb 2023 09:52:16 GMT

It should be, I've never used it. Check the response and see if you have what you are looking for. For sure, you don't need to use GetHypercbueData method for getting measure properties

Re: TextAlign property handling

andreas-hellquist-stratsys — Mon, 20 Feb 2023 09:56:59 GMT

Well, that is my question. As can be seen in my original post it shows align=left but in representation data (not exposed in objects) it shows position right.

GetHypercbueData is because I need the data as well, nothing to do with layout.

Re: TextAlign property handling

alex_colombo — Mon, 20 Feb 2023 10:15:20 GMT

Ok, so please try to change to GetLayout instead of TableLayout. If this will not fix it, it could be a bug.
Could you please attach the Qlik app? I'd like to play with APIs and your table object in order to understand if it's a bug in .NET SDK or in Engine API.

Re: TextAlign property handling

andreas-hellquist-stratsys — Mon, 20 Feb 2023 10:27:41 GMT

There is unfortunately no difference when using GetLayout.

Attach the Qlik app? As an excel data export or do you want all credentials for the app? Not sure I can give you credentials, I am integrating to a client of ours.

Re: TextAlign property handling

alex_colombo — Mon, 20 Feb 2023 13:10:15 GMT

I mean if you can upload the Qlik Sense app (.qvf file)

Re: TextAlign property handling

andreas-hellquist-stratsys — Tue, 21 Feb 2023 14:21:54 GMT

Ok, sorry, never used the actual QlikSense UI, only integrated to it. But here is the .qvf file.

Re: TextAlign property handling

alex_colombo — Wed, 22 Feb 2023 08:35:37 GMT

Hi @andreas-hellquist-stratsys , thanks for sharing the app.

I made a couple of test and this is how product works. When Text Alignment property is set to "auto", default alignments will be applies. For text values alignment is on the left, for numbers and dates is on the right. Looking at the property with GatLayout method we will see

"textAlign": { "auto": true, "align": "left" }

This means that in this particular case, the align property is not considered by the product, because "auto" prop is set to true. Could make confusion here, but this is how it works. Align is set to true beucase is the default value. Indeed, when you switch off the auto prop in the UI you will see align left set as default. See below screenshot

If I force position to right, then in properties you will see align "right"

Then, here what we have in the GetLayout method

"textAlign": { "auto": false, "align": "right" }

Finally, when auto is set to true, you will know that text are on left and dates and numbers on right. When auto is set to false, then read align value.

Re: TextAlign property handling

andreas-hellquist-stratsys — Wed, 22 Feb 2023 08:40:39 GMT

Thank you very much for the great explanation! It was slightly confusing but now I know how to sort it out at least. Right now I just check for type of data in column and align by that.