Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I'm trying to connect SharePoint via Qlik Sense. Below steps i followed,
1. Creating a new data connection.
2. Choosing the data source "Office 365 Sharepoint"
3. Then given the base URL of Office 365 Sharepoint in the baseURL.
4. Then choose the "None" from Prompt/Consent level.
5. Click on Authenticate button. Then it will take to next tab and code generated. Then copied code and paste in the respective tab. Then clicked on the Authenticate tab.
6. After that taking some time and faced the error. Below is the error message,
"error verifying: A connection attempt failed because the connected party did not properly respond after a period of time or established connection failed because connected host has failed to respond "Some IP (1.1.1.1:443)"
kindly suggest
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!
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!