Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
1,863 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

    Hide row in straight table - based on calculated field

    HelloI've been looking for days for a solution to get my advanced straight table to work as I wish. The aim of my table is to filter/show only values ... Show More

    Hello

    I've been looking for days for a solution to get my advanced straight table to work as I wish. The aim of my table is to filter/show only values with a minimum level of sales and a certain variation of sales from one year to another.

    clipboard_image_1.png


    I have no difficulty to run all calculations based on user selection (I use variables in my calculations).

    Nevertheless, I do not manage to hide rows based on conditions.

    Conditions could be : 2017 Sales > 2000 and 2018 Sales > 3000 and variation 2018 vs 2017 is between -10% and 0%.

    To make it more simple, let's try to focus on showing only rows where sales variation 2018 vs 2017 is between -10% and 0%.

    My sales variation is calculated as follow:

    =if (([$(vYearRef1)] > 0 and ([$(vYearRef2)]=0)),
    100,
    if (([$(vYearRef1)] = 0 and ([$(vYearRef2)]>0)),-1
    ,([$(vYearRef1)]/[$(vYearRef2)])-1))

    vYearRef make reference to column names (2018 and 2017 in my example)

     

    I have tried many different possibilities : do not show null values setting all fields to null if conditions are not fullfiled, set limitations (but I can not put a min and max value), aggr functions in the dimension expression...I'm now giving up and asking for your help..

    Do you have any idea how to only show countries (rows) where the variation of sales is calculated between -10 and 0%.

    Each year sales is calculated thanks to functions:

    pick (Vparts,
    pick (vAffichage,
    sum({<[D_SALES.autoCalendar.#Year]={$1},[HIERARCHIE]-={"*PIECE*"}>}NET_POSTE),
    sum({<[D_SALES.autoCalendar.#Year]={$1},[HIERARCHIE]-={"*PIECE*"}>}QTE_POSTE)
    ),

    pick (vAffichage,
    sum({<[D_SALES.autoCalendar.#Year]={$1}>}NET_POSTE),
    sum({<[D_SALES.autoCalendar.#Year]={$1}>}QTE_POSTE)


    )
    )

    Each year column calls the above function  (example for 2016):

    ($(vSalesCalculation($(=$(vCurrentYear)-3)

     

    IThanks for your help

    pat

     

    Show Less
  • New to Qlik Sense

    Qlik Sense License Types

       Hi,Can any one please suggest which licensing option is best (user based or token based ) using for real time environments with less operational co... Show More

     

     

     Hi,

    Can any one please suggest which licensing option is best (user based or token based ) using for real time environments with less operational cost for around 100 users.

     

    Thanks in Advance.

     

     

    Show Less
  • New to Qlik Sense

    save object as pdf in mashup

    Hi, I want to save object as pdf in mashup. 'As sheet as PDF File' extension I have achieved to save the whole page as PDF but I want object wise PDF.... Show More

    Hi, I want to save object as pdf in mashup. 

    'As sheet as PDF File' extension I have achieved to save the whole page as PDF but I want object wise PDF.

    So could you please guide me how to achieve this.

    Thanks, Sumanta

    Show Less
  • Qlik Sense Integration, Extensions, & APIs

    QIB NLU Configuration Failed

    Hi Qlik Community,I am posting QIB-NLU inquiry here as no thread is found in the drop-down list.I have tried to connect QIB-NLU with the certificates ... Show More

    Hi Qlik Community,

    I am posting QIB-NLU inquiry here as no thread is found in the drop-down list.

    I have tried to connect QIB-NLU with the certificates issued by my QlikSense Server & also tried with SSL-Certificate (issued by Certified Authority) but in both cases i am unable to connect both machines, please note that QIB & QS are installed on same machines.

    Below are the logs taken from QIB-NLU-Configuration File:

     

    }
    2019-10-18 15:13:52.5062|INFO|Configuration|CreateAgent|Creating new agent for Qlik Insight Bot nlu
    2019-10-18 15:13:52.5212|INFO|Configuration|SendRequest|Sending request with following parameter
    2019-10-18 15:13:52.5322|INFO|Configuration|SendRequest|Method: Post
    2019-10-18 15:13:53.4148|ERROR|Configuration|SendRequest|Error while sending request with following parameter
    2019-10-18 15:13:53.4289|ERROR|Configuration|SendRequest|The remote server returned an error: (401) Unauthorized.
    2019-10-18 15:13:53.4419|ERROR|Configuration|SendRequest|{
    "status": "error",
    "message": "NLU configuration failed."
    }
    2019-10-18 15:13:53.4549|ERROR|Configuration|CreateAgent|Error while creating agent
    2019-10-18 15:13:53.4689|ERROR|Configuration|CreateAgent|{
    "status": "error",
    "message": "NLU configuration failed."
    }
    2019-10-18 15:13:53.4830|ERROR|Component Configuration|ConfigureNLU|{
    "status": "error",
    "message": "NLU configuration failed."
    }

     

     

     

    Show Less
  • New to Qlik Sense

    Limiting Measure in Visualization

    Hello, I'm trying to compare multiple versions of sales over a yearly time frame.  For this example its 2019-2024.in version "XYZ", 2024 was not plann... Show More

    Qlik Question.JPGHello,

     

    I'm trying to compare multiple versions of sales over a yearly time frame.  For this example its 2019-2024.

    in version "XYZ", 2024 was not planned but it was in "ABC".

    Then, I did a comparison line item to show the delta between the years and I would like to show the line only comparing the years planned in both.  As you can see, the line shoots up in 2024 and it's not very nice looking.

    Any way I could get the delta calculation line to stop at 2023?

     

    Thanks!

     

     
     
    Show Less
  • New to Qlik Sense

    Problem with ">" for date in expression

    Hi everyone, I have problem with the use of operande ">" with Dates.Even if I can use it with numerics values, it doesn't work with dates for me.I wan... Show More

    Hi everyone,

     

    I have problem with the use of operande ">" with Dates.

    Even if I can use it with numerics values, it doesn't work with dates for me.

    I want sales after a certain year or between certain years

    but :

     

    Sum({$<[Date.autoCalendar.Year]={">2000"}>}SALES)

    Or even :

    Sum({$<[Date.autoCalendar.Year]={">2000<2019"}>}SALES)

     

    Are not working...

     

    But surprisingly :

    Sum({$<[Date.autoCalendar.Year]={"2000"}>}Sales)

    Is working and give me sales of year 2000

     

    Also, I think my problem with the comparators "< and >" are only wih dates... I tried with other values that contains figures and it works...but it should work with years as well as it is one of the precise example on the "help" documents no ?

     

    Do you have an idea where the problem can come from ?

    Show Less
  • Qlik Sense Deployment & Management

    Database Host Name

    Hello all,I'm working on installing Qlik Sense in a single node environment. I've installed and setup PostgreSQL database on the same server as the se... Show More

    Hello all,

    I'm working on installing Qlik Sense in a single node environment. I've installed and setup PostgreSQL database on the same server as the server on which I'm installing Qlik Sense. I'm at the very first few set of steps in installation process, particularly on Shared persistence database connection settings window. This one:

    localhost.png

    Since I already have database set up and configured, I don't want to install it again so I unchecked Install local database check box. Now it's asking me for Database host name.

    If the database is installed on the same server as the server that I'm installing Qlik Sense on, should I leave Database host name as localhost or should I change it to actual server name?

    Thanks,

    Mikhail B.

    Show Less
  • Qlik Sense Deployment & Management

    System Proxy Log - Failed to acquire user principal name - The LDAP server is un...

    Good Afternoon community,I have been digging for this solution for a while and finally I found this knowledge base where is basically the situation th... Show More

    Good Afternoon community,

    I have been digging for this solution for a while and finally I found this knowledge base where is basically the situation that we are facing:

    https://support.qlik.com/articles/000056252

    The problem is, in this case the application is not authorizing as the article is saying, in the logs I can see that my LDAP server connection is very slow and its not responding in time, forcing the principal name to not be acquire.

    But as the article is saying, the application should release the authorization and allow the user to login. This is not happening and the user browser starts to ask for the user the login and pwd. That have bee happening from time to time everyday, its intermittent, after some minutes the user just try again and the SSO works fine. We are using Active Directory here. 

    I'm attaching more details. Any ideas? Thanks for the collaboration...

    Show Less
  • Qlik Sense App Development

    Sum for the date and for the same date in the previous year in the rows of a tab...

    Hi Community,I am trying unsuccessfully to show in the same row the value corresponding to the same date but from the previous year.I tried different ... Show More

    Hi Community,

    I am trying unsuccessfully to show in the same row the value corresponding to the same date but from the previous year.

    I tried different expressions of set analysis from the community but without success:

    = SUM({< [SalesDate] = {$(=AddYears([SalesDate]-1))} >} [Price_ExtRetail])

    = SUM({< [SalesDate] = {"$(=AddYears([SalesDate]-1))"} >} [Price_ExtRetail])

    2019-10-18_153905.png

    If someone can give me some light on this matter I really appreciate it.

     

    Thanks!

    Show Less
  • New to QlikView

    How to convert JSON data with nested objects into CSV using Qlikview

    I have a JSON File with nested objects, I want the data to be converted into CSV format.I used some online converters that convert the data for me but... Show More

    I have a JSON File with nested objects, I want the data to be converted into CSV format.

    I used some online converters that convert the data for me but I am not allowed to do that with original data which is over million rows and also due to security reasons.

    the REST connector available with Qlikview also does not work because it only work with web data requiring HTTP / HTTPS Protocol.

    I also went through some other posts already on this community forum, but none of them have nested objects data like I have. 

    I have attached Json file and Desired solution (or better) .

    the solution provided in the post below only helps me to Extract  "Event ID" and "Log Id" correctly from my data , but it fails to extract all other information

    https://community.qlik.com/t5/New-to-QlikView/Load-Data-by-Script-with-JSON/td-p/1235048

    Please help in this matter

     

    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