Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
1,315 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 Qlik’s largest customer and partner event of the year.

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.

Discussion Boards and Documents for Qlik Services.

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 nine unique blogs. Check out the new Customer Success Blog!

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

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

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

  • QlikView Scripting

    If and or statement

    Hi,Below statement is giving an errorIF([Cost  excl. Tax]<=0,'Excluded','Check'='Excluded' or      if([Damage Tag]<>1 and ([Cost  excl. Tax]/Quantity<... Show More

    Hi,

    Below statement is giving an error

    IF([Cost  excl. Tax]<=0,'Excluded','Check'='Excluded' or      if([Damage Tag]<>1 and ([Cost  excl. Tax]/Quantity<=1000),'Excluded','check')='Excluded' or      if( ApplyMap('Claim_Type',"Claim type [PAR]",'check')='EXCLUDED' or      if([Damage Tag]<>1,ApplyMap('Part_Number',Material,'check'))='EXCLUDED'),'EXCLUDED PART','REQUIRED PART'  as  A,

    Show Less
  • Qlik Sense Advanced Authoring

    Define New , Exist, mature between Trades in 2 tables

    I have 2 tables , Current and Last year.  I want to add one more field "status" to defineNew  = if Trade ID exists only in [Current] tableExist = if T... Show More

    I have 2 tables , Current and Last year.  I want to add one more field "status" to define

    New  = if Trade ID exists only in [Current] table

    Exist = if Trade ID exists in both tables

    Matured = If Trade ID exists in [Last Year] table and Matdate > Report date

    I only know how to create in Excel formula but do not know how to create in Qlik sense. 

    Would like to seek expertise on it.

     

    Current    
    Report dateTradeIDMatDateTradeDateNotional
    20200131new1202012302018103050
    20200131new220201230201810302
    20200131ex12020123020181030100
    20200131ex12020123020181030100
         
         
         
    last year    
    Report dateTradeIDMatDateTradeDateNotional
    20191231ex12020123020181030100
    20191231ex12020123020181030100
    20191231mat1202012302018103010
    20191231Term120201230201810301
    Show Less
  • New to QlikView

    calculate switched cases

    I have to intercept (and calculate) the change of drugs distributed (AP_MINSAN10) between two delivery dates (FA_DATA_EROG) per patient (c.d. SWITCHED... Show More

    I have to intercept (and calculate) the change of drugs distributed (AP_MINSAN10) between two delivery dates (FA_DATA_EROG) per patient (c.d. SWITCHED PATIENTS)

    In the example attached the 

    PROVA PAZIENTE1 have n.2 switch

    PROVA PAZIENTE2 have n.3 switch

    PROVA PAZIENTE3 have n.1 switch

    Can you give me the correct expression for count these occurences?

    Show Less
  • Qlik Education Discussions

    Colour Themes in Qlik

    Hi guys, I am new to Qlik Sense and have to create a dashboard using data on helping the environment.I would like to have a theme colour of green acro... Show More

    Hi guys,

     

    I am new to Qlik Sense and have to create a dashboard using data on helping the environment.

    I would like to have a theme colour of green across all graphs in sheet(s).

    I see no option to choose a theme colour. Does anyone know a quick way how I can use a theme colour for background and content of charts etc.?

     

    Show Less
  • Qlik Data Catalyst Discussions

    Unable to run PostgreSQL service during QDC installation

    Hello Guys,I am trying to install QDC on CENT OS 8 on VM following QDC Installation guide by QlIK.But after installing PostgresSQL,  I am getting erro... Show More

    Hello Guys,

    I am trying to install QDC on CENT OS 8 on VM following QDC Installation guide by QlIK.

    But after installing PostgresSQL,  I am getting error as shown in the attachment

    qdc_pg-11.2 service failed to run

    I tried several times but getting same error.

    Please help me on this.

    Thanks!

     

     

     

    Show Less
  • New to Qlik Sense

    Error if

    Buenos días,Estoy empezando a manejar Qlik Sense y quería saber si me podéis solucionar el siguiente problema.Introduzco una fórmula de if donde el cl... Show More

    Buenos días,

    Estoy empezando a manejar Qlik Sense y quería saber si me podéis solucionar el siguiente problema.

    Introduzco una fórmula de if donde el cliente me solicita bastantes condiciones y llego a un punto que no me deja introducir más porque me indica: if takes 2-3 parameters.

    He introducido tres condiciones con dos if cada una pero cuando voy a meter otra, me da el problema reseñado.

    Un saludo.

    Show Less
  • New to QlikView

    Change existing Connections

    Hi all,I do know how to change existing Data connections and credentials in Qlik Sense but not in QlikView. Can somebody help where I find it?Thanks
  • Qlik Education Discussions

    Alternate States ( Only inherited state data should be seen in newly created Sta...

    Dear Experts,Need experts help for below requirement.There are two straight table. Inherited and MyState. Both the table should show results on some c... Show More

    Dear Experts,

    Need experts help for below requirement.

    There are two straight table. Inherited and MyState. Both the table should show results on some common filters. Lets say any Year is selected, then this selection should be applied in both the table for selected value in Year field. And data in MyState table  should contain only data present in Inherited State after the selection done in Year field. And how can i show the difference of these two total value's with different state in KPI.

    Would great for asap response.

    Regards,

    Nitin. 

    Show Less
  • QlikView Scripting

    Can Qlik Cloud Business implement Section Access feature?

    Hi AllRecently Qlik start to implement business cloud subscription USD 30 Per month. I like to know that are developer able to implement section acces... Show More

    Hi All

    Recently Qlik start to implement business cloud subscription USD 30 Per month. I like to know that are developer able to implement section access to protect certain user to access data. His section access is implement in Qlik view ver 9.

    Paul

    Show Less
  • New to QlikView

    Percent Total on a ranked dimension

    My pivot table shown below has two dimensions, with the first being the ProcedureSurgeonName.I have the following expression calculating my ranked dim... Show More

    My pivot table shown below has two dimensions, with the first being the ProcedureSurgeonName.

    I have the following expression calculating my ranked dimension, which is the second dimension.

    aggr(if(rank((SUM({<ZeroSurgicalUsedWastedIND = {'No'}>}SupplyChainLUOMTotalCost)))<=11,VendorName),ProcedureSurgeonName, VendorName)

     

    surgeonvendor.png

     

    My expressions are the following:

    Supply Total Cost:  SUM({<ZeroSurgicalUsedWastedIND = {'No'},ProcGroupDesc = {"*Fracture*"}>}SupplyChainLUOMTotalCost)

    and 

    Percent of Total:   SUM({<ZeroSurgicalUsedWastedIND = {'No'},ProcGroupDesc = {"*Fracture*"}>}SupplyChainLUOMTotalCost)/SUM({<ZeroSurgicalUsedWastedIND = {'No'},ProcGroupDesc = {"*Fracture*"}>}TOTAL SupplyChainLUOMTotalCost)

     

    As you can see in the table above my percentage of total is displaying across all Physician's so i've changed it to aggr on the Vendor Name, using the following.

    SUM({<ZeroSurgicalUsedWastedIND = {'No'},ProcGroupDesc = {"*Fracture*"}>}SupplyChainLUOMTotalCost)/SUM({<ZeroSurgicalUsedWastedIND = {'No'},ProcGroupDesc = {"*Fracture*"}>}TOTAL <VendorName>SupplyChainLUOMTotalCost)

     

    But, my totals still aren't displaying properly, it should be 100% for each Physician total and then each vendor will add up to the 100%.  I'm using the calculated dimension above for the vendor, but this is how my totals display when aggr by vendor.  Percentage of total.png

     

    I've also tried the following which yields no results:

    SUM({<VendorName = {"=aggr(if(rank((SUM({<ZeroSurgicalUsedWastedIND = {'No'}>}SupplyChainLUOMTotalCost)))<=11,VendorName),ProcedureSurgeonName, VendorName)"},ZeroSurgicalUsedWastedIND = {'No'},ProcGroupDesc = {"*Fracture*"}>}SupplyChainLUOMTotalCost)

    /

    SUM({<VendorName = {"=aggr(if(rank((SUM({<ZeroSurgicalUsedWastedIND = {'No'}>}SupplyChainLUOMTotalCost)))<=11,VendorName),ProcedureSurgeonName, VendorName)"},ZeroSurgicalUsedWastedIND = {'No'},ProcGroupDesc = {"*Fracture*"}>}TOTAL <VendorName>SupplyChainLUOMTotalCost)

     

    How can I get the % of Total column to display the percentages by my calculated dimension?

    Show Less

Blogs

Qlik Community Manager Blog

Hear from the Qlik Community team about the latest platform enhancements for October and November 2019.

Blogs

Qlik Support Updates Blog

Read the latest blogs from Qlik Support and get important and useful support information.

Blogs

Blogs

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

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 World 2020

Transform your digital world. Join us for our annual conference (formerly Qonnections) in Phoenix, AZ. Register by February 29th to save $200.

May 11- 14, 2020 Global Conference

Events

Events & Meetups

Participate in an upcoming local Qlik Meetup


Events

Qlik Insider: 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.

February 26, 2020