Put a measure value into a number variable

[paulcalvet]

Hello,

I try to retrieve a measure value and store it into a variable.

It works with a string variable but not with a number !

The output is always 0, I try to convert, replace space by "", multiply by one, etc.. 

Here is the log : in text it works

In number it doesn't work :

Please help I don't find the solution !

You can find attached the automation.

Regards,

Paul

[paulcalvet]

Yes @AfeefaTk  I need help, put a measure in a variable doesn't work if the measure is formated. I try many solutions but nothing works.

Regards,

Paul

[AfeefaTk]

Hi @paulcalvet 

I am not sure how to create a formatted measure value for a measure in the UI. I have added the value in the expression field, but the Get Measure Value doesn't return the value.

Do you have an example app that has formatted measure?

Regards

[paulcalvet]

hello @AfeefaTk, just set a format to the measure :

[AfeefaTk · Accepted solution]

Hi @paulcalvet 

So yes, I kind of got the issue and I can reproduce it.

I am not able to remove spaces using the existing formulas in QAA.

I tried with a custom code block to remove spaces in between the measure value, then set it as the value of the variable and it worked for me. 

I am not sure if there is any other easy solution to achieve this.

For now, let me share the automation workspace that worked with custom code block.

Please let me know your feedback.

Regards

Afeefa TK

[cotiso_hanganu]

Some 1.5 years ago, Qlik Support confirmed that for variables edited in interface, the change was not captured in Qlik Automation. After a while it seemed they solved this, but I understand it's not yet really mature...

[cotiso_hanganu]

Dual formated values can play tricks also to set analysis some times, so it's not quite a surprise the identified issue...
From the similar issues encountered in Set Analysis.... I would recommend to have dedicated variable that is behind the scene with formula connected to the front facing variable input, should be safer.

[paulcalvet]

Hello,

Thank you it works with your custom code.

Regards,

Paul