Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 219,436 members
  • 6,673 online
  • 1,998,354 posts
  • 149,825 Solutions
Announcements
Qlik Community Office Hours - Bring your Ideation questions- May 15th, 11 AM ET: REGISTER NOW

Welcome to Qlik Community

Recent Discussions

  • forum

    Integration, Extension & APIs

    Trigger Qlik Sense Task from .Net SDK

    Hi  I am trying to trigger to Qlik Sense task from c# .net code. Is there any sample code or any useful links which can help me get started?   Many th... Show More

    Hi 

    I am trying to trigger to Qlik Sense task from c# .net code. Is there any sample code or any useful links which can help me get started?

     

    Many thanks

    Show Less
  • forum

    New to Qlik Analytics

    Mutiplication in Qlik

    I have two fields like  Order Quantity and Net price Net price in Decimal so I want to include Decimals also. If I use Round Or Floor or Ciel I will m... Show More

    I have two fields like 

    Order Quantity and Net price Net price in Decimal so I want to include Decimals also. If I use Round Or Floor or Ciel I will miss or Get More Spend.

     

    Output should be like This

    OrderId Order Quantity Net Price GC T PO Sub Total ( order qty * Net Price GCT)  
    101 500 6.04 3020  
    101 100 14.39 1439  
             
          2.9B  
             

     

    Show Less
  • forum

    New to Qlik Analytics

    Getting error in executing script

    Hi ,   Could someone help me rectify the error in following script(Attached screenshot). Getting error 'ValueCategoryGlobal' and 'ProcessTypeGlobal' n... Show More

    Hi ,

     

    Could someone help me rectify the error in following script(Attached screenshot).

    Getting error 'ValueCategoryGlobal' and 'ProcessTypeGlobal' not found. Though these fields are present in residents tables Valuecategory and ProcessType respectively.

    I am expecting Fields Value, ValueCategoryGlobal and ProcessTypeGlobal in temp table. But only field coming is Value.

    Beginner_Qlik1_5-1715684786843.png

    Beginner_Qlik1_6-1715684903949.png

     

     

     

     

    Beginner_Qlik1_0-1715684525831.png

    Beginner_Qlik1_1-1715684576145.png

     

    Beginner_Qlik1_4-1715684724578.png

     

     

    Beginner_Qlik1_3-1715684624001.png

     

    Show Less
  • forum

    App Development

    Restrict/filter out rows in a table (Qliksense) based on the condition

    Hi Guys,What is the best way to filter out rows in the Qliksense table. e.g. I need to have data only for active employees. In qlikview, we can create... Show More

    Hi Guys,

    What is the best way to filter out rows in the Qliksense table. e.g. I need to have data only for active employees. In qlikview, we can create a dummy measure (sum({<active={'Y'}>}1)) and we can hide this dummy column. This works in qlikview. But Qliksense, If we hide the dummy measure, corresponding filter also vanishes.

    Please tell me how can we restrict/filter rows in Qliksense table.

    Note: I have only dimensions in the table and no extra columns should appear in the dashboard.

    Show Less
  • forum

    Qlik Cloud Data Integration

    Learning Cloud - Emmanuel Katto

    Hi All, I am Emmanuel Katto from Uganda. Now living in UK. I am doing AWS cloud certification and learning various tools. Can someone please tell me h... Show More

    Hi All, I am Emmanuel Katto from Uganda. Now living in UK. I am doing AWS cloud certification and learning various tools. Can someone please tell me how can I utilize the Qlik Cloud with AWS?

     

    Thanks in advance!

    Emmanuel Katto

    Show Less
  • forum

    Qlik Replicate

    [Driver Manager]Can't open lib 'PostgreSQL' : file not found

    Hi All, We are migrating the server from RHEL 7 to RHEL 8. We have a PostgreSQL target.  From new box, RHEL 8, we are able to connect via command line... Show More

    Hi All,
     
    We are migrating the server from RHEL 7 to RHEL 8. 
    We have a PostgreSQL target. 
     
    From new box, RHEL 8, we are able to connect via command line to PostgreSQL but while trying to test connection from the Qlik UI, we are getting the below error:
     

    Cannot connect to ODBC provider
    RetCode: SQL_ERROR SqlState: 01000 NativeError: 0 Message: [unixODBC][Driver Manager]Can't open lib 'PostgreSQL' : file not found

     

    Below is the o/p of site_arep_login.sh and /etc/odbcinst.ini. With same settings, it was connecting in RHEL 7.

    [root@**]# cat site_arep_login.sh
    # enter site specific settings here
    #export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/u01/app/oracle/product/193000/client_1/lib/
    export NLS_LANG='ENGLISH_UNITED KINGDOM.AL32UTF8'
    export ORACLE_HOME=/u01/app/oracle/product/193000/client_1/
    export TNS_ADMIN=/u01/app/oracle/product/193000/client_1/network/admin/tnsnames.ora
    export LD_LIBRARY_PATH=/usr/lib:/usr/lib64:/usr/pgsql-14/lib:/opt/snowflake_odbc/lib:/u01/app/oracle/product/193000/client_1/lib/:$LD_LIBRARY_PATH



    [root@**]# cat /etc/odbcinst.ini
    # Driver from the postgresql-odbc package
    # Setup from the unixODBC package

    PostgreSQL]
    Description = PostgreSQL ODBC driver
    Driver = /usr/pgsql-14/lib/psqlodbc.so
    Setup = /usr/pgsql-14/lib/psqlodbcw.so
    Debug = 0
    CommLog = 1
    UsageCount = 2

    [SnowflakeDSIIDriver]
    APILevel=1
    ConnectFunctions=YYY
    Description=Snowflake DSII
    Driver=/opt/snowflake_odbc/lib/libSnowflake.so
    DriverODBCVer=03.52
    SQLLevel=1

    Show Less
  • forum

    Qlik NPrinting

    Destinations values of email don't retain in Webconsole

    Hello Qlik Community, In testing the latest version of Qlik NPrinting : February 2024 SR1 (does not appear yet in product labels) , I tumbled on an is... Show More

    Hello Qlik Community,

    In testing the latest version of Qlik NPrinting : February 2024 SR1 (does not appear yet in product labels) , I tumbled on an issue.

    For the tasks (even for those which already send email) in the email configuration, the destinations emails don't retain.

    QGTFS_0-1715682361535.png

    After looking around, I've noticed the same issue with the Settings\Task options under Notifications.

    I've noticed also this info bubble:

    QGTFS_1-1715682509937.png

    Which stays active even though the System URLs have been configured.

    The Email settings are configured and work to send test email, even for the task which were already configured before the update (although they don't show their value in console).

    Now changing the email causes no change in "Cancel" / "Update" buttons, they stay greyed out as if there was no modifications. And modifying other elements like the Body of an email, or ticking another option, often un-grey only the Cancel button but not the update.

    I've also tried to restart the services in vain.

    Does someone has a clue of what is happening ? It seems that the link between the task and email form the previous version still works, but somehow is not available anymore. Can someone help me find the missing link ? 

    Show Less
  • forum

    New to Qlik Analytics

    Stumped on Merging to Tables with Start and End Rows

    Hi All I have two tables.  One from the QlikSense Logs which denotes the start and end of a session and one from our front end web application that tr... Show More

    Hi All

    I have two tables.  One from the QlikSense Logs which denotes the start and end of a session and one from our front end web application that tracks the users movement through our analytics app.

    What Im trying to do is map the flow through our site - but first I need to 'combine' these two table to insert the 'Open' and 'Close' records in the correct places in the Pages table. 

    I hope this image describes what Im after :

    Screenshot 2023-11-21 at 15.56.47.png

     

    On the left is the table that denotes the Start and End of the sessions (Open & Close) by user and Timestamp

    On the right is the table that shows the flow of the User through our app timestamp.  The initial starting place for all sessions is Home_Page but unfortunately users can go back there at any point during the session (eg, 07/08/2023).  

    What Id ideally like to get to is this :

    Screenshot 2023-11-21 at 16.00.58.png


    I have no idea of how to tackle this so any suggestions really very appreciated! 

    Many thanks

    Dai

     

    Show Less
  • forum

    Insight Advisor

    Qlik for embedded analytics?

    I searched far and wide but found nothing. I know how most people feel about Qlik, but what about using it for embedded analytics? I'm interested in: ... Show More

    I searched far and wide but found nothing. I know how most people feel about Qlik, but what about using it for embedded analytics? I'm interested in:

    - how easy it is to embed (into an app, I need a real-time dashboard)

    - what the UX is like for the end-user - does it load quickly, play well with the rest of the app, glitch out, etc.

    - how much it costs and how it's priced (consumption-based per query, flat fee, etc.)

    - how it compares to similar embedded intelligence apps, e.g. ThoughtSpot

    Thanks a bunch!

    Show Less
  • forum

    New to Qlik Analytics

    KPI doesn't calculate correctly the last year when I choose quarter-year

      I created variable vLastyear with this expression: =year(max(Date))-1. I created a KPI : sum( {<Year={'$(vLastYear)'}>} margin) and it gives me... Show More
     

    I created variable vLastyear with this expression: =year(max(Date))-1.
    I created a KPI :

    sum( {<Year={'$(vLastYear)'}>} margin) and it gives me 0 as an output of the margin when I select Q1-2019 even though it recognized it in the ok statement as sum( {<Year={'2018'}>} margin) when I have data for the year 2018.. why it gives me 0 as an output in qlik sense when the selected period is Q1-2019

    hadari_0-1715673921840.pnghadari_1-1715673980439.png

     

    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!