Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 215,427 members
  • 3,082 online
  • 1,991,802 posts
  • 149,214 Solutions
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

Welcome to Qlik Community

Recent Discussions

  • forum

    Catalog and Lineage

    Using set analysis to get a value of previous period

    Hi. I have a dataset with the fields: Account_id, account_score, year_quarter, YearQuarterKey (which is a running sequencial number for every year-qua... Show More

    Hi. I have a dataset with the fields: Account_id, account_score, year_quarter, YearQuarterKey (which is a running sequencial number for every year-quarter combination). I want to use set analysis in a table presentation on my app, and to add the field previous_quarter_score to every row ! in the table, according the field YearQuarterKey

    I tried:

    =max( {< YearQuarterKey = {"$(=(YearQuarterKey-1))"} >} account_score)

    It did not work.

    Any thoughts on how to accomplish this?

    Thanks

    Show Less
  • forum

    New to Qlik Analytics

    Plotting data points by time

    Hey, I'm brand new to Qlick and for the life of me can't figure out how to do the simplest thing. I've got a table of data representing measurements w... Show More

    Hey,

    I'm brand new to Qlick and for the life of me can't figure out how to do the simplest thing.

    I've got a table of data representing measurements with two columns: weight and date.

    All i want to do is plot these weight measurements on a chart with weight on the y axis and date on the x axis. no aggregation or anything - i have 100 measurements and I want them all plotted on the chart.

    Can someone help me figure out how to do this? I've tried a scatterplot but it seems to demand aggregation, and am having no luck with a line chart either.

     

    Thanks!

    Show Less
  • forum

    Qlik Replicate

    Qlik Replicate Certificate update

    We are trying to update Qlik replicate ssl certificate..In the installations steps we have app id ::{4dc3e181-e14b-4a21-b022-59fc669b0914} is this app... Show More

    We are trying to update Qlik replicate ssl certificate..
    In the installations steps we have app id ::{4dc3e181-e14b-4a21-b022-59fc669b0914} is this appid correct ?? 

    How can i verify this app id is correct on my windows machine before updating the certificates without any issue running the below command 


    netsh http add sslcert ipport=0.0.0.0:443 certhash=<certificate thumbprint> appid={4dc3e181-e14b-4a21-b022-59fc669b0914}

    Show Less
  • forum

    Qlik Reporting Service

    Export Stories with selection (in sheet action)

    HI i want to export my Stories to meeting i have about 30 sheets   If i and all product selecion direct in function works fine, export also.   but i w... Show More

    HI i want to export my Stories to meeting i have about 30 sheets

     

    If i and all product selecion direct in function works fine, export also.

     

    but i want to do it using Action to whole sheet  and put some value 

    export clear all and selection not exist in ppt

     

    how to do it?

     

    Show Less
  • forum

    App Development

    Story export to power point

    Hi all, Qlik sense was recently updated for a client and the users experience has become less positive due to the following: - The snapshot icon has d... Show More

    Hi all,

    Qlik sense was recently updated for a client and the users experience has become less positive due to the following:

    - The snapshot icon has disappeared from visualization upper righthand corner, that is you have to click on the meny for the visualization, choose snapshot and then choose take a snapshot, i.e. 2 clicks more than previously. Is there any setting to be changed locally to bring the snapshot icon back?

    - When taking a snapshot or exporting a story to powerpoint/pdf, the resulting default settings with regards to size depend on the users screen and zoom settings, i.e. upon exporting a wide and long table, sometimes there are columns and rows missing in the export. Is there a way to set the default size to adjust relative to the story in question, instead of the users screen settings?

     

    The version the client is using it Qlik Sense august 2021 Patch 1

     

    Show Less
  • forum

    Security & Governance

    Qlik Cloud: Generic SAML connector and Google Workspace

    Hi community,  I noticed that Qlik released a generic SAML IDP connector in Qlik Cloud Platform and I would like to use it for Google Workspace. I alr... Show More

    Hi community, 

    I noticed that Qlik released a generic SAML IDP connector in Qlik Cloud Platform and I would like to use it for Google Workspace. I already configured OIDC IDP for Google and it works good on Qlik Tenant, but Google doesn't return groups in the identity token in OIDC Version. By using SAML, I can retrieve groups. 

    I tried to configured it by creating a SAML application in Google Workspace but I don't know how to get the ACS URI.

    Here's how I configured the IDP

     

    Step 1: Getting IDP Metadata: I downloaded Meta Data to configure the IDP in Qlik Cloud. 

    Google Workspace IInformationGoogle Workspace IInformation

     

    Step 2: I tried to configure in Qlik CLoud by using IDP metadata file  and by providing manually the informations (I tested multiples combinaisons here's below one of combinaison I tried).

     

    Manual Configuration. (Configuration with metadata has been tested to)Manual Configuration. (Configuration with metadata has been tested to)

    Step 3: As I've no information to get any ACS URI, I tried to get it by creating the IDP without validating. And selecting my new SAML IDP Configuration > View provider configuration

    Error when I'm trying to get more informations about the IDP provider (to get the ACS URI)Error when I'm trying to get more informations about the IDP provider (to get the ACS URI) 

     Step 4: I blocked at this step because I've no clues where can I get the ACS URI to finish the IDP configuration

    How can I get the ACS URI in Qlik CloudHow can I get the ACS URI in Qlik Cloud

     

    Have anyone already configured Generic SAML IDP with Google Workspace in Qlik Cloud Product ? Is there a bug or a lack of informations that made I can't continue the configuration. I already opened a ticket and support tells me to ask to community for this kind question.

    Thank you 

    Best Regards

     

     

     

     

     

     

     

     

    Show Less
  • forum

    Qlik Application Automation

    "Do lookup" not working on Add a Chart to Report block

    hi, I am using Add a Chart to Report block and when I try to find the object using "do lookup". It doesnt find my object. The object is in a published... Show More

    hi,

    I am using Add a Chart to Report block and when I try to find the object using "do lookup". It doesnt find my object.

    The object is in a published sheet and I also got the object id using /options/developer mode.

    Any clue about that?

    Thanks in advance

    suggestion: maybe this block should first select the sheet and then do a lookup on the elements inside the selected sheet. Because there are lots os elements in the app, so the lookup takes too long

    Show Less
  • forum

    New to Qlik Analytics

    Does this code make sense?

    I'm an intern and I'm trying to determine whether a file was created today before 6.15 am or not. I'm using vfileexists as a counter. I have a Nprinti... Show More

    I'm an intern and I'm trying to determine whether a file was created today before 6.15 am or not. I'm using vfileexists as a counter. I have a Nprinting app through which I'm trying to shoot a mail if the condition is not satisfied. Any help is appreciated! Thanks!

    Show Less
  • forum

    Connectivity & Data Prep

    500 Internal Sever Error for SharePoint Metadata connector

    I am Trying  to connect SharePoint list to Qlik using Qlik's SharePoint Metadata connector.  As there are multiple view present in the SharePoint li... Show More
    I am Trying  to connect SharePoint list to Qlik using Qlik's SharePoint Metadata connector. 
    • As there are multiple view present in the SharePoint list, I want to retrieve data from particular view 
    • while  previewing data from a particular view, I am getting a "Internal Server error" with error code 500.
      subham_0-1708079261051.png

       

    • One possible reason might be number of columns as these two view have too  many columns(>50) and records(>20k), but I am able to retrieve data from other views where number of columns are significantly less.
    • I tried manually to retrieve 2 columns with 10 record using script but the error remains the same.
      subham_1-1708079261052.png

       

      I am not sure whether number of fields is an issue here, as the connector is not allowing to connect with the SharePoint list with particular view.
    Show Less
  • forum

    Qlik Replicate

    Replicate data from last 24 months

    Hello, My Source connection is an Oracle database. I have audit tables in my Replicate task "Full Load + Apply Changes" the tables are huge and by nat... Show More

    Hello,

    My Source connection is an Oracle database. I have audit tables in my Replicate task "Full Load + Apply Changes"

    the tables are huge and by nature there is heavy DML operations. 

    My target is Snowflake "Extra Small Size", I see significant amount of latency when i tried replicating audit tables. 

    Is there a way I can limit the date range to be at most 24 months of history data in the replicate task ?

     

    Thank you.

    Show Less
Leaderboard

Customer Story

Qlik Data Integration & Qlik Replicate story

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.

Customer Story

Building a Collaborative Analytics Space

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.

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!