Qlik Community

Welcome to Qlik Community

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

  • Qlik Sense App Development

    Calculate filed in expression (KPI)

    Hello,I want to calculate the field in Count formula. See below : Count({left(Order,2)-="WO"} Sign)Sb could tell me what is wrong in this formula?  Show More

    Hello,

    I want to calculate the field in Count formula. See below : 

    Count({left(Order,2)-="WO"} Sign)

    Sb could tell me what is wrong in this formula? 

    Show Less
  • New to Qlik Sense

    Difference between Top down and Bottom up approach in Qlik

    Hi Team,Kindly explain- Difference between Top down and Bottom up approach in Qlik with suitable example.Regards,Masthan
  • New to QlikView

    Accumulation in qlik sense with multiple dimensions

    Hi Experts,Can anyone please let me know if there is any way to do accumulation in qlik sense with multiple dimensions.In a straight table i'm using 3... Show More

    Hi Experts,

    Can anyone please let me know if there is any way to do accumulation in qlik sense with multiple dimensions.

    In a straight table i'm using 3 dimensions. Month, Region and Customer. I want to show the expression [Sum(Sales)] by accumulating 3 steps for month. The accumulation should also work for other 2 dimensions.

    For single dimension this expression is working rangesum( above( sum([Expression1]),0,rowno())).

    How to write expression to accumulate for multiple dimensions.

    Please help me to get the solution. I need this very urgent.

     

    Thanks in advance.

    Regards,

    Raju

    Show Less
  • New to Qlik Sense

    Need Help!! New laptop came in today, needing to be able to pull apps up on it

    I am needing help understanding how to connect another computer in the office to the qlik server. I am able to do everything fine (pull up apps, mashu... Show More

    I am needing help understanding how to connect another computer in the office to the qlik server. I am able to do everything fine (pull up apps, mashups etc) on my original computer but have no idea how to pull them up on a computer other than mine.

    How can I access my apps on a different computer in the office that is fresh out of the box without Qlik on it. Thank you much for any help!

    Show Less
  • QlikView Creating Analytics

    Date range in set analysis using date from a field

    Hello,*Note: I am working in Quick Books Advanced Reporting which uses Qlikview software to build the reports. I've been able to solve most of my issu... Show More

    Hello,

    *Note: I am working in Quick Books Advanced Reporting which uses Qlikview software to build the reports. I've been able to solve most of my issues using info. I have found in the Qlik community but I'm sure there are distinctions associated with QBAR.

    I am using set analysis to calculate the number of items invoiced after a particular start date. The start date comes from a field called  Customer.Job Start Date. I would like to make my set analysis only calculate the qty. invoiced after the Customer.Job Start Date. I can do this using an if statement but this seems to then calculate the expression as individual transactions instead of aggregating the data. (See pictures below).Capture9.PNGWith set analysis of invoices the number is correct for the total qty. but I need to limit it to sales (qty. invoiced) after the job start date.Capture10.PNGThis set analysis gives me the correct qty. invoiced in total.Capture11.PNGWith the If statement which does work but only if I add a transaction type column and a transaction date column and the qty. is not aggregated.Capture12.PNGWith If statement and no type and date columnsCapture13.PNGThe if statement appears to split the expression into individual transactions.How do I get the if statement into my set analysis? I can't seem to make it look at transaction dates > than the customer job start date.

    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

    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

    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

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