topic Re: How to set a Number Format in Block Create Or Update Measure ? in Qlik Automate

How to set a Number Format in Block Create Or Update Measure ?

isaiasdd — Mon, 28 Nov 2022 16:22:23 GMT

Hello!

I am trying use a block "Create or Update Measure" from Qlik Application Automation, to set a number format in my master measures from google worksheet, but I am not have success.

I try set "Number" and a format "#.##0" but when Qlik run a block, i receive a error "Method not found" and this errors on automation.

[ { "jsonrpc": "2.0", "id": 1, "error": { "code": -32601, "parameter": "GetLayout", "message": "Method not found" } } ]

How can I fill in this "Number formatting" field so that Qlik can create my measure with the formatted number?

Re: How to set a Number Format in Block Create Or Update Measure ?

AfeefaTk — Wed, 14 Dec 2022 08:35:36 GMT

Hi @isaiasdd

Sorry for the delay in response

We have extended the "Create or Update Measure" block to allow Number Formatting

For that please use the "Number Format" block to properly format the input to a JSON object and map it to the "Number Formatting" input field of the "Create or Update Measure" block

I am also attaching an automation JSON here which might help in figuring out how the "Number Format" block works along with the "Create or Update Measure" block

You can refer to this article to upload shared automation workspace into your tenant

Hope this helps

Thanks!

Afeefa TK

Re: How to set a Number Format in Block Create Or Update Measure ?

isaiasdd — Mon, 26 Dec 2022 16:09:01 GMT

Hi @AfeefaTk Thank for you response!

Re: How to set a Number Format in Block Create Or Update Measure ?

hanselalf — Tue, 14 Nov 2023 16:31:15 GMT

You have extended this Number Formating. But, when you later edit this master measure, you can't see, what you have set in the automation. So you don't know the number format of the master measure. Why so complicated format setting? Do this different options of Formating directly in the block "Create or Update Measure"!