Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a folder with a group of xml files I am using talend to transform these files into excel files I want to check if the file is transformed to excel before then skip it Note that the excel and xml files are in the same folder. What should i do?
Hi All,
We are trying to prepare our server for patching with a scheduled job to shutdown our distribution service gracefully.
I’ve spend a lot of time in the code, but I keep getting the error: Invoke-WebRequest : The remote server returned an error: (401) Unauthorized.
I’m able to get the service statuses etc. with the API, but I can’t stop it.
The PowerShell code is as following
## URL for the QMS API endpoint
$url = "http://127.0.0.1:4799/QMS/Service "
$service = New-WebServiceProxy -Uri $url -Namespace QlikViewServer -UseDefaultCredential
$serviceKey = $service.GetTimeLimitedServiceKey()
$hdrs = @{}
$hdrs.Add("SOAPACTION","http://ws.qliktech.com/QMS/12/2/IQMS2/GetServices ")
$hdrs.Add("Content-Type", "text/xml;charset=utf-8")
$hdrs.Add('X-Service-Key',$serviceKey)
$body = @{}
$body = '<s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/ ">
<s:Body>
<GetServices xmlns="http://ws.qliktech.com/QMS/12/2/ ">
<serviceTypes>All</serviceTypes>
</GetServices>
</s:Body>
</s:Envelope>'
Write-Output $hdrs
$res = Invoke-WebRequest -Uri $url -Method POST -Body $body -UseDefaultCredential -Headers $hdrs
[xml]$qdsServices = $res
$qdsService = $qdsServices.Envelope.Body.GetServicesResponse.GetServicesResult.ServiceInfo
$serviceName = "DSC@xxxxxxxx" #adjusttoservername
$service = $qdsservice | Where-Object { $_.Name -eq $serviceName }
$serviceId = $service.Id
$serviceAddress = $service.Address
$service = New-WebServiceProxy -Uri $url -Namespace QlikViewServer -UseDefaultCredential
$serviceKey = $service.GetTimeLimitedServiceKey()
$body = @{}
$body = '
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/ " xmlns:qms="http://schemas.qliktech.com/QMS/12/ ">
<soapenv:Header/>
<soapenv:Body>
<qms:ShutdownDistributionService>
<qms:serviceKey>'+$serviceKey+'</qms:serviceKey>
<qms:qdsID>'+$serviceId+'</qms:qdsID>
<qms:nodeID>'+'00000000-0000-0000-0000-000000000000'+'</qms:nodeID>
<qms:address>'+$serviceAddress+'</qms:address>
</qms:ShutdownDistributionService>
</soapenv:Body>
</soapenv:Envelope>'
Write-Output $hdrs2
Write-Output $body
Write-Output $serviceId
$res2 = Invoke-WebRequest -Uri $Url -Method Post -Headers $hdrs2 -Body $Body
$res2.Content
Does anyone know how I can get around the 401 authorization error?
Invoke-WebRequest : The remote server returned an error: (401) Unauthorized.
At C:\Users\XXXX\Desktop\Almost.ps1:57 char:9
+ $res2 = Invoke-WebRequest -Uri $Url -Method Post -Headers $hdrs2 -Bod ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidOperation: (System.Net.HttpWebRequest:HttpWebRequest) [Invoke-WebRequest], WebException
+ FullyQualifiedErrorId : WebCmdletWebResponseException,Microsoft.PowerShell.Commands.InvokeWebRequestCommand
We are running Qlikview 12.70.20100.0
Access:
Ports on the firewall are open for 4799
(I noticed it belongs more within this forum)
Hi All,
We are trying to prepare our server for patching with a scheduled job to shutdown our distribution service gracefully.
I’ve spend a lot of time in the code, but I keep getting the error: Invoke-WebRequest : The remote server returned an error: (401) Unauthorized.
I’m able to get the service statuses etc. with the API, but I can’t stop it.
The PowerShell code is as following
## URL for the QMS API endpoint
$url = "http://127.0.0.1:4799/QMS/Service "
$service = New-WebServiceProxy -Uri $url -Namespace QlikViewServer -UseDefaultCredential
$serviceKey = $service.GetTimeLimitedServiceKey()
$hdrs = @{}
$hdrs.Add("SOAPACTION","http://ws.qliktech.com/QMS/12/2/IQMS2/GetServices ")
$hdrs.Add("Content-Type", "text/xml;charset=utf-8")
$hdrs.Add('X-Service-Key',$serviceKey)
$body = @{}
$body = '<s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/ ">
<s:Body>
<GetServices xmlns="http://ws.qliktech.com/QMS/12/2/ ">
<serviceTypes>All</serviceTypes>
</GetServices>
</s:Body>
</s:Envelope>'
Write-Output $hdrs
$res = Invoke-WebRequest -Uri $url -Method POST -Body $body -UseDefaultCredential -Headers $hdrs
[xml]$qdsServices = $res
$qdsService = $qdsServices.Envelope.Body.GetServicesResponse.GetServicesResult.ServiceInfo
$serviceName = "DSC@xxxxxxxx" #adjusttoservername
$service = $qdsservice | Where-Object { $_.Name -eq $serviceName }
$serviceId = $service.Id
$serviceAddress = $service.Address
$service = New-WebServiceProxy -Uri $url -Namespace QlikViewServer -UseDefaultCredential
$serviceKey = $service.GetTimeLimitedServiceKey()
$body = @{}
$body = '
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/ " xmlns:qms="http://schemas.qliktech.com/QMS/12/ ">
<soapenv:Header/>
<soapenv:Body>
<qms:ShutdownDistributionService>
<qms:serviceKey>'+$serviceKey+'</qms:serviceKey>
<qms:qdsID>'+$serviceId+'</qms:qdsID>
<qms:nodeID>'+'00000000-0000-0000-0000-000000000000'+'</qms:nodeID>
<qms:address>'+$serviceAddress+'</qms:address>
</qms:ShutdownDistributionService>
</soapenv:Body>
</soapenv:Envelope>'
Write-Output $hdrs2
Write-Output $body
Write-Output $serviceId
$res2 = Invoke-WebRequest -Uri $Url -Method Post -Headers $hdrs2 -Body $Body
$res2.Content
Does anyone know how I can get around the 401 authorization error?
Invoke-WebRequest : The remote server returned an error: (401) Unauthorized.
At C:\Users\XXXX\Desktop\Almost.ps1:57 char:9
+ $res2 = Invoke-WebRequest -Uri $Url -Method Post -Headers $hdrs2 -Bod ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidOperation: (System.Net.HttpWebRequest:HttpWebRequest) [Invoke-WebRequest], WebException
+ FullyQualifiedErrorId : WebCmdletWebResponseException,Microsoft.PowerShell.Commands.InvokeWebRequestCommand
We are running Qlikview 12.70.20100.0
Access:
Ports on the firewall are open for 4799
Hi,
I'm having problem with null values representation on bar chart and pivot table.
Load editor:
LOAD * INLINE
[Date, Quantity, Group
2024.10.20, 3, A
2024.10.21, 1, B
2024.10.23, 5, B
2024.10.25, 4, A
];
Datos:
LOAD * INLINE
[Date
2024.10.20
2024.10.21
2024.10.22
2024.10.23
2024.10.24
2024.10.25
];
For example, when I choose one of groups, I wanna see quantities during date period. So, if there is a day with zero quantity, i want to see that days too (in bar chart, in pivot). I already tried with adding SUM({1} 0) to measure, but then it shows all the dates, regardless of chosen dates interval.
As in example below, I want to see only outlined in red:
Thank you! 🙂
Hi all,
are there any ideas, best practice, articles etc out there on how to create a template app, which can be used for every new app that needs to be built ? Background: We have custom colors for fonts, charts, custom navigation panels etc which we dont want to set everytime we build a new app. Is it as simple as create one app with everything that we want and then simply copy this app for every new app that we create ?
Thanks for some ideas!
Hello,
I have defined a variable : vPercentPerVendor
I have placed a variable input with Input Box (so i can choose % from 0 - 100 (0.0 - 1))
I have placed a button and added action. Action is select value in the field (Field is dimension Vendor) with following expression: count(DISTINCT sale_service_id) / count( Total DISTINCT sale_service_id) > $(vPercentOfTotalPerVendor).
Down below i have table with following fields: Vendor, Count (Distinct sale_service_id) and % of each Vendor in total count.
Idea is to represent vendors with 10 % or any higher % in relation to the total (which is 100 %).
I Attached SC.
Thank you in advance.
I am trying to implement a custom form login page that authenticates using username and password, as well as captcha validation. Currently I'm using Node.JS to implement. However, it seems like if I'm using ticket authentication, password isn't necessary as long as certificate is valid? I want to make sure only correct password will let the user login.
I want the flow to be:
1. User is redirected to authentication module
2. When user click login and captcha button, the captcha is first validated.
3. If captcha is valid, authenticate username and password
4. If authenticated, user is logged in and redirected to hub
How do I authenticate using username and password? What method is the best?
I have a new issue in Qlik Cloud; the connection to SFTP hasn’t been working for me lately. I can see the folder with the files, but when I select one of the files, it says: "Cannot open file".
I am looking to quickly utilize the natural language functionality available in Qlik SaaS. Could anyone point me to any threads or YouTube videos that provide a step-by-step guide on how to create a prompt in an application where I can ask questions in natural language about data in qlik sheet?
Thank you for your assistance!
Best regards,
Miguel.
Seamless Public Data Sharing with Qlik's New Anonymous Access Capability
Fuel your data and AI journey with the right services, delivered by our experts.
With Qlik Answers™, get personalized, GenAI-driven answers from unstructured data, so you can make decisions with confidence. Learn how in our product roadmap keynote and demo.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Your journey awaits! Join us by Logging in and let the adventure begin.
Qlik enhances decision-making with high-speed insights, as Mayborn Group integrates data from various functions across their global operations, gaining a competitive edge in the childcare industry.
Nortera leads agricultural manufacturing analytics and automation with Qlik, reducing short-shipment rates and annual savings in water consumption.
Qlik Data Integration transforms Airbus' aircraft production, leading to over 150 replication tasks and informing more efficient analysis.
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!