Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 233,574 members
  • 4,431 online
  • 2,016,766 posts
  • 151,443 Solutions
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW

Welcome to Qlik Community

Recent Discussions

  • forum

    Integration, Extension & APIs

    Exporting app with data using OAuth in Qlik-CLI

    Hi everyone! I'm creating a script for export, import and publishing apps betweens tenants in Qlik Cloud using Qlik-CLI. As the first step I create a ... Show More

    Hi everyone!

    I'm creating a script for export, import and publishing apps betweens tenants in Qlik Cloud using Qlik-CLI. As the first step I create a context using following line:

    qlik context create test --server https://<TENANT NAME>.us.qlikcloud.com/ --api-key <API KEY>
    

    After that I log into that context with qlik context use test . After that I use following line for export app from a shared space from test tenant

    qlik app export <AppId> > <Pathfile>/AppName.qvf 

    It does export app with data

    Furthermore we should use OAuth client for multitenant managing. So we create context using --oauth-client-id and --oauth-client-secret flags for creating context. 

    However, using the last context with this authentication it's exporting app with No Data.

    What could be the issue?

    Note: I followed this tutorial for creating OAuth client credentials 
    https://qlik.dev/manage/platform-operations/authenticate-platform-ops/#how-to-create-a-region-level-oauth-client

    Thanks in advance.

    Show Less
  • forum

    Security & Governance

    Certificate not found AppPool credentials.

    Hi, I am getting this error when I tried to access my app via my web application. I installed the certificate on the web server. Any ideas? Thanks.
  • forum

    App Development

    Table cannot be filtered based on null values

    Hey there, I have a table in my app that contains a few dimensions and 3 measures. The 3 measures are: 1. Current Period - Represents the amount of mo... Show More

    Hey there,

    I have a table in my app that contains a few dimensions and 3 measures.

    The 3 measures are:

    1. Current Period - Represents the amount of money I currently have (based on period selection)

    2. Compared Period - Represents the amount of money I had in a selected period (also based on period selection, using a different variable than the one used in current period)

    3. Difference -  the calculation of money in my current period minus the money in the compared period

    Also, I have a variable that gets a number that is used as a threshold for amounts of money (we'll call it $Threshhold).

    I'm trying to filter rows from the table based on the next condition:

    If the absolute value of the difference between the periods is greater than $Threshold, then keep the value of it in the table, otherwise filter it.

    The problem is that I can't find a way to actually filter the values from the table, the become a null value instead.

    I tried many IF conditions and also tried using the limitation option in one of the dimensions, but to no avail.

    I would really appreciate if someone could help me with this.

    (And sorry I cant ease it with real examples).

    Thanks!

    Show Less
  • forum

    App Development

    Fractile function with direct query on Google BigQuery

    Hello,  I am using Qlik Cloud and leveraging a large dataset in BigQuery. I have setup up direct query successfully to start building analytics.  I am... Show More

    Hello, 

    I am using Qlik Cloud and leveraging a large dataset in BigQuery. I have setup up direct query successfully to start building analytics. 

    I am facing an issue with the Fractile function. I need to generate 99%, 99.9% quantiles and the direct query seems to only support basic aggregation functions.

    I have tried to define a Fractile measure. Qlik is accepting the expression and then generating SQL with the Fractile function in BigQuery. BigQuery computes quantiles thanks to different functions but Fractile() is not one of them. 

    The trick is that Fractile cannot be preaggregated. It needs to run on the full dataset.

    Is there a workaround I could apply?

    Thanks

    Show Less
  • forum

    App Development

    I wants to develop a sim registration app

    Hello everyone!! I am a newbie and have little info aboutapp development. I wants to develop sim registration app. Can I do so on the behalf of my kno... Show More

    Hello everyone!!

    I am a newbie and have little info aboutapp development. I wants to develop sim registration app. Can I do so on the behalf of my knowledge as a newbie. Or should I hire a freelance developer.

    If yes then tell me the quielties of the developer that are suitable to hire

    Show Less
  • forum

    Qlik Cloud Data Integration

    QVS File access using Must_Include from GCP Cloud bucket file not found issue

    Hi Community, We are using GCP Cloud bucket to access some of our QVS files using Must_Include but it is throwing an error as file not found. QVS file... Show More

    Hi Community,

    We are using GCP Cloud bucket to access some of our QVS files using Must_Include but it is throwing an error as file not found.

    QVS file is not supported from GCP Bucket?

    I am able to load using normal file load.

    I went through some of the community discussions like below

    Solved: Using QVS in Qlik Sense SaaS - Qlik Community - 1724164 still it is not working for me with provided solutions.

    @cotiso_hanganu @Levi_Turner

    Qlik Version : 

    skusuma1991_0-1728895294604.png

     

     

    Show Less
  • forum

    Connectivity & Data Prep

    Store data into QVD saves timestamp as NULL

    When extracting data from a MySQL table to a QVD file, most timestamp values are saved as NULL. It is a simple script: LIB CONNECT TO 'MySQL_MYDB (qs.... Show More

    When extracting data from a MySQL table to a QVD file, most timestamp values are saved as NULL.

    It is a simple script:

    LIB CONNECT TO 'MySQL_MYDB (qs.user)';
    
    LET vTabla = 'MY_TABLE';
    
    $(vTabla):
    SELECT *
    FROM my_schema.my_table;
    
    STORE $(vTabla) INTO [lib://DAT_MARIADB_MYDB_QVD (qliksense_user)/DAT_01_MARIADB_MYDB_$(vTabla).qvd] (QVD);
    DROP TABLE $(vTabla);

    When querying the database directly, there are no NULL or invalid values in the timestamp column. However, QVD metadata shows 95% NULLS (using QViewer):

    QVD_createdat.png

    As a result, every date related KPI is not reliable, since data is not consistent with the source.

    What can I do to prevent this?

    Show Less
  • forum

    Francophones

    Connexion CRM Sellsy

    Bonjour, J'essaye désespérément de récupérer certaines infos du CRM Sellsy grace à leur API (https://api.sellsy.com/doc/v2/) mais je bloque sur le fil... Show More

    Bonjour,

    J'essaye désespérément de récupérer certaines infos du CRM Sellsy grace à leur API (https://api.sellsy.com/doc/v2/) mais je bloque sur le filtrage des données !

    Dans ma requête, j'utilise la clause "With connection" suivante : 

    WITH CONNECTION (
    URL "https://api.sellsy.com/v2/activities/search",
    HTTPHEADER "Authorization" "Bearer $(vAuthorization)",
    BODY "$(vBody)"
    );

    vAuthorization, c'est le token que je récupére pour autoriser la connexion, aucun souci.

    Et vBody, c'est ca : 

    Let vBody ='{""filters"":""entities"":[""calendar_event""]}';

    Je precise que j'ai utilisé plusieurs modèles pour le vBody

    Exemple : '{[""filters"": {""entities"": [""calendar_event""]}]}';

    Et malgré ca, le filtre ne fonctionne pas du tout !

    Ca ne renvoi pas d'erreur, mais ca ne filtre pas !

    J'ai testé dans le requeteur Postman, et ca fonctionne très bien !

    En espérant que quelqu'un ai déjà utilisé ce type de connexion !

    Merci d'avance !

     

     

     

     

     

     

     

    Show Less
  • forum

    New to Qlik Analytics

    How to convert Numeric to date in data load editor

    Hi I have data loaded as NUM. It contains date. I want to convert it to date format so that I can load it into the datepicker. Here is my data:- I ha... Show More

    Hi I have data loaded as NUM. It contains date. I want to convert it to date format so that I can load it into the datepicker.

    Here is my data:-

    Screen Shot 2022-06-23 at 12.44.14 PM.png

    I have tried these in the data load editor:-

    Load

    Date((Floor(Timestamp#([stamp], 'YYYY-MM-DD hh:mm:ss') ))) AS [amidate];

    Date((Floor(Num#([stamp], 'YYYY-MM-DD hh:mm:ss') ))) AS [amidate];

     

    I have set my date and time to this:

    SET TimeFormat='h:mm:ss TT';
    SET DateFormat='M/D/YYYY';

     

    It still loads as Num. Can anyone suggest how to load it in Date?

     

    Show Less
  • forum

    App Development

    Qlik Sense

    Hello,   in QLik Sense, is it possible to select a Value in a Pivot Table?   Best Regards
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!