Retrieve Measure Value through .NET SDK using EvaluateEx Method and Powershell

technoobs — Fri, 13 Dec 2024 11:08:30 GMT

Hi,

I was trying to get the value of my measure expression ("num(count({<calYear = {2024}>}distinct Lead_Nr),'#.##0')") using .NET SDK and EvaluateEx method with powershell. I followed this post https://community.qlik.com/t5/Integration-Extension-APIs/edit-script-load-editor-with-net-SDK/td-p/1755324 and successfully connect to the App.

But when I executed following script to get the result from the measure expression, got this return:
Text IsNumeric Number
---- --------- ------
Error: All expressions disabled False NaN

This is the script I executed:
#Get the QEApp
$QEApp = [Qlik.Engine.LocationExtensions]::App($Location,$AppIdentifiersByID,$Session,$NoData)
$Expression = "num(count({<calYear = {2024}>}distinct Lead_Nr),'#.##0')"

$EvaluationResult = $QEApp.EvaluateEx($Expression)
$EvaluationResult

Can someone help me to solve this issue?

Thanks in advance

Re: Retrieve Measure Value through .NET SDK using EvaluateEx Method and Powershell

Øystein_Kolsrud — Mon, 16 Dec 2024 07:48:42 GMT

Perhaps you've accidentally set the "NoData" argument to 'true' when you open the app? I get that error when I do so.

topic Retrieve Measure Value through .NET SDK using EvaluateEx Method and Powershell in Integration, Extension & APIs

Retrieve Measure Value through .NET SDK using EvaluateEx Method and Powershell

Re: Retrieve Measure Value through .NET SDK using EvaluateEx Method and Powershell