Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
isaiasdd
Creator
Creator

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

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?

Labels (1)
1 Solution

Accepted Solutions
AfeefaTk
Support
Support

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

 

View solution in original post

3 Replies
AfeefaTk
Support
Support

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

 

isaiasdd
Creator
Creator
Author

Hi @AfeefaTk Thank for you response!

hanselalf
Contributor II
Contributor II

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"!