Hi Team,

I have this below code to get the task list from QEM. 

# Define the URL for the API call
$url = "https://computer.network.net/attunityenterprisemanager/api/v1/servers/myrepsrv1/tasks"

# Prepare the headers for the API call, specifically the session ID
$headers = @{
"EnterpriseManager.APISessionID" = "wCo0_KvjEUFROvfHF5KGrw"
}

# Make the HTTP GET request and ignore SSL certificate validation errors
try {
$response = Invoke-WebRequest -Uri $url -Headers $headers -Method Get -SkipCertificateCheck

# Check if the request was successful (status code 200)
if ($response.StatusCode -eq 200) {
Write-Output "Tasks retrieved successfully:"
Write-Output $response.Content # Print the response content which includes the task list
} else {
Write-Output "Failed to retrieve tasks, status code: $($response.StatusCode)"
}
} catch {
Write-Output "An error occurred: $_"
}

how to find Session ID of QEM? Pls suggest.. Also I need last week task list using the same.

thanks

Vish123

Dear all

We have successfully upgraded PostgreSQL with 14 version.

Everything running fine but only one thing I have noticed about the postgres service user running this service

 By default "Log On showing as" network service, is it normal ? or do we need to change its user as service account user running all other qliksense services?

I have been trying to create a report using the excel tabular reporting, that creates a new sheet for each Sales Person. To do this I have been trying to use the pages option.

It appears that this works fine for the straight table that is used for the report (i.e. it creates a sheet for each sales person with a straight table on it and the data filtered for each sales person).

However, I need the chart to be shown as a pivot table and if I use the pages option on the pivot table it doesn't seem to work? I end up with a sheet created for each Sales Person (i.e. the tab of the sheet is named correctly for each sales person) but the data within each sheet is not filtered to each Sales Person, all sheets created show the same data on the pivot table which is for the first Sales Person only. 

Can someone advise if what I am attempting to do is actually possible? 

Thanks. 

HI ,

Please refer the below Snap shot . I need the help to calculate 'Active' Count from the expression field.

Can anybody solve this problem.

I am trying to connect to google BQ I am successfully able to create ODBC connection but not from qlikreplicate getting this error

SYS-E-HTTPFAIL, Cannot connect to ODBC provider.
SYS,GENERAL_EXCEPTION,Cannot connect to ODBC provider,RetCode: SQL_ERROR SqlState: 08001 NativeError: 10380 Message: [Simba][ODBC] (10380) Unable to establish connection with data source. Missing settings: {[KeyFilePath_Enc]}
 

Hello,

I have used filter panes in one of my sheet in qliksense. One of the filters is to select Gender. The filed name in my data source is Gender and it has rows for F (as female) and M( as male). Previously, I had this expression behind my filter 
if(Gender='F','Female',if(Gender='M','Male')). it works fine.

Now user wants that every time they open the sheet it filters out the report automatically or by default to Male. and later, if they need then change and select the Female option in the filter.

I have set this variable in the main section in data load editor SET vDefaultFilter='Male', and modify the expression like this: if(Gender='F','Female','$(vDefaultFilter)')

the expression says ok but it does not filter data by default to Male. I still need to go and select Male option.

could someone help please?

Thank you!

I have multiple qvds uploaded in my data load editor with each qvd containing a few datapoints that have similar data but different column names. I created aliases for each to join each other but that created multiple synthetic keys. I want to join these tables so that these common fields can become filters on the dahboard. I can not concatenate the tables since the names are not the same in each table. Adding an example of data below. 

Table 1: 
Load
ProductName
Sales
Cost
Projects
City
From[Source]

Table 2:
Load
Products
Profit
Cost
SKU
ProjectName
CityName

Table3: 
Product
PersonID
PersonName
CityEnName
Project

The filters that I want to create are Product Names, Project Names & City Name. 
Please suggest how. I also tried creating joins but creating multiple joins for more than 20 tables doesn't work either.