Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 235,723 members
  • 3,944 online
  • 2,019,414 posts
  • 151,685 Solutions
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!

Welcome to Qlik Community

Recent Discussions

  • forum

    Connectivity & Data Prep

    POST REST Connection works in Postman but not in Qlik

    This seems to be a very common question with very little successful responses.  I am attempting to pull ticket data from our OneDesk Environment so th... Show More

    This seems to be a very common question with very little successful responses. 

    I am attempting to pull ticket data from our OneDesk Environment so that I can build a dashboard. I am able to successfully connect using a GET REST connection to pull the information for a specific ticket ID, but I am unable to pull a list of IDs using the POST / filter method proposed by OneDesk. The POST call works just fine in Postman, but of course, I am met with a "Bad Request" error when attempting in Qlik SaaS.

    Please view below screenshots to view the FAILED attempt to pull the list of all IDs. I have included the SUCCESSFUL attempt in Postman as the first image.

    The syntax for the body was derived from a community article I found marked as an answer to a similar query:

    https://community.qlik.com/t5/App-Development/REST-connection-x-www-form-urlencoded/td-p/2085774

    It states that you can:

    format the request as PowerShell - RestMethod in Postman and then simply Copy Paste the $body content in Qlik.

    ADicamillo_0-1730822398035.png

     

    FAILURE_2 - QlikAttempt.png

    FAILURE_3 - QlikAttempt.png

    FAILURE_4 - QlikAttempt.png

    FAILURE_5 - QlikAttempt.png

    FAILURE_6 - QlikAttempt.png

    FAILURE_7 - QlikAttempt.png

    Please let me know if there is any additional information I can provide.

    Show Less
  • forum

    Qlik Replicate

    Tasks fail abnormally after access error about metricsLog.txt

    Hi Support,   We're seeing an issue where shortly after a task starts, there's an error with the message: "The Statistics Log cannot open the file D:\... Show More

    Hi Support,

     

    We're seeing an issue where shortly after a task starts, there's an error with the message: "The Statistics Log cannot open the file D:\Attunity\Replicate\data\logs\metrics\metricsLog.txt. Error: Access is denied.". Just after this error message appears, the task fails and the GUI console reports that the task has stopped abnormally.

    I'd just like to understand if anyone else has seen this before? And if so, how they were able to resolve it. Any assistance/insight would be greatly appreciated

    The Replicate version is v2023.5.0.413

     

    Thanks,

    Nak

    Show Less
  • forum

    App Development

    Shopify API, Orders Limit, Help With Pagination

    Hello,Similar to a post here: https://community.qlik.com/t5/New-to-Qlik-Sense/REST-connection-api-limit/m-p/2038360#M224175We've added our REST to the... Show More

    Hello,

    Similar to a post here: https://community.qlik.com/t5/New-to-Qlik-Sense/REST-connection-api-limit/m-p/2038360#M224175

    We've added our REST to the shopify URL using the below method

     

     

    https://xxx.myshopify.com/admin/api/2023-10/orders.json?status=any&fields=name,number,order_number,created_at,total_price,total_discounts,total_tax,cancelled_at,contact_email,currency,current_subtotal_price,current_total_discounts,current_total_price,current_total_tax,order_status_url,total_line_items_price,billing_address,customer,line_items

     

     

    With a header of 'X-Shopify-Access-Token' being set and our token.

    However, the API is limited by shopify and it only pulls back 250 records. If you have more than 250 orders, which we have, we need to paginate to pull all orders through.
    ---
    Using Postman, we can achieve this as in the response headers we get;

    Key = Link
    Value =
    "<https://xxxxxx.myshopify.com/admin/api/2023-10/orders.json?fields=name%2Cnumber%2Corder_number%2Ccreated_at%2Ctotal_price%2Ctotal_discounts%2Ctotal_tax%2Ccancelled_at%2Ccontact_email%2Ccurrency%2Ccurrent_subtotal_price%2Ccurrent_total_discounts%2Ccurrent_total_price%2Ccurrent_total_tax%2Corder_status_url%2Ctotal_line_items_price%2Cbilling_address%2Ccustomer%2Cline_items&page_info=eyJzdGF0dXMiOiJhbnkiLCJsYXN0X2lkIjo1NTMzMTIwNzU4MDY4LCJsYXN0X3ZhbHVlIjoiMjAyMy0xMC0xOSAxMToxMzowNy4xMTQyMjUiLCJkaXJlY3Rpb24iOiJuZXh0In0 >; rel="next""


    So we would use that URL in the Link value and it would pull the remaining orders.

    We are struggling on how we can acheive this through the Qlik Sense Data Connector?

    We've tried setting up Pagination Type has 'Next URL' with 'Link' in the 'Next URL Path' and the other methods.

    Are we missing something?

    Show Less
  • forum

    App Development

    Count number of times a field appears in a table

    I am trying to create a field in a table where each row shows the total number of times a record appears in a table. every count formula i can think o... Show More

    I am trying to create a field in a table where each row shows the total number of times a record appears in a table.

    every count formula i can think of and try is giving me a value of 1 and not it's total. 

    I can do this in EXCEL by saying countif(A:A, Criteria). How do i do that in QLIK?

    jalanhart_0-1730928054672.png

     

    Show Less
  • forum

    App Development

    App generating Databricks Direct Query SQL with unquoted selection value

    I have configured a Qlik Cloud application to query a Databricks cloud database using "Direct Query" and a custom SQL statement.  I've simplified my a... Show More

    I have configured a Qlik Cloud application to query a Databricks cloud database using "Direct Query" and a custom SQL statement.  I've simplified my application down to a single SQL statement and a single table. When the app loads, it uses my SQL statement to fetch the first batch of data, and it is successfully displayed in the table.  When I make a selection on the table, the application generates the SQL to filter the table using the selection.  Unfortunately, the SQL is not being generated properly and I get an error dialog.

    tgrant_0-1730927458385.png 

    Direct Query mode error: SQL Adaptor error: Connector error: ERROR [42703] [Qlik][Hardy] (80) 
    Syntax or semantic analysis error thrown in server while executing query.
    Error message from server: org.apache.hive.service.cli.HiveSQLException: Error running query:
    [UNRESOLVED_COLUMN.WITH_SUGGESTION] org.apache.spark.sql.catalyst.ExtendedAnalysisException:
    [UNRESOLVED_COLUMN.WITH_SUGGESTION] A column, variable, or function parameter with name `DDG70`.

    In Databricks, I can see the SQL that was generated and submitted.  The SQL includes a WHERE clause with "IN (DDG70)" that should be "IN ('DDG70')".

    tgrant_1-1730928272036.png

    I've simplified the App to just the custom SQL and table to show the issue.

    tgrant_2-1730928609691.png

    Is there a work around or fix for this?  For the complicated case, I need to use custom SQL. 

     

    Show Less
  • forum

    New to Qlik Analytics

    Changing Qlik Sense - Oracle AWS RDS Port and Implementing SSL

    Hi Qlik Experts, We are planning to update our existing Qlik Sense - Oracle AWS RDS connection by changing the port from 1521 to 2484 and implementing... Show More

    Hi Qlik Experts,

    We are planning to update our existing Qlik Sense - Oracle AWS RDS connection by changing the port from 1521 to 2484 and implementing SSL.

    Currently, our Qlik Sense - Oracle AWS RDS connection uses port 1521 without SSL.

    Could you please provide documentation or steps for making these changes, including SSL implementation?

    Thank you!

    R

    Show Less
  • forum

    GeoAnalytics

    What is the best practise for handling of geo files generated by qlik?

    Hi,How do I handle the qlik auto generated files countryAliases.qvd and countryGeo.qvd when I publish apps or copy apps to a new space? They seem to o... Show More

    Hi,

    How do I handle the qlik auto generated files countryAliases.qvd and countryGeo.qvd when I publish apps or copy apps to a new space? 

    They seem to only(?) be generated when the data manager is executed/preparing the data and not on reload. Thus when the app is outside the shared development space it produces an error because it can't find the files or don't have access or similar.

    Kind regards
    Johan

    Show Less
  • forum

    Security & Governance

    No 'publish' option in bookmarks for certain users

    Hi, I've been a couple hours trying to fix this. This should be simple, not so **bleep** hidden or whatever... First of all. Where is the QMC? Every t... Show More

    Hi,

    I've been a couple hours trying to fix this. This should be simple, not so **bleep** hidden or whatever...

    First of all. Where is the QMC? Every topic about this subject has mentioned the QMC, but it seems to not exist in the currently SaaS version.

    Basically, I have an app inside a >shared space<. I'm the tenant user, etc, so I do have available the option to publish bookmarks, but for some reason, analyzer users can only create bookmarks, not publish.

    I went to to the "Administration" menu (supposely the new QMC) and tweaked the permissions in the "spaces" tab. Also went through the "users" tab, but I can't seem to find anything related to "can publish".

    This guide says I need to set "can edit" under the app settings. I've set every "cans" and still no option to publish:

    https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Share/make-public-or-private.htm

     

    Users just want to be able to see each others bookmarks. Why is this so complicated? Moreover, if Qlik's gonna update their SaaS webpage design so frequently, at least update your documentations in time, so we don't feel stupid looking for something that is no longer available or has changed.

     

    Does anyone know how to fix this?

    Show Less
  • forum

    Qlik Replicate

    Qlik Replicate Encouter a Critical issues with Compressed tables after Oracle Ju...

    I have Qlik Replicate version  May 2023 (2023.5.0.771).  I see the early builds version 2023.11 and 2024. Which one should I apply?  Please advise.  Show More

    I have Qlik Replicate version  May 2023 (2023.5.0.771). 

    I see the early builds version 2023.11 and 2024. Which one should I apply? 

    Please advise. 

    Show Less
  • forum

    App Development

    Any way to alternate color rows in a pivot table that has a row level dimenstion...

    I have an app with a pivot table that each row is basically it's own specific measure. Currently we set the background color for every other row which... Show More

    I have an app with a pivot table that each row is basically it's own specific measure. Currently we set the background color for every other row which is tedious but works. But then if we want to use show if conditions for some rows that can break the manual every other row alternating color. Because each row is its own unique measure each row has a dimensionality of 0 and a RowNo of 1 so I don't think I can use either of those as a base. Are there any other options I am unaware of?

    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!