Qlik Community

Welcome to Qlik Community

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

    Generate a column that has combination of month and quarter

    I have month and column values such as:QuarterMonthQ1JanQ1FebQ1MarQ2AprQ2MayQ2JuneQ3July and so on..Now I want to add a 3rd column that has values lik... Show More

    I have month and column values such as:

    QuarterMonth
    Q1Jan
    Q1Feb
    Q1Mar
    Q2Apr
    Q2May
    Q2June
    Q3July

     

    and so on..

    Now I want to add a 3rd column that has values like:

    QuarterMonthQMonth
    Q1JanJan
    Q1FebFeb
    Q1MarMar
    Q1JanQ1
    Q1FebQ1
    Q1MarQ1
    Q2AprApr
    Q2MayMay
    Q2JuneJune

     

    and so on...

    How do I add this third column QMonth.

    Thanks!!

    Show Less
  • QlikView Creating Analytics

    Search by Id

    Hi,Please any one give me solution.I want to search record from my excel file. For example in my excel file I have columns : Id, Name, Country. I want... Show More

    Hi,

    Please any one give me solution.

    I want to search record from my excel file. For example in my excel file I have columns : Id, Name, Country. I want to use text box and entered Id in it then my search button find the specific record from my excel file and populate all data in my charts and tables etc on base of id value.

    Excel file data look like this one.

    Id , Name, Country

    1  ,  Aon,    USA

    2,    Aina,   AUS

    3,    Ryan   Canda

    Thanks

    Show Less
  • New to QlikView

    How to display every Quarter of First month Sales data

    Hi All,I Have Year, Quarter and Month with Sales data.I have taken pivot table for displaying the data.If i click ‘+’ symbol on year in pivot table, i... Show More

    Hi All,

    I Have Year, Quarter and Month with Sales data.

    I have taken pivot table for displaying the data.

    If i click ‘+’ symbol on year in pivot table, it will expand and showing Quarters and if I click ‘+’ on Quarters then expand and showing Months.

    Q 1 having Sep, Oct, Nov and Q 2 having Dec, Jan, Feb like that

    If I collapse Q 1 then I want to display the Sep data for Q 1 (Like Beginning Month of the Quarter Q 1 like Sep) and if collapse Q 2 then Display Dec for Q 2 Data like that.

    How to Achieve that.

    Please see the below attached example for reference.

    Please suggest me How to Achieve This Scenario.

     

    Thanks & Regards, 

    lakshman

     

     

     

     

    Show Less
  • New to QlikView

    qlikview hide/encrypt the user id and password for ODBC

     //ODBC connect to the Customer iseries client 32 bit using QLIKV user id 113019ODBC CONNECT TO CUSTOMER (XUserId is HefFdIRJJaSMVPA, XPassword is dSM... Show More
     

    //ODBC connect to the Customer iseries client 32 bit using QLIKV user id 113019
    ODBC CONNECT TO CUSTOMER (XUserId is HefFdIRJJaSMVPA, XPassword is dSMfCJNGECWGDJBKSBUML);

     

    I have to reset this profile's password which I know where to do that but how do I encrypt/hide this information again.  I remember something about copying the string to notepad and then there is a special character or word needs to be put to make it view this way. 

     

    can anybody help.

    thank you 

     

    Show Less
  • New to Qlik Sense

    How to make my expression display -4,299,588 ?

    Hi AllI have below expression not working fine :-if(GetSelectedCount([Pls select 901st Dim])<1,Money(Sum(Aggr(SUM({<year = {"$(=Max(year)-0)"},month={... Show More

    Hi All

    I have below expression not working fine :-

    if(GetSelectedCount([Pls select 901st Dim])<1,
    Money(

    Sum(Aggr(SUM({<year = {"$(=Max(year)-0)"},month={"<=$(=Max({<sales = {'*'}, year = {$(=Max(year))}>}month))"},$(ColumnDim901)={$(ColumnDim901)}>}Amount*1)/$(Columndim89)/1000, $(ColumnDim108)))
    ,
    $(vMoneyFormatK)),
    Money(
    fabs(
    Sum(Aggr(SUM({<year = {"$(=Max(year)-0)"},month={"<=$(=Max({<sales = {'*'}, year = {$(=Max(year))}>}month))"},$(ColumnDim901)={$(ColumnDim901)}>}Amount*1)/$(Columndim89)/1000, $(ColumnDim108)))
    )
    ,
    $(vMoneyFormatK))
    )

    Hope some can advise me.

    Paul

    Show Less
  • New to Qlik Sense

    How to get the earliest record of the same transaction

    Hello all,Need your expertise and advise. I have a table that shows the below transactions. We wanted to calculate the number of recordID and their qu... Show More

    Hello all,

    Need your expertise and advise. I have a table that shows the below transactions. We wanted to calculate the number of recordID and their queue time. But for a duplicate record (possibly transferred transaction), we wanted to get the earliest record only. 

    RecordIDDateTimeAgentQueue
    AA14/02/2020 17:00Agent100:00:05
    AA14/02/2020 18:00Agent200:01:25
    AB14/02/2020 17:00Agent300:00:10

     

    I tried count distinct RecordID, but with the other Dimensions not the same, it still counted as 2 record.

    Appreciate your help on this. 

    Show Less
  • New to QlikView

    Selections in formula versus list box: Selection still possible

    Dear All,I could not find a solution for this problem. I hope somebody can help me.I have a formula in a table:sum({<UnderwritingYear={'2005','2006','... Show More

    Dear All,

    I could not find a solution for this problem. I hope somebody can help me.

    I have a formula in a table:

    sum({<UnderwritingYear={'2005','2006','2007','2008'}>}[Premium])

    If I now select in the table dimension only 2006, the table does not change.

    How can I exclude/include in a formula values, but still be able to select/unselect values by clicking on a dimension or make a selection on a list box?

    Many thanks.

    Jan

    Show Less
  • New to QlikView

    format

    Ex: I have two different date formats like below:15-2-2020& 15/2/2020. How can i  ensure that the date is loaded in consistent format (mm/dd/yyyy)? Show More

    Ex: I have two different date formats like below:

    15-2-2020

    15/2/2020.

     

    How can i  ensure that the date is loaded in consistent format (mm/dd/yyyy)?

    Show Less
  • Qlik Sense App Development

    Transfer selections from one field to another

    Hi everyone, I have a data model having two fields "CustomerName" & "Customer", the two fields hold the same data but are not linked and i cannot link... Show More

    Hi everyone, 

    I have a data model having two fields "CustomerName" & "Customer", the two fields hold the same data but are not linked and i cannot link them due to other considerations in my data model.

    i want to transfer user selections from one field to another. for example, user selects XYZ and ABC in "CustomerName", i want XYZ and ABC to be selected in "Customer" field.

    I know its possible with getselections in QlikView but cannot get it to work in Qlik Sense.

    your help is appreciated,

    Thanks

    Show Less
  • New to QlikView

    Get updated data using expression

    Hello There,My concern is how to get the updated data and if no update gets the previews data.sample data:NameADateBDateMC SyCollector08/25/2016Branch... Show More

    Hello There,

    My concern is how to get the updated data and if no update gets the previews data.

    sample data:

    NameADateBDate
    MC SyCollector08/25/2016Branch Name10/08/2019
    Abiah TengCashier02/16/2017- 
    Ashly TanCredit Asso.12/08/2017Credit Approver08/28/2019

     

    I try this expression but the output its not working base on the output I need.

    If(len(A)>,A,If(len(B)>,B))

    The output should be that I need is like below:

    NameBDate
    MC SyBranch Name10/08/2019
    Abiah TengCashier02/16/2017
    Ashly TanCredit Approver08/28/2019

     

    Is there any other way for this kind of concern?

    Best Regards,

    Bing

     

    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