Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 234,801 members
  • 3,892 online
  • 2,018,274 posts
  • 151,585 Solutions
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!

Welcome to Qlik Community

Recent Discussions

  • forum

    Installing and Upgrading

    How to not override the file

    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 ex... Show More

    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?

    Show Less
  • forum

    Qlik Application Automation

    Issues with QMS API - ShutdownDistributionService

    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... Show More

    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:

    johanelopak_0-1728981490650.png

    Ports on the firewall are open for 4799

     

    Show Less
  • forum

    Integration, Extension & APIs

    Issues with QMS API - ShutdownDistributionService

    (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 distributi... Show More

    (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:

    johanelopak_0-1729017141275.png

     

    Ports on the firewall are open for 4799

    Show Less
  • forum

    New to Qlik Analytics

    Adding null values to bar chart and pivot table

    Hi, I'm having problem with null values representation on bar chart and pivot table.  Load editor: LOAD * INLINE[Date, Quantity, Group2024.10.20, 3, A... Show More

    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:

    __Ruta_1-1729858622189.png

    Thank you! 🙂

     

     

    Show Less
  • forum

    App Development

    Custom Layout & Template

    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 ... Show More

    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!

    Show Less
  • forum

    Qlik Application Automation

    Apply action on Button with Variable Input

    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 p... Show More

    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.

    Show Less
  • forum

    Deployment & Management

    What authentication method is best for Form + Captcha?

    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 N... Show More

    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?

    Show Less
  • forum

    Move to SaaS

    SFTP Connection

    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... Show More

    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".

    Show Less
  • forum

    Move to SaaS

    Bulk bookmark deletion in Qlik sense enterprise edition

    Hi All, Is there a way to filter and delete the  bulk bookmarks owned by developers using admin access,   Regards, Raju
  • forum

    Move to SaaS

    Quickly utilize the natural language functionality available in Qlik SaaS

    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... Show More

    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. 

    Show Less
X
Leaderboard

Customer Story

Accelerating Decision-Making with Qlik Insights

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.

Customer Story

Efficiency in Agriculture: Nortera's Qlik Triumph

Nortera leads agricultural manufacturing analytics and automation with Qlik, reducing short-shipment rates and annual savings in water consumption.

Customer Story

Revolutionizing aircraft production through Data Analytics

Qlik Data Integration transforms Airbus' aircraft production, leading to over 150 replication tasks and informing more efficient analysis.

Location and Language Groups

Choose a Group

Join one of our Location and Language groups. Find one that suits you today!

Collaborate

Healthcare User Group

Healthcare User Group

A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..

All are welcome

Japan Group

Japan

Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。

Request to join

Brasil Group

Brazil

Welcome to the group for Brazil users. .All discussions will be in Portuguese.

open to all

Blogs

Community News

Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!