Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
2,587 online

Find the forums for your Qlik data analytics products to ask a question, start a discussion, or review documentation.

Find the forums for your Qlik Data Integration products to ask a question, start a discussion, or review documentation.

This forum will provide you with event highlights and related content to get you energized and ready for Qlik’s largest customer and partner event of the year.

Here you will find Qlik Sense resources, partake in interesting discussions, solve problems and foster relationships with Qlik experts from around the globe.

Thank you for joining us in the QlikView Forum, your home for QlikView answers. Discover insights within your data that can transform your business.

Discussion Boards and Documents for Qlik Services.

Join one of our Qlik Community Groups. Anyone can view content in Open Groups, but you must join to participate. Closed Groups require joining in order to view content and participate.

Hear directly from Qlik employees in our nine unique blogs. Check out the new Customer Success Blog!

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

Qlik partners with leading technology companies to develop integrations, extensions, and connectors to the Qlik platform.

Learn about the Qlik Community. Explore 'How-To' documentation, ask questions, and engage in discussion around the community platform. This will also be the place where, from time to time, we will do some fun things.

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

Recent Discussions

  • QlikView Integration

    New to API data integration

    Hi,we use cakemail to send out email campaigns, and the result of these campaigns can be retrieved using cakemail's legacy API services. The rep gave ... Show More

    Hi,

    we use cakemail to send out email campaigns, and the result of these campaigns can be retrieved using cakemail's legacy API services.

     

    The rep gave me an active API key and a link to their developper knowledge base : https://developer.cakemail.com/legacy/

    All the getting started examples are for PHP and Curl. 

    All the examples I see for Qlikview in the forums and community require some xml file which I can't find in the cakemail documentation. In short, I'm out of my league at this point, and wondering if anyone would have a good pointer to getting started for retrieving data using an API key. Or at least a basic Qlikview tutorial to suggest.

     

    Thanks

    Show Less
  • Qlik Sense App Development

    performance issue - Multiple tables Load

    Hi All,I have a application which is having dependency on multiple tables. Every week we need to load the data into application, but data will be dela... Show More

    Hi All,

    I have a application which is having dependency on multiple tables. Every week we need to load the data into application, but data will be delayed some times for few tables.  User requested us to load the data which is available and remaining can be done once the data is received.

     

    Is there any way to load the data to application, only those remaining tables when ever delay is happened??

    Show Less
  • New to Qlik Sense

    Circular References for Date

    Hi Everyone, i want to add forecast data (top left) to our data model but i always get a circular reference which i can not solve. How can i associate... Show More

    Hi Everyone, i want to add forecast data (top left) to our data model but i always get a circular reference which i can not solve. 

    How can i associate my forecast data to a date if not like this?Screenshot 2020-02-21 at 15.51.57.png

    Show Less
  • New to QlikView

    SubTotal in pivot table

    Hello everyone all, I have the following table: It is a pivot table. In the sub-total section, I would like to add the percentages instead of ... Show More
    Hello everyone all,
    
    
    
    I have the following table:
    
    TOTAUX.PNG
    
    
    It is a pivot table.
    
    In the sub-total section, I would like to add the percentages instead of adding the percentages, while keeping the direction column.
    
    Because I know that I can achieve the average by removing this column but I would prefer to find another solution.
    
    Thank you in advance.
    Show Less
  • Qlik Sense App Development

    Showing excluded values in a Qlik Sense table

    Hello Friends,Appreciate your time. I am looking for a solution to show the excluded values(in the grey color instead of disappearing) after making a ... Show More

    Hello Friends,

    Appreciate your time. I am looking for a solution to show the excluded values(in the grey color instead of disappearing) after making a selection in my Qlik Sense table.

    for example,

    let say I have the below table

     

    customer,units

    1,10

    2,20

    3,30

    4,40

    5,50

     

    In a QS table, when I click  the first row, the rest are all getting removed, Is there any way to show it in a gray color instead?

    I have attached a demo app for your reference

    below is my expression

    units: aggr(sum(qty),customer) 

    Thank you,

    Kiruthiga

     

     

     

     

    Show Less
  • QlikView App Development

    Taking difference from two tables with different but related calculated dimensio...

    Hey Guys!This might have been posted before but I can't find it directly so I'm going to ask.I have a table that used a calculated dimension. A specif... Show More
    Hey Guys!

    This might have been posted before but I can't find it directly so I'm going to ask.

    I have a table that used a calculated dimension. A specific variable is used in combination with a field, this results in an integer number and the integer number is than spread amongst some buckets with a bunch of if statements in the calculated dimension like this:

    =if(vCalculationDate-[Due Date] <= 0, '1. Current',
    if(vCalculationDate-[Due Date] > 0 and vCalculationDate-[Due Date] <= 30, '2. 1-30',
    if(vCalculationDate-[Due Date] > 30 and vCalculationDate-[Due Date] <= 60, '3. 31-60',
    if(vCalculationDate-[Due Date] > 60 and vCalculationDate-[Due Date] <= 90, '4. 61-90',
    if(vCalculationDate-[Due Date] > 90 and vCalculationDate-[Due Date] <= 180, '5. 91-180',
    if(vCalculationDate-[Due Date] > 180 and vCalculationDate-[Due Date] <= 270, '6. 181-270',
    if(vCalculationDate-[Due Date] > 270 and vCalculationDate-[Due Date] <= 365, '7. 271-365', '8. 365+'
    )))))))

    The reason I'm not doing it in the script, is because the user needs to be able to choose the vCalculationDate.

    Based on this calculated dimension and a very easy expression: sum(Values), I get a pivot table with the total value for each bucket.

    Now imagine another table, that is exactly the same, but instead of vCalculationDate, it takes vCalculationDate and subtracts 1 month from it in the calculated dimension. This means that there is a shift in the buckets. Note that my expression is in fact a little bit more complex, it used a set expression and 2 variables. I also take this expression in this table but subtract 1 month from each variable.

    Now I would in fact, like to have just 1 table, that calculated the difference of those 2 previously mentioned tables. I'm struggling with this because I have no idea how I can combine these calculated dimensions. If it were just taking the difference but keeping the same calculated dimension, I would just have to use sum(values) - sum(values but with variable that is 1 month lower). 

    Is such a thing possible? If it is, how would I have to set this up.

    I'm not exactly able to provide an extract of the qvd but if this is required, let me know and I'll see what I can do.

    Kind regards and thank you in advance!

    Show Less
  • QlikView Security & Governance

    Access Point. Application opening and signing loop

    Hi everybody,Im not expert on Qlikview administration, but have to do some.I have just published a new application on the webserver. I can see it on t... Show More

    Hi everybody,

    Im not expert on Qlikview administration, but have to do some.

    I have just published a new application on the webserver. I can see it on the Access Point portal.  But when I try to open it, im redirected to the login page...and cant go further. The login page displays in loop.

    When I remove publishing / publish again this app, at first opening, The APP is loading for some seconds before redirecting to login page.

    I can open any other application, but cant open this new one.

    Any idea of how to troubleshoot this ?

    Usually, I set some NTFS permissions on the server to restrict who views and who doesnt.

    Actually, as Im in debug mode, permissions are set with Full access to Domain users.

     

    Thank you for help

     

    Show Less
  • Qlik Sense App Development

    Combine AND and OR in an expression

    Hi!I have  some data in a Sense as below.What I want to do is when the 'Ordering Code' is empty and 'Telsims_Product_Group' contains 'LAN' or 'Telefon... Show More

    Hi!

    I have  some data in a Sense as below.

    What I want to do is when the 'Ordering Code' is empty and 'Telsims_Product_Group' contains 'LAN' or 'Telefoni', I want to add 'Broadband' for 'LAN' and 'Voice' for 'Telefoni 'in a new column (Order_new).

     

    I have tried with and expression looking like this but it doesn't work as i want :

     

    =if ((isnull([Ordering Code])and isnull(Product)) and (Telsims_Product_Group='LAN'),('Broadband') or
    (Telsims_Product_Group='Telefoni'),('Voice'))

    Any suggestion?

     

    AND and OR.PNG

     
     
     

     

    Show Less
  • New to Qlik Sense

    Can i put a password in a QlikSense App with section access?

    Hello everyoneI'm trying to put a password in an app in qlik sense (because I know that it is possible to do that in Qlik view) but is not working. An... Show More

    Hello everyone

    I'm trying to put a password in an app in qlik sense (because I know that it is possible to do that in Qlik view) but is not working. Anyone know if it is possible and can help me with an example?

    So much thanks to all.

    Show Less
  • Qlik Connectors Discussions

    Error connecting to SAP

    HiI´m trying to connect to SAP using the SAP SQL connector. The connector is avaliable but I receive a mesage that I can´t use it....Any ideas or comm... Show More

    Hi

    I´m trying to connect to SAP using the SAP SQL connector. The connector is avaliable but I receive a mesage that I can´t use it....

    Any ideas or comments? Is this a bug?

     

    Captura de Pantalla 2020-02-19 a la(s) 4.27.35 p. m..png

    Show Less

Blogs

Qlik Community Manager Blog

Hear from the Qlik Community team about the latest platform enhancements for October and November 2019.

Blogs

Qlik Support Updates Blog

Read the latest blogs from Qlik Support and get important and useful support information.

Blogs

Blogs

Hear directly from Qlik employees and stay current on the latest and greatest information about Qlik products.

Groups

Join a Group

Join one of our Qlik Community user groups around an Industry, Location & Language, or Topic.

Groups

Qlik Deployment Framework

This group hosts information related to the Qlik Deployment Framework (QDF).

2700+ Members

Groups

Qlik Healthcare

This group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights.

750+ Members

Events

Qlik World 2020

Transform your digital world. Join us for our annual conference (formerly Qonnections) in Phoenix, AZ. Register by February 29th to save $200.

May 11- 14, 2020 Global Conference

Events

Events & Meetups

Participate in an upcoming local Qlik Meetup


Events

Qlik Insider: What's New in 2020?

Join us on for a deep-dive discussion and tailored product demonstration on the newest capabilities delivered as part of Qlik’s most recent product release.

February 26, 2020