Qlik Community

Welcome to Qlik Community

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

May Qlik Alert You – Welcome to the Qlik Alerting Product Forum! Join in on the discussion around Qlik’s intelligent alerting solution for Qlik Sense! This is an open group to share and collaborate!

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

  • No Boards Found
  • forum

    Qlik Brasil

    Aggr retorna nulo em tabela

    Alguém saberia me dizer por que a regra a segue retorna nulo na tabela? Quando eu faço uma seleção de apenas 1 dia pela data a regra funciona devidame... Show More

    Alguém saberia me dizer por que a regra a segue retorna nulo na tabela? Quando eu faço uma seleção de apenas 1 dia pela data a regra funciona devidamente, mas fica cheia de valores nulos quando está sem seleção.

    AVG({<len_c_itemred = {'7'}>} [Estoque])

    /

    (
    SUM(
    Aggr( SUM({<len_c_itemred = {'7'}>} [Estoque]) * Avg({<len_c_itemred = {'7'}, [Estoque]=-null>} padrao_producao), [Cód.Produto]) )

    /

    SUM( Aggr( SUM({<len_c_itemred = {'7'}>} [Estoque]), [Cód.Produto]) )

    Show Less
  • forum

    Community Corner

    Round of Applause - August 2020

    While it's hard to believe we are in August already, it does mean a new month and another opportunity for our monthly "Round of Applause". This month... Show More

    Brett Bleess.jpg

    While it's hard to believe we are in August already, it does mean a new month and another opportunity for our monthly "Round of Applause". This month goes to our very own Qlik employee Brett Bleess! Brett is part of our Digital Support team,  has over 3500 posts, and countless interactions in the community. Brett is a valued partner to our team and we appreciate all of his interactions and moderation he provides.  

    Brett started with Qlik in Oct 2004 and has been a part of the support organization the entire time due to his overwhelming drive to solve problems.  When he started, we were on version 6 of the QlikView product and that was the only product we had! His community presence is part of his job, however, he really enjoys spending time in the community as things tend to be a bit more laid back and collaborative than in the case environment.  Also, much of the time things are not as urgent and people tend to be much more appreciative of the help/guidance they receive. While he mainly collaborates in the QlikView product area,  when time allows, he is able to get into the Qlik Sense forum.

    In his spare time, Brett enjoys doing projects around his house as well as for friends and family. He has a dedicated woodworking shop in his backyard with a full suite of tools. He really enjoys building new things and fixing old. Brett grew up on a farm and really misses working on tractors. He wants to buy a subcompact tractor, so he can do projects using the tractor.  Due to the virus tractors are in short supply, however, he is hopeful to buy one soon. 

    Let's give Brett a round of applause by adding a comment and/or giving him a like! @Brett_Bleess @Courtney_Cromley @Wlad_Masi @Melissa_Potvin 

     

    Show Less
  • forum

    Qlik NPrinting Discussions

    Can NPrinting 19 set up read receipt?

    Hi guys,We sent some testing emails to external users via NP19. Is that possible to request read receipt in NP19 so we can easily know if message open... Show More

    Hi guys,

    We sent some testing emails to external users via NP19. Is that possible to request read receipt in NP19 so we can easily know if message opened? Or, at least if there are any logs we can check message delivered?

    Thanks for your help.

    Fion

    Show Less
  • forum

    New to Qlik Sense

    measure Pointer sales last year, plansale and actual sale

    Hello together,I want to do a measure pointer with segments and different colors, where I can see :- sale of last year  per day-plansale per dayactual... Show More

    Hello together,

    I want to do a measure pointer with segments and different colors, where I can see :

    - sale of last year  per day

    -plansale per day

    actual sale per day

    It should be dynamic, in depency of a date.

    Does anybody have a idea?

    wuensche_0-1595688084021.png

     

    best regards

    wuensche

    Show Less
  • forum

    New to Qlik Sense

    Sharepoint List connection to QLIKSENSE

    Hi there, I have a restricted sharepoint list that I need to set connections to QLIKsense. Due to restrictions to the Sharepoint list, QLIK is unable ... Show More

    Hi there, 

    I have a restricted sharepoint list that I need to set connections to QLIKsense. 
    Due to restrictions to the Sharepoint list, QLIK is unable to stablish a connection. 

    Could anyone suggest best way forward?
    My guess is that I need to add QLIK to the sharepoint access users?
    I have not got a clue! 

    Thanks a million for your support on this!

    Regards

    Jose 

    Show Less
  • forum

    Qlik Sense App Development

    Flagging each visit by calculating date range

    I have a table with visit summary of patients visiting the hospital. This table contains the VisitID, PatientID, DateAdmitted, DateDischarged. I need ... Show More

    I have a table with visit summary of patients visiting the hospital. This table contains the VisitID, PatientID, DateAdmitted, DateDischarged. I need to identify visits which were readmissions (i.e. visits which happened within a gap of 30 days from the previous visit). I need to add two columns flagging the visit as a readmission using the DateAdmitted and DateDischarged as Readmit_flag (a visit from a patient who was admitted in the hospital less than 30 days ago) and PrevAdmit_flag (an admission which lead to a readmission).

    Dummy Data:

    VisitIDPatientIDDateAdmittedDateDischarge
    AA1PA15/26/20166/10/2016
    AA2PA26/7/20166/13/2016
    AA3PA35/30/20166/5/2016
    AA4PA17/1/20167/5/2016
    AA5PA27/1/20167/7/2016
    AA6PA37/3/20167/7/2016
    AA7

    PA4

    8/3/20168/6/2016
    AA8PA58/4/20168/9/2016
    AA9PA49/4/20169/8/2016

     

    Output:

    VisitIDPatientIDDateAdmittedDateDischargeReadmit_FlagPrevAdmit_flag
    AA1PA15/26/20166/10/201601
    AA2PA26/7/20166/13/201601
    AA3PA35/30/20166/5/201601
    AA4PA17/1/20167/5/201610
    AA5PA27/1/20167/7/201610
    AA6PA37/3/20167/7/201610
    AA7

    PA4

    8/3/20168/6/201600
    AA8PA58/4/20168/9/201600
    AA9PA49/7/20169/10/201600

     

    PA1, PA2, PA3 got readmitted within 30 days of their previous discharge, so their readmit_flag is 1 and the corresponding previous visit is flagged with PrevAdmit_flag as 1. PA4 was admitted after more than 30 days so flag is 0 for both readmit and prevadmit.

     

    Please help me achieve this on the Load Editor. Thank you. 

    Show Less
  • forum

    New to Qlik Sense

    count of percentage

    Team in Qlik Sense.  How can I get the count() of records where the percentage of budget is over 75%.count(num(TRIM(sum(BH_AMOUNT_ACT + BH_AMOUNT_GLA ... Show More

    Team in Qlik Sense.  How can I get the count() of records where the percentage of budget is over 75%.

    count(num(TRIM(sum(BH_AMOUNT_ACT + BH_AMOUNT_GLA + BH_AMOUNT_GLL + BH_AMOUNT_GLQ + )) / sum(BH_AMOUNT_BUD) *100) > 75)

    Show Less
  • forum

    New to Qlik Sense

    Scatat plot symbols

    Hi Everyone, Is it possible to do in qliksense.Below is the requiement. L= LowM=MediumH= HighVH= Very high Is it possible in qliksense   Show More

    Hi Everyone,

     

    Is it possible to do in qliksense.Below is the requiement.

     

    L= Low

    M=Medium

    H= High

    VH= Very high

     

    Is it possible in qliksense

     

     

    Quadrant Graph.png

    Show Less
  • forum

    New to Qlik Sense

    Display pre aggregated fields in KPI

    Hello,I am a beginner in Qlik Sense. Since I am working on a huge dataset, I am aggregating the values before importing it in Qlik Sense to improve th... Show More

    Hello,

    I am a beginner in Qlik Sense. Since I am working on a huge dataset, I am aggregating the values before importing it in Qlik Sense to improve the  performance. Now, I wish to only display a pre-aggregated field in a KPI chart. Below are the options that I get while adding a new measure to the KPI chart.

    prithviKamath_0-1596219180087.png

    If I forcefully edit the expression to remove the aggregation, it does not display any value.

    prithviKamath_1-1596219261895.png

    My aggregated table now looks like this:

    prithviKamath_0-1596230445226.png

    So I plan to have a Filter panes for Year and Gender and KPI chart or Patient Count. 

    Can anybody kindly suggest a work around?

    Any help will be greatly appreciated! Thanks!

    Show Less
  • forum

    QlikView Layout & Visualizations

    Gauge and Bar Chart for next 6 months or current month

    I am trying to accomplish 3 things using set analysis and FABS but having issues using Date(AddMonths(monthstart(today()),6))) and FABS:Create a gauge... Show More

    I am trying to accomplish 3 things using set analysis and FABS but having issues using Date(AddMonths(monthstart(today()),6))) and FABS:

    1. Create a gauge chart for the next 6 months
      1. 1-(sum(FABS([Assigned Hours]))/sum([Available Hours]))
    2. create a gauge chart for the current month
      1. 1-(sum(FABS([Assigned Hours]))/sum([Available Hours]))
    3. create a stacked bar chart for the next 6 months 
      1. Available hours: sum({<[CHKBK_MONTH]={">=$(= Date(AddMonths(monthstart(today()),6)))>=$(=monthstart(today()))"}>} [Available Hours])
      2. Assigned Hours: sum({<[CHKBK_MONTH]={">=$(= Date(AddMonths(monthstart(today()),6)))>=$(=monthstart(today()))"}>} FABS([Assigned Hours]))
    Show Less

Top Participants

Blogs

Qlik Community Manager Blog

Hear from the Qlik Community team about the latest platform enhancements for April and May 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

Covid 19

We are bringing together people and resources in response to the pandemic of Coronavirus, aka COVID-19, aka SARS-CoV-2.

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

Qlik Customers Share COVID-19 Supply Chain Strategies

Amazon Produce Network and Odyssey Logistics discuss how they’re using Qlik to help manage their operations during Covid 19

On Demand Webinar

Events

Events & Meetups

Virtual Meetups are now a possibility! With the impact of COVID-19, the Qlik Meetup network has expanded its support to include the ability to host your next Meetup online. Email QlikMeetups@qlik.com to get your virtual Meetup started!’


Events

Direct Relief Uses Qlik to Manage Its COVID-19 Supply Chain

Qlik can help you manage your supply chain risks during COVID‑19.The nonprofit organization, Direct Relief, uses Qlik’s Supply Chain solution to scale its delivery of medical supplies worldwide.

Available on Demand