Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 215,430 members
  • 2,577 online
  • 1,991,806 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

    QlikView Connectivity

    REST connector Twitter and Facebook ads campaigns

    Hi there,I installed the REST connector in Qlikview last week. My aim is to connect to private campaigns my company is running from both Facebook and ... Show More

    Hi there,

    I installed the REST connector in Qlikview last week. My aim is to connect to private campaigns my company is running from both Facebook and Twitter in order to import the marketing data therein. An example follows, showing how a row of these reports look like if I'd download it manually from twitter ads:

    example_rest_qlikcomm.PNG


    The problem comes after install REST connector and test it I cannot find any table that takes the crucial fields I want to retrieve, namely, campaign_id, campaign, time, spend.

    I would much appreciate if anyone could explain me how to retrieve those fields from twitter ads, if possible. If this cannot be done with REST but someone found and overcame same problem I am open to hear any alternative way to do so.

    Thanks in advance for your help,

    Sergi

    Show Less
  • forum

    App Development

    Help with MoM % expression (Month-over-Month growth percentage)

    Hello! I would like help with a code about MoM %, percentage of growth compared to the previous month. In this case, my code is this one, but it didn'... Show More

    Hello! I would like help with a code about MoM %, percentage of growth compared to the previous month. In this case, my code is this one, but it didn't bring me any result. I believe the problem is in the date code itself. Thank you in advance.

    Sum({<ds_estrutura = {"Ativos"}, ds_tipo = {"QUADRO_INDICADOR"},dt_calendario = {"$(=Date(dt_calendario))"}>} vl_indicador)
    /
    Sum({<ds_estrutura = {"Ativos"}, ds_tipo = {"QUADRO_INDICADOR"},dt_calendario = {"$(=Date(AddMonths(dt_calendario, -1)))"}>} vl_indicador) - 1

    joaognoatto_0-1711678907136.png

    joaognoatto_1-1711679226305.png

    Show Less
  • forum

    New to Qlik Analytics

    Formation of a variable.

    I have a table in which there is a column called date, and based upon this column I want two variables one which shows all the previous data, when we ... Show More

    I have a table in which there is a column called date, and based upon this column I want two variables one which shows all the previous data, when we select a date and the other all the after data including the selected date data.

    I want all the data date wise, for example if we select today's date then all the data previous and all the data after it.

    Show Less
  • 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
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!