Qlik Community

Welcome to Qlik Community

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

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.

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

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

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 eight unique blogs. Check out the new Architecture Deep Dive Blog!

Find a forum to ask a question or start a discussion.

Discussion Boards and Documents for Qlik Services.

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

Discussion board and documents related to Qlik Associative Big Data Index.

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.


Introducing Qlik Gallery

Announcing the newest addition to the Qlik Community, Qlik Gallery!

Qlik Gallery is all about sharing – apps, outcomes, and ideas. This is your space to learn from each other as Qlik users, fans, thought leaders and data enthusiasts

Recent Discussions

  • New to Qlik Sense

    Current Month and Current Year Calculation

    Hi, I have the logic below to look at values as at today's date but I also need to show the same calculation for 'Current Month' and another for 'Curr... Show More

    Hi, 

    I have the logic below to look at values as at today's date but I also need to show the same calculation for 'Current Month' and another for 'Current Year', any idea how I change below to for the two additional calculations needed please?

     

    =Sum({<[AU_Date]={'$(Today())'}>} [Total_Sold] )

    Show Less
  • Qlik Sense Data Connectivity

    Local connector

    What about a local connector on the new Qlik Sense Business ?Actually, I have an error when I'm trying to read a local path...Any help?
  • Qlik Sense App Development

    Allow users to create bookmarks, but Not Edit or duplicate sheets

    Hello everyone,What we are trying to accomplish -Allow end users to create bookmarks on sheets ,  but this would not allow users to create other objec... Show More

    Hello everyone,

    What we are trying to accomplish -

    Allow end users to create bookmarks on sheets ,  but this would not allow users to create other objects such as stories, other sheets, or duplicate the sheets etc. ONLY Bookmarks

    and in our stream, we have multiple applications, but this rule should be applicable on only one application that is specific to be used by ipad users, and for rest of the other application user can create duplicate sheets.

    Please suggest how to acheive this, I tried to modify the security rule but it's not working.

    Thanks in advance

    Show Less
  • Qlik Sense Data Connectivity

    Data Connections not loading in Data load editor in an Offline environment

    Hi All,I have an application with PostgreSQL data connection type.Once I imported it to a client which works in offline environment, the application i... Show More

    Hi All,

    I have an application with PostgreSQL data connection type.

    Once I imported it to a client which works in offline environment, the application is not running.

    I accessed the  Data Load Editor of the application and found out that the Data Connection on the right side does not load.

    I found this article:

    https://support.qlik.com/articles/Basic/Data-Connections-not-visible-in-the-Data-Load-Editor-in-Qlik-Sense-3-2-or-Error-11041-11043?articleId=Data-Connections-not-visible-in-the-Data-Load-Editor-in-Qlik-Sense-3-2-or-Error-11041-11043

    From what I understand, the connectors package is having an online authentication which caused failure when working offline.

     

    My question - is there a way to use PostgreSQL connector in offline mode as I don't want to use an ODBC data connection solution?

    Thanks.

    Show Less
  • QlikView Management

    shared storage solution is supported by Qlikview server

    Hellowhich shared storage solution is supported by Qlikview server .i'v found here that the only one is windows shared files and nas in only few cases... Show More

    Hello

    which shared storage solution is supported by Qlikview server .

    i'v found here that the only one is windows shared files and nas in only few cases .

    https://qliksupport.force.com/articles/Basic/Does-QlikView-Support-NAS-Storage?articleId=Does-QlikView-Support-NAS-Storage

    Can you give more details about that ? in which case is supported on nas storage ?

    Thank you

    Show Less
  • Qlik Education Discussions

    Less Than or equal in expression

    Dear Friends,I have created following  variable  in Qv documentlet  vTdate=num(Date(MakeDate(2019,10,31),'YYYY/MM/DD'));and I have written following e... Show More

    Dear Friends,

    I have created following  variable  in Qv document

    let  vTdate=num(Date(MakeDate(2019,10,31),'YYYY/MM/DD'));

    and I have written following expression in my pivot table and it works perfectly

    SUM({<FYYYYMM={$(=vTmonth)},POL_TYPE={'R','A'},HISTORY={'Y'}>}PREMIUM)

    but when I try   to change the expression as shown below it does not work

    SUM({<FYYYYMM={"<=$(vTmonth)"},POL_TYPE={'R','A'},HISTORY={'Y'}>}PREMIUM)

    I want to change the equal to less than or equal. Pls help me to correct the expression

     

    Show Less
  • QlikView Layout & Visualizations

    Select combo box

    Very simple question: In a select box (dropdown list) can i choose the first element for default?
  • QlikView App Development

    Pick WildMatch default value

    I've got a Currency field that has values like, USD, EURO and UK.I want to translate UK and EURO to GBP and EUR respectively.I can do this quite easil... Show More

    I've got a Currency field that has values like, USD, EURO and UK.

    I want to translate UK and EURO to GBP and EUR respectively.

    I can do this quite easily in an If formula because there are just two values that need translating, the rest should stay the same. i.e.

    If([Currency]='EURO','EUR',If([Currency]='UK','GBP',[Currency])

    However in the future there may be currencies that need translating and the nested If statement could get quite large. I'm wondering if it's easy to set a default value using Pick and WildMatch (or Match). The following would translate UK and EURO for me but I would lose USD etc. 

    Pick(WildMatch([Currency],'UK','EURO'),'GBP','EURO')

    Show Less
  • New to QlikView

    AGGR

    Hi, what im missing out here?I want the highlighed post to tell me "+-" on both.I'ts same order, sku and the sum is 0 The expression is now:aggr(if(Su... Show More

    Hi, what im missing out here?

    I want the highlighed post to tell me "+-" on both.

    I'ts same order, sku and the sum is 0

    clipboard_image_0.png

     

    The expression is now:

    aggr(if(Sum(QUANO = '0'),'+-','N/A'),SHPPO,PRDNO)

    Show Less
  • Qlik Sense App Development

    Set Analysis - show no records when all dimensions are excluded

    I have a simple table with four products:Products A and B are very important to my users, so they should be shown in a table on their own.  There is a... Show More

    I have a simple table with four products:

    clipboard_image_0.png

    Products A and B are very important to my users, so they should be shown in a table on their own.  There is also a filter allowing a user to select a product:

    clipboard_image_1.png

    The measure in the table is calculated as: Sum({<Name*={'A', 'B'}>} Value)

    This is so that the table shows records for A and B when they are selected or possible.  But if a user selects a Product that is not A or B, then nothing should be shown.

    This works ok when A and B are selected or possible e.g.:

    clipboard_image_2.png

    But it show this when I select Product C:

    clipboard_image_4.png

    In this case I want to see no rows in the table - A and B are not selected so my users don't want to see any data.

    I know I could turn off 'Include zero values' in Data Handling but this is a problem if the value for A or B is 0.  E.g. if the value for A is 0, it's important for my users to see this - they need to know that A has 0 value.

     

    I feel like there is an obvious solution to this problem but I can't think what it is.  Any ideas?

    Show Less

Blogs

Qlik Community Manager Blogs

Hear from the Qlik Community team about the latest platform enhancements, announcements, and more.

Blogs

Qlik Education Blog

Check out the latest Education Blog written by Kevin Hanegan,Qlik Chief Learning Officer.

Blogs

Blogs

Hear directly from Qlik employees and stay current on the latest and greatest information about Qlik products. We have 8 blog types for you to choose from.

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 Insider Webinar Series

What's New in 2019. Register for the Qlik Insider Webinar Series to stay connected on our latest releases

Available On Demand Webinar

Events

Events & Meetups

Participate in an upcoming Qlik related event, webinar, or local meetup.

Events

Welcome to Qlik

Join the “Welcome to Qlik” webinar and learn about the Qlik Ecosystem

Tuesday, August 27, 2019 Webinar