Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
technoobs
Contributor
Contributor

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

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

Labels (3)
1 Solution

Accepted Solutions
Øystein_Kolsrud
Employee
Employee

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

View solution in original post

1 Reply
Øystein_Kolsrud
Employee
Employee

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