topic Re: Put a measure value into a number variable in Qlik Automate

Put a measure value into a number variable

paulcalvet — Fri, 19 Jan 2024 13:58:19 GMT

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

Re: Put a measure value into a number variable

rubenmarin — Sat, 20 Jan 2024 07:28:04 GMT

Hi, it looks like the measure has 2 numbers separated by an space, maybe that's the cause it can only interpreted as a string.

I've tested the automation with the ctrl+00 script and it works

Re: Put a measure value into a number variable

paulcalvet — Mon, 22 Jan 2024 08:42:46 GMT

Yes, it's certainly the format number.

But when I try to convert it or to remove space from string, it doesn't work.

I will try it with a measure without format, but It's a bad workaround to duplicate measure.

Re: Put a measure value into a number variable

rubenmarin — Mon, 22 Jan 2024 15:36:58 GMT

Hi, I tested but I didn't know either how to remove spaces in the text using the automation, but instead of duplicating the full expression you can create another expression that just removes spaces from the original measure, like creating a Non_space_Measure that has the expression:

PurgeChar(Original_Expression_Name, ' ')

At least if you change the expression formula you only need to update the original.

Or wait for someone with more knowledge than me about how to do the same in automations.

Re: Put a measure value into a number variable

marcus_sommer — Tue, 23 Jan 2024 12:16:43 GMT

Formatting is useful for a human viewing but on a programmatic process it's the opposite of helpful ...

Re: Put a measure value into a number variable

paulcalvet — Fri, 26 Jan 2024 10:56:01 GMT

In this use case, I work in managed space so I can't create new measure, and I'm not in favour duplicate objects to manage number formating 🙂

Maybe a moderator can help ?

@Jeffrey_Goldberg do you know how we can use a measure in automation when this measure have a format ? in my case, the result is understood as a string.

Regards,

Paul

Re: Put a measure value into a number variable

AfeefaTk — Mon, 05 Feb 2024 04:58:15 GMT

Hi @rubenmarin

@paulcalvet

Could you please let me know what exactly you are trying to achieve here?

Regards

Re: Put a measure value into a number variable

rubenmarin — Mon, 05 Feb 2024 07:07:03 GMT

Hi @AfeefaTk it looks like theree is a variable with a number stored using an empty space as thousand separator, probably this causes to be readed as two diffrent values, which returns null(), and the possible solution would be to add an step in automation that removes the space or interprets the space as thousand separator so the value can be readed as a number.

Re: Put a measure value into a number variable

AfeefaTk — Mon, 05 Feb 2024 07:10:59 GMT

Hi @rubenmarin

So you have a solution using automation?
Its working for you?

Or do you need any help here?

Regards

Re: Put a measure value into a number variable

rubenmarin — Mon, 05 Feb 2024 07:14:13 GMT

Hi @AfeefaTk, thanks for your quick answer... I was just summaryzing the thread. @paulcalvet is the one that needs the solution. Let's wait to confirm if @paulcalvet has a solution or still needs help.

Re: Put a measure value into a number variable

paulcalvet — Mon, 05 Feb 2024 08:32:40 GMT

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

Re: Put a measure value into a number variable

AfeefaTk — Tue, 06 Feb 2024 07:27:40 GMT

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

Re: Put a measure value into a number variable

paulcalvet — Tue, 06 Feb 2024 08:00:52 GMT

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

Re: Put a measure value into a number variable

AfeefaTk — Tue, 06 Feb 2024 10:02:43 GMT

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

Re: Put a measure value into a number variable

cotiso_hanganu — Wed, 07 Feb 2024 08:17:49 GMT

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...

Re: Put a measure value into a number variable

cotiso_hanganu — Wed, 07 Feb 2024 08:21:13 GMT

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.

Re: Put a measure value into a number variable

paulcalvet — Thu, 08 Feb 2024 13:47:42 GMT

Hello,

Thank you it works with your custom code.

Regards,

Paul