Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 216,920 members
  • 7,966 online
  • 1,994,300 posts
  • 149,438 Solutions
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW

Welcome to Qlik Community

Recent Discussions

  • forum

    New to Qlik Analytics

    How to give access to users at certain stream in Qlik Sense Enterprise?

    hi, i found an old guide about this topic but the links are broken now, it's missing the 'Add ticket' link.does anybody know if there is a new guide? ... Show More

    hi, i found an old guide about this topic but the links are broken now, it's missing the 'Add ticket' link.
    does anybody know if there is a new guide?

    Thanks
    Edoardo

    GUIDE: https://help.qlik.com/en-US/sense/1.1/Subsystems/ManagementConsole/Content/ServerUserGuide/SUG_ConfiguringSecurity_Environment_AccessControl_UserAttributes_Example1.htm?_ga=2.22500539.1290480764.1713276169-1521824740.1713276168

    Show Less
  • forum

    Qlik Enterprise Manager

    How to configure Qlik after installing Qlik via QPI tool

    Hi,   On a new server I used the Qlik PostgreSQL Installer (QPI) tool to install a new PostgreSQL 14.8 database. Then I installed Qlik Sense Enterpris... Show More

    Hi,

     

    On a new server I used the Qlik PostgreSQL Installer (QPI) tool to install a new PostgreSQL 14.8 database. Then I installed Qlik Sense Enterprise February 2024 release. All went well and all services are started

    Then when I want to access the QMC or HUB via the browser, it returns a default error that the page cannot be reached. Which steps do I have to take now?

    When I use the QlikSenseUtil.exe in the C:\Program Files\Qlik\Sense\Repository\Util\QlikSenseUtil folder and check the connection, it only displays that port 4432 can be reached. What about 80 and 443? Probably I'm missing some steps after installing Qlik Sense enterprise.

     

    Show Less
  • forum

    New to Qlik Analytics

    Writing expressions - Counts and nulls

    First - is there a good place to learn the qlik expression language that anyone particularly enjoys? I'm trying to use ChatGPT and not finding it terr... Show More

    First - is there a good place to learn the qlik expression language that anyone particularly enjoys? I'm trying to use ChatGPT and not finding it terribly helpful.

     

    My main question is out of this dataset that I have attached, the request is to calculate the:

    Count of Consent Date, where Consent Date is not Blank, the Inactive field does not equal YES, and the Delivery Date IS blank.

    How could I structure this? I've tried multiple ways and keep getting 0's. It looks like any blanks are being populated with "-" when I look in Data Manager, and I've tried to update formulas accordingly but still not having success.

     

    Show Less
  • forum

    New to Qlik Analytics

    How to concatenate 2 tables

    Hi, I try to concatenate these 2 tables and the fields from the budget one (.xlsx) results in nulls as you can see in the image attatched, where I kno... Show More

    Hi,

    I try to concatenate these 2 tables and the fields from the budget one (.xlsx) results in nulls as you can see in the image attatched, where I know there are values. Is there something wrong? 

    Many thanks!!!

    This is the code: 

    LIB CONNECT TO 'Amazon_Redshift_redshift-dwh.cwafb1bxivm3.eu-west-1.redshift.amazonaws.com';
    budget:
    LOAD
        "Código del evento" as event_code,
        event_end_time as budget_event_end_time,
        timestamp(FECHA) AS budget_date,
        "NUMERO DE TICKETS" as budget_quantity,
        PRECIO as budget_price,
        "BOOKING FEE" as budget_fee,
        "GROSS REVENUE" as budget_gross_revenue,
        round(num(Interval(event_end_time - timestamp(FECHA), 'DD'))/7,2) AS weeks_left_to_event
    FROM [lib://DataFiles/Ticketing 2024.xlsx]
    (ooxml, embedded labels, table is [Hoja 3]);
     
    concatenate (budget)
     
    LOAD "event_id",
        "event_name",
        "event_country",
        "event_date",
        capacity,
        "event_code",
        "ticket_id",
        "cashless_paid_credits",
        quantity,
        "ticket_type",
        "sold_date",
        "ticket_date",
        "ticket_category",
        status,
        "event_currency",
        "gbp_rate",
        "eur_rate",
        "base_amount",
        "fee_amount",
        "total_amount",
        email,
        "customer_country",
        city,
        age,
        gender,
        "age_group",
        "year_event",
        "month_event",
        "days_left_to_event",
        "weeks_left_to_event",
        "months_left_to_event",
        babb,
        "previous_event_code",
        "event_end_time",
        "event_to_compare",
        "previous_day_sales",
        "marketing_total_spend",
        cpa;
        
     
    SELECT 
     
    "event_id",
    "event_name",
    "event_country",
    "event_date",
    capacity,
    "event_code",
    "ticket_id",
    "cashless_paid_credits",
    quantity,
    "ticket_type",
    "sold_date",
    "ticket_date",
    "ticket_category",
    status,
    "event_currency",
    "gbp_rate",
    "eur_rate",
    "base_amount",
    "fee_amount",
    "total_amount",
    email,
    "customer_country",
    city,
    age,
    gender,
    "age_group",
    "year_event",
    "month_event",
    "days_left_to_event",
    "weeks_left_to_event",
    "months_left_to_event",
    babb,
    "previous_event_code",
    "event_end_time",
    "event_to_compare",
    "previous_day_sales",
    "marketing_total_spend",
    cpa
    FROM "dbt_xavi_marts"."marts_event_ticketing";
     
     
     
    Show Less
  • forum

    App Development

    Affichage conditionnel des onglets entre 2 conteneurs

    Bonjour, On a 2 conteneurs : le premier conteneur contient des graphiques sous forme de synthèse et le deuxième conteneur des tableaux simples et/ou c... Show More

    Bonjour,

    On a 2 conteneurs : le premier conteneur contient des graphiques sous forme de synthèse et le deuxième conteneur des tableaux simples et/ou croisés dynamiques sous forme de détail. 

    Est-il possible de faire en sorte par exemple si on clique sur l'onglet Synthèse A dans le conteneur 1  on a automatiquement l'onglet Détails A qui s'affiche au niveau du conteneur 2; si on clique sur l'onglet Synthèse B dans le conteneur 1 on a automatiquement l'onglet Détails B qui s'affiche au niveau du conteneur 2 ainsi de suite ? Sachant qu'on les mêmes dimensions et mesures entre les composants des 2 conteurs (par exemple les dimensions et mesures de "Synthèse A" sont les mêmes que ceux de "Détails A" ... c'est juste qu'on a plus d'informations dans les onglets Détails ... que dans les onglets Synthèse ... (cf. capture d'écran ci-dessous) :

    Y aurait-il des cas similaires qui ont été remontés dans ce forum ou des méthodologies à suivre dans Qliksense qui pourront nous aider à traiter cette question ?

    1.PNG

    Merci par avance,

    Cordialement, 

    ------------------------------------------------------------------------------------------------------------------------------------------------------

    Hello,

    We have 2 containers: the first container contains graphics in summary form and the second container contains simple and/or pivot tables in detailed form.

    Is it possible to ensure that, for example, if we click on the Synthèse A tab in container 1, we automatically have the Détails A tab displayed at container 2; if we click on the Synthèse B tab in container 1 we automatically have the Détails B tab which is displayed at container 2 and so on? Knowing that we have the same dimensions and measurements between the components of the 2 storytellers (for example the dimensions and measurements of Synthèse A are the same as those of Détails A ... it's just that we have more information in the Détails ... tabs and in the Synthèse ... tabs (see screenshot below) 

    1.PNGAre there similar cases that have been reported in this forum or methodologies to follow in Qliksense that can help us address this issue?

     

    Thanks in advance,

    Best regards

    Show Less
  • forum

    App Development

    Issues with Qlik Variable Input object.

    Hello, We have been successfully using the old Variable object that I believe we obtained from Qlik Branch/Garden/Sandbox quite some time ago. We rece... Show More

    Hello,

    We have been successfully using the old Variable object that I believe we obtained from Qlik Branch/Garden/Sandbox quite some time ago. We recently decided to replace instances of that object with the Variable Input object found in the Qlik Dashboard Bundle on the assumption that this one is "officially supported" by Qlik and that would be safer to use in the long run. 

    However, we have discovered that in "button" mode, some of our button labels are being truncated where they weren't with the old variable object. Also, in "input box" mode, the right side of the input box extends beyond the edge of the object; again, this didn't happen with the old variable object. 

    Is anyone else experiencing these issues? 

    Show Less
  • forum

    New to Qlik Analytics

    Remove null concatenation in pivot table

    Hi, I am new to qlik,I have a pivot table with the dimensions group and subgroup.the group field is a concatenation of group number and the group name... Show More

    Hi, I am new to qlik,
    I have a pivot table with the dimensions group and subgroup.
    the group field is a concatenation of group number and the group name (Num_Group & '- '& Group) and the Subgroup field has the same logic
    ( (Num_Subgroup & '- '& Subgroup)).
    The problem is that I get a null concatenation in the filter panel.
    in my dimension I was putting this expression: if(isnull(Group_concat or Group_concat='-'), Group_concat), but it still doesn't remove the null concatenation from the filter...
    Can you help me, please.

     

    azucna122_0-1713263074424.png

     

    Show Less
  • forum

    New to Qlik Analytics

    Default filter

    Hello, I have used filter panes in one of my sheet in qliksense. One of the filters is to select Gender. The filed name in my data source is Gender an... Show More

    Hello,

    I have used filter panes in one of my sheet in qliksense. One of the filters is to select Gender. The filed name in my data source is Gender and it has rows for F (as female) and M( as male). Previously, I had this expression behind my filter 
    if(Gender='F','Female',if(Gender='M','Male')). it works fine.

    Now user wants that every time they open the sheet it filters out the report automatically or by default to Male. and later, if they need then change and select the Female option in the filter.

    I have set this variable in the main section in data load editor SET vDefaultFilter='Male', and modify the expression like this: if(Gender='F','Female','$(vDefaultFilter)')

    the expression says ok but it does not filter data by default to Male. I still need to go and select Male option.

    could someone help please?

    Thank you!

    Show Less
  • forum

    Qlik Application Automation

    Qlik Entiltement Analyzer, looking for a field like Last Usage

    Hello Qlik community,I need a field where I can see when a user last used Qlik. Is this field included in my data model or do I need to calculate it m... Show More

    Hello Qlik community,
    I need a field where I can see when a user last used Qlik. Is this field included in my data model or do I need to calculate it myself?Screenshot 2024-04-16 134005.pngScreenshot 2024-04-16 134041.png

    Show Less
  • forum

    New to Qlik Analytics

    CORS error for import-map.json

    I am getting this kind of error while importing file:5500/:1 Access to fetch at 'http://localhost:4848/resources/qmfe/import-map.json' from origin 'ht... Show More

    I am getting this kind of error while importing file

    :5500/:1 Access to fetch at 'http://localhost:4848/resources/qmfe/import-map.json' from origin 'http://127.0.0.1:5500' has been blocked by CORS policy: No 'Access-Control-Allow-Origin' header is present on the requested resource. If an opaque response serves your needs, set the request's mode to 'no-cors' to fetch the resource with CORS disabled.

     

    I am using pure JS and HTML to work with , is there any suggestions for me?

    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!