Qlik Community

Welcome to Qlik Community

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

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

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 ten unique blogs. Check out the new Product Insight & Ideas Blog!

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

Discussion Boards and Documents for Qlik Services.

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

  • New to Qlik Sense

    Add single field on load to existing application

    So I have an existing Qlik Sense application that I have already loaded data to and have created a whole bunch of charts for.  There is a field from a... Show More

    So I have an existing Qlik Sense application that I have already loaded data to and have created a whole bunch of charts for.  There is a field from an existing qvd that I need to add that I didn't have on my initial data load.  In other words, I only loaded 3 fields from a QVD for this application initially, but I need to add a 4th now.  I tried to add the field into the data load, but when I reload the data, the field is not showing up in the data tables.  What might I be doing wrong to add this field?  

    Show Less
  • Qlik Sense App Development

    If than based on selections

    I have a Qlik Sense app where I have dimensions for distributor name and distributor code plus one measure for sales.  I am trying to create a table t... Show More

    I have a Qlik Sense app where I have dimensions for distributor name and distributor code plus one measure for sales.  I am trying to create a table that shows sales data using the distributor name when it is selected in the distributor name filter box or distributor code for the distributor names not selected.  I am using set analysis to show sales for all distributors regardless of the distributor name selections.  I need this to work if one or multiple distributor names are selected.

    Show Less
  • Qlik Connectors Discussions

    Unknown Error. Resulting in Partial result set being returned. QVX_GET_EXECUTE_E...

    My Custom Connector is working pretty well. But for some reason when I'm pulling back results from 1 specific Saved Search that's a Transaction type (... Show More

    My Custom Connector is working pretty well. But for some reason when I'm pulling back results from 1 specific Saved Search that's a Transaction type (I have other Transaction types that work fine), I'm getting the below within the Log file.

    002842 2020-03-27T10:47:34.647-04:00 Notice WriteTableItemsToStream() - Wrote: 5733 table items to stream
    002843 2020-03-27T10:47:34.653-04:00 Debug HandleRequest(request:QVX_GET_EXECUTE_ERROR)

    The 5733 items come back into Qlik without any issue. The issue is that it should be returning about 14,000 items instead.

    It moves fast, no timeouts, and I can't find anything else anywhere suggesting what might be wrong.

    Any help would be appreciated.

    Thanks

    Show Less
  • New to Qlik Sense

    Getting an average from specific dimension results

    Hi All!  Hoping for some help here.I am new to QlikSense and have a clinical healthcare background not technical so I apologize if I use the wrong lan... Show More

    Hi All!  Hoping for some help here.

    I am new to QlikSense and have a clinical healthcare background not technical so I apologize if I use the wrong language here.

    I am creating a dashboard to compare hospital discharge times across various sites.  On one sheet I am trying to create a comparison that shows all six sites without the end user having to make the selections.  For the patient count I am using the expression in a KPI of (count({<Organization={'Hospital A'}>}Organization)) which gives me the results of just that facility.  For the average time I am using a KPI with the expression avg(if([DC TAT]<5760,([DC TAT]))) which gives me the average but for all the facilities involved.

    Essentially I trying to jam those two expressions together so I can have a KPI that shows the Avg DC TAT only when it equals Hospital A, Hospital B, etc..

    I have tried various expressions and have googled like crazy but cannot seem to figure it out.  My guess is I need to use Aggr function but I cannot seem to get an expression that works correctly.

    Any thoughts would be greatly appreciated! 

    Show Less
  • New to QlikView

    Price per Month aggregated by Year

    I have Price, Today() as Start Date and 10/25/2025 as EndDateHow do I generate months between Today() and EndDate, Add Price Per Month to each Month a... Show More

    I have Price, Today() as Start Date and 10/25/2025 as EndDate

    How do I generate months between Today() and EndDate, Add Price Per Month to each Month and show them in Years?

    As an example

    Current:

    PriceIDStartDateEndDate
    5013/31/20202/25/2021
    3023/31/20205/14/2020

     

    Result:

    PriceIDYearMonthPrice Per Month
    3022020Mar10
    3022020Apr10
    3022020May10
    5012020Jan0
    5012020Feb0
    5012020Mar4.16
    5012020Apr4.16
    5012020May4.16
    5012020June4.16
    5012020Jul4.16
    5012020Aug4.16
    5012020Sep4.16
    5012020Oct4.16
    5012020Nov4.16
    5012020Dec4.16
    5012021Jan4.16
    5012021Feb4.16
    Show Less
  • Qlik Sense App Development

    aggr selection issue

    Hi,when using calculated dimension with aggr it select the user,here is my dimension:=Aggr(FirstSortedValue(vp, -Date), user)can i make it select the ... Show More

    Hi,

    when using calculated dimension with aggr it select the user,

    here is my dimension:

    =Aggr(FirstSortedValue(vp, -Date), user)

    can i make it select the vp?

    the result in the table is correct.

    please find attached qvf

    thanks.

    ido.

    Capture.PNG

    Show Less
  • QlikView Creating Analytics

    How to hide column when field values is empty

    Hello All,can some one help me How to hide column when field values is empty. i have tried below expression its not working for me.=if(Len( [Provider]... Show More

    Hello All,

    can some one help me How to hide column when field values is empty. i have tried below expression its not working for me.

    =if(Len( [Provider])=0,0,1)
    =if(count( [Provider])=0,0,1)
    if(count( [Provider])=null(),1,0)
    sum([Provider])>0
    If(Len(Trim([([Provider])]))<>0 , [([Provider])])

    Regards,

    Navin

    Show Less
  • Qlik Sense Integration, Extensions, & APIs

    Alterar Cor da Fonte de Objeto do Qlik Sense no Mashup

    Preciso alterar a cor da fonte de objeto do qlik Sense no mashup, podem me ajudar? 
  • New to Qlik Sense

    Can I put a hidden/permanent filter on a chart?

    Hi everyone,Let assume I have a table that contains the following fields:Account / Country / Region/ SalesI want to make a bar graph that shows the Co... Show More

    Hi everyone,

    Let assume I have a table that contains the following fields:

    Account / Country / Region/ Sales

    I want to make a bar graph that shows the Country on the X axis, and the total sales on the Y axis.  I want to show only countries that are in Region = Europe and I don't want the user to be able to change the Region on this chart.  

    Can I do this?

    If I do this, can I have a visible filter on the sheet that will allow the user to select specific countries in Europe?

    If so, how is all of this done? 


    Thanks!
    - Barry

    Show Less
  • Qlik Sense App Development

    Null Values to be shown as Others in Pie Chart

    hello,I need to show the null values as 'Others' in a pie chart for different customer_types.i used the below expression, but its not working.if(isnul... Show More

    hello,

    I need to show the null values as 'Others' in a pie chart for different customer_types.

    i used the below expression, but its not working.

    if(isnull(customer_type),'Others',customer_type)

    i also tried to use the relative value for the dimension. I gave it as >=1.0%. This works fine. But there is one customer_type, for which the value is <1.0% i.e.,0.3%. This value is also included in Others. I dont want this to be included in Others. Is there any other way to do this. Please suggest.

    Please find the attached screenshot.

    Measure used is:

    Count( {1<card_fYear={"<=$(vMaxYear)"},card_status={'ACTIVE'}>} distinct customer_id)

    the Portion in grey color in pie chart must be shown as Others, but rather it just displays a '-'.

     

    Show Less

Blogs

Qlik Community Manager Blog

Hear from the Qlik Community team about the latest platform enhancements for December 2019 and January 2020.

Blogs

Customer Success Blog

Read all about Qlik's Voice of the Customer program and Customer Success initiatives.

Blogs

Blogs

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

Groups

Qlik Insight Bot

Join the Qlik Insight Bot Group and bring the power and simplicity of natural-language, conversational analytics to everyone in your organization

open to all

Groups

QlikView to Qlik Sense

Join the QlikView to Qlik Sense group and help you modernize your BI experience through adoption of Qlik Sense.

open to all

Groups

Qlik Healthcare

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

750+ Members

Events

The Human Impact of Data Literacy

Boosting the data skills of your entire workforce can exponentially increase your data’s value. In this webinar, discover the big opportunity in data literacy.

March 25, 2020 Webinar

Events

Events & Meetups

Participate in an upcoming local Qlik Meetup


Events

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.

Now Available on Demand