Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Sub Dealer Name | Active Count-22 |
Enterprises | 1 |
Vision Limited | Active |
Vision Punpun | 3 |
Electricals | 0 |
Hardware | 2 |
Sale | 6 |
Electronics | 7 |
Ganesh Enterprises | 5 |
Hi,
We need to show persistent colors in a Pixelperfect report (same color for same dimension value).
For example, we need "Dimension value A" color to be the same in both charts, pie chart and bar chart (and configure this color with RGB values if possible). Same with "Dimension value B". In both charts the dimension is the same (the bar chart have one more dimension for group by column)
Any ideas?
Thank you in advance.
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.
Wondering about Qlik Talend Data Integration Sessions? There are 11, in addition to all of the Data & Analytics. So meet us in Orlando, June 3 -5.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Join us on April 24th at 10 AM ET for the next Do More with Qlik webinar focusing on Qlik’s Data Integration & Quality solutions.
Your journey awaits! Join us by Logging in and let the adventure begin.
Qlik enables a frictionless migration to AWS cloud by Empresas SB, a group of Chilean health and beauty retail companies employing 10,000 people with 600 points of sale.
Qlik Luminary Stephanie Robinson of JBS USA, the US arm of the global food company employing 70,000 in the US, and over 270,000 people worldwide.
Join one of our Location and Language groups. Find one that suits you today!
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!