Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 158,524 members
  • 12,541 online
  • 1,709,475 posts
  • 128,376 Solutions
  • Announcements
    IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS

    Welcome to Qlik Community

    FOR NEW MEMBERS

    Everything you need to make your Qlik Community experience valuable.

    SEARCH KNOWLEDGE BASE

    Explore official Support and member created content.

    ASK PRODUCT QUESTIONS

    Submit questions to product experts and participate in conversations.

    Analytics

    Forums for Qlik Analytic solutions. Ask questions, join discussions, find solutions, and access documentation and resources.

    Data Integration

    Forums for Qlik Data Integration solutions. Ask questions, join discussions, find solutions, and access documentation and resources

    Qlik Gallery

    Share your best Qlik apps and discuss impacts with peers! Show your work and get recognized for innovative uses of Qlik technologies.

    Ideation

    Participate in Qlik Technical Previews, submit ideas, and review documentation.

    Support

    Chat with us, search Knowledge, open a Case, read the latest Updates Blog, find Release Notes, and learn about our Programs.

    Events

    Learn about upcoming Qlik related events, webinars and local meetups.

    Groups

    Join a Group that is right for you and get more out of your collaborations. Some groups are closed. Closed Groups require approval to view and participate.

    About

    Get started on Qlik Community, find How-To documents, and join general non-product related discussions.

    Blogs

    Hear directly from Qlik employees in our ten unique blogs.

    Qlik Resources

    Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.

    Qlik Academic Program

    Qlik gives qualified university students, educators, and researchers free Qlik software and resources to prepare students for the data-driven workplace.

    Community Sitemap

    Here you will find a list of all the Qlik Community forums.

    Recent Discussions

    • No Boards Found
    • forum

      New to Qlik Sense

      Where Clause on the below conditon

      Hi there, For the below table, I would like to add the where clause on the below condition to table attached below; My condition for where clause to e... Show More

      Hi there,

      For the below table, I would like to add the where clause on the below condition to table attached below;

      My condition for where clause to extract the table is:

      1st Condition: Product = 'Mobile' and Market = 'Openmarket

      2 nd Condition: Product =  'TV', 'Fan'  and Market = 'Closedmarket'.

      Table Name: Retail

      Date Products Market  Sales
      5/5/2022 Mobile Closed Market 202
      6/5/2022 Mobile Closed Market 93
      7/5/2022 Mobile Closed Market 182
      8/5/2022 Mobile Closed Market 78
      9/5/2022 Mobile Closed Market 105
      10/5/2022 Mobile Closed Market 89
      11/5/2022 Mobile Openmarket 207
      12/5/2022 Mobile Openmarket 190
      13/5/2022 Mobile Openmarket 75
      14/5/2022 Mobile Openmarket 166
      5/5/2022 TV Closed Market 156
      6/5/2022 TV Closed Market 115
      7/5/2022 TV Closed Market 169
      8/5/2022 TV Closed Market 60
      9/5/2022 TV Closed Market 165
      10/5/2022 TV Closed Market 158
      11/5/2022 TV Openmarket 166
      12/5/2022 TV Openmarket 183
      13/5/2022 TV Openmarket 78
      14/5/2022 TV Openmarket 166
      5/5/2022 Grinder Closed Market 162
      6/5/2022 Grinder Closed Market 78
      7/5/2022 Grinder Closed Market 132
      8/5/2022 Grinder Closed Market 142
      9/5/2022 Grinder Closed Market 128
      10/5/2022 Grinder Closed Market 191
      11/5/2022 Grinder Openmarket 103
      12/5/2022 Grinder Openmarket 193
      13/5/2022 Grinder Openmarket 187
      14/5/2022 Grinder Openmarket 167
      5/5/2022 Fan Closed Market 178
      6/5/2022 Fan Closed Market 203
      7/5/2022 Fan Closed Market 118
      8/5/2022 Fan Closed Market 197
      9/5/2022 Fan Closed Market 135
      10/5/2022 Fan Closed Market 68
      11/5/2022 Fan Openmarket 122
      12/5/2022 Fan Openmarket 67
      13/5/2022 Fan Openmarket 69
      14/5/2022 Fan Openmarket 142
      5/5/2022 Oven Closed Market 186
      6/5/2022 Oven Closed Market 168
      7/5/2022 Oven Closed Market 114
      8/5/2022 Oven Closed Market 146
      9/5/2022 Oven Closed Market 141
      10/5/2022 Oven Closed Market 90
      11/5/2022 Oven Openmarket 188
      12/5/2022 Oven Openmarket 175
      13/5/2022 Oven Openmarket 113
      14/5/2022 Oven Openmarket 170
      Show Less
    • forum

      QlikView App Dev

      INFO Load - doesn't render images in the tables

      Hi everyone, Hope this question was not posted here before - at least I couldn't find anything related.  So the problem is that we have a web app buil... Show More

      Hi everyone,

      Hope this question was not posted here before - at least I couldn't find anything related. 

      So the problem is that we have a web app build with QlikView, where we have couple of tables with photos. After we change the load method from BUNDLE to INFO, they stopped showing up. What is weird is that it works perfectly fine in sandbox environment and both environments are said to have the same settings.  What is also weird is that images that are put in text fields work just fine, so the problem seems to be only with tables. That's also not hardware related as server has more than 32GB of RAM.

      I will appreciate any help with this 🙂 Thanks

      Show Less
    • forum

      New to Qlik Sense

      Join tables with if condition

      Hi everyone, I have two tables: Table A: id_level_1 id_level_2 Info 64356   hdhd 64566   gdfg 27457 27457 shdghsy 37567 37567 dsdfg   578... Show More

      Hi everyone,

      I have two tables:

      Table A:

      id_level_1 id_level_2 Info
      64356   hdhd
      64566   gdfg
      27457 27457 shdghsy
      37567 37567 dsdfg
        57895 sdf
        95789 gadg
      656334   agfvsadgv

       

      Table B:

      id name
      64356 Adrian,Funke
      64566 Mike, Scholz
      27457 Alex, Kinder
      37567 Andre, Wolf
      57895 Lisa, Lunwig
      95789 Liukas, Linder

       

      I need to join the second table to the first table on 'id' and 'id_level_1'. If there no 'id' that matches 'id_level_1', then join on 'id_level_2'.

      My code:

      Table_1:
      LOAD id_level_1,
      id_level_2,
      Info
      FROM
      Table A;

      Table_2:
      LOAD
      id_level_2
      FROM
      Table A;

      left join(Table_1)
      load distinct
      id as id_level_1,
      name
      FROM
      Table B;

      if isnull(name) then
      left join(Table_2)
      load distinct
      id as id_level_2,
      name
      FROM
      Table B;
      ENDIF;

      The problem is that the date from the second join is just added to the end of the table and the right places are empty.

      olenroko_0-1656615367909.png

      So the expected result would be look like this:

      id_level_1 id_level_2 Info name
      27457 27457 shdghsy Alex, Kinder
      37567 37567 dsdfg Andre, Wolf
      64356   hdhd Adrian,Funke
      64566   gdfg Mike, Scholz
      656334   agfvsadgv  
        57895 sdf Lisa, Lunwig
        95789 gadg Liukas, Linder

      I would be really grateful for your help!

       

       

      Show Less
    • forum

      New to Qlik Sense

      App Fails to Reload in QMC

      Hello all,  I have an issues when I Try reloading data in the QMC, the task fails every time but I reload the same app in the HUB it reloads without a... Show More

      Hello all, 

      I have an issues when I Try reloading data in the QMC, the task fails every time but I reload the same app in the HUB it reloads without any issues.  The Data is been pulled from excel files that are dropped in a drop zone.

      Any help with this would be very helpful. 

      Show Less
    • forum

      New to Qlik Sense

      How do i display the value of the cell as per excel

      Hi, I have a cell format in H:MM:SS - This means the excel is displaying for example: 0 hours, 21 mins, 38 secs = 0:21:38 (This is how the excel cell ... Show More

      Hi,

      I have a cell format in H:MM:SS - This means the excel is displaying for example:

      0 hours, 21 mins, 38 secs = 0:21:38 (This is how the excel cell looks like)

      I  just want it to display as per the format in excel which is like this. However,  when i load this data and try to display it in qlikview, it shows: 0.0147916666666667

      May i know how to display my cell as per how its meant to be? Note: i do not want it to display HH:MM:SS (because i will not have 10 hours. I simply want it as per what it is: H:MM:SS. i do not need to average it or anything, so i just want to display the value only.

      Hoping to seek some help

      Show Less
    • forum

      Deployment & Management

      Qlik Sense on a server with existing PostgreSQL database

      Hi,   I' ve some issues installing Qlik Sense on a server where another program already has a PostgreSQL database installed and used. In particular, t... Show More

      Hi,

       

      I' ve some issues installing Qlik Sense on a server where another program already has a PostgreSQL database installed and used.

      In particular, there are problems with the used ports.

      Is this a configuration that is not allowed? Can I find documents about this? Or documents, how I can solve the problem?

       

      Christian

       

      Show Less
    • forum

      Qlik Application Automation

      Schedule on my automations reports aren't saving.

      Hello, I use qlik automation to send out a few reports for my clients. I have  reports scheduled to run each day at 7:30 am. Its been working great . ... Show More

      Hello,

      I use qlik automation to send out a few reports for my clients. I have  reports scheduled to run each day at 7:30 am.

      Its been working great . I could change the times  and everything worked.

      From the start of this week, any change I make to the scheduled time will not save after I close the automation.

      For example, If I change my report time from 7:30 am to 6:30 am and hit save. The application will give the notification that it is saved. As soon as I  close the automation and reopen it. My scheduled time  reverted back to 7:30 am. 

      We replicated this with 3 different clients.

      Any help to solve this problem would be greatly appreciated.

      111.png

      Show Less
    • forum

      New to Qlik Sense

      Max date in a filter

      Hi all, I have a field in my database called date with 2 values: 31-12-2021 and 01-01-2022. So i created a filter using date field and i could see bot... Show More

      Hi all,

      I have a field in my database called date with 2 values: 31-12-2021 and 01-01-2022.

      So i created a filter using date field and i could see both values. The thing is that at the first time there is no option selected, i would like to have the max date by default selected in the filter.

      Is this posible?

      Thanks

      Show Less
    • forum

      New to Qlik Sense

      You can not access Qlik Sense you have no access pass

      Hi Qlik Support,                                One of our clients is continuously encountering the 'You can not access Qlik sense you have no access ... Show More

      Hi Qlik Support,

                                     One of our clients is continuously encountering the 'You can not access Qlik sense you have no access pass' error for all the users.

      I tried to solve the problem by taking help of solutions provided on Qlik Community forum, but none of them worked so far.

      I need urgent help of Qlik Support team to resolve this issue.

      Client Name:- Hitachi Payment Services Pvt Ltd

      License Product Name :- QSE Client-Managed for QSE SaaS - Test
      License Key (Test):- 1231525336128587

       

      Advance Thanks

       

      Show Less
    • forum

      New to Qlik Sense

      AVG per dimension per time using set analysis

      Hi,  I have a pivot table looks like this:  Product Jan Feb SUM(Amount) Average Amt Per Product Per Month SUM(Amount) Average Amt Per Product P... Show More

      Hi, 

      I have a pivot table looks like this: 

      Product Jan Feb
      SUM(Amount) Average Amt Per Product Per Month

      SUM(Amount)

      Average Amt Per Product Per Month
      A 10   15  
      B 20   25  
      C 30   35  

       

      So I would like to calculate Average Amt Per Product Per Month. Currently I use this but it didn't work (return 0)

      SUM(Amount)/COUNT({1<[Month] = {"$TOP([Month])"}>}DISTINCT total [Product] & '|' & [Month])

      I also tried to see if TOP([Month]) returns correct value and yes, it matches its corresponding month for each of the row there, but when I include it to the whole calculation then it doesn't work. 

      Basically my idea is to have the count calculation ignoring the Product field and getting dynamic with the Month field. 

      Please advise.

      Thank you so much 

      Show Less

    Get Started On Community

    Start Here Get Started On Community

    Top Participants

    Blogs

    Community News

    Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!

    Blogs

    Qlik Academic Program Blog

    Read the latest blog around the Qlik Academic Program.

    Blogs

    Qlik Product Innovation Blog

    If you want to know what's new across all of the products in our growing Qlik product portfolio.

    Blogs

    Support Updates Blog

    Get the latest Support information about end-of-product support, new service releases, and general support topics.

    Blogs

    Qlik Design Blog

    Read all about Qlik solutions: scripting, data modeling, visual design, extensions, best practices and more.

    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

    Events and Webinars

    Qlik and Qlik Community Hosted Events

    Subscribe to our Events and Webinar page so you do not miss an event opportunity!

    choose and register

    Event

    Welcome to Qlik

    Join the "Welcome to Qlik" webinar and learn about the Qlik Ecosystem, such as Qlik Community, Learning, and Help.

    On-Demand

    Events

    Upcoming Events and Webinars

    There is more than one way to find upcoming events, look on the right side of any Qlik Community forum!

    Upcoming