Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
logo
1,631 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 Sense Advanced Authoring

    Ignore filter in table, but not in measure

    Hi,Let's imagine this table:measures are: sum(sales) and  count(distinct{<[type]={'sale'}>} name&surname)If we apply filter 'refund' in dimension 'typ... Show More

    Hi,

    Let's imagine this table:

    measures are: sum(sales) and  count(distinct{<[type]={'sale'}>} name&surname)

    1.png

    If we apply filter 'refund' in dimension 'type', table transforms to this:

    2.png

    Is it possible to achieve this table (keeping  count distinct type='sale' calculation, but not showing 'sale' type rows in table, using some kind of set analysis?

    namesurnametypeSum(sales)count(distinct{

    <
    [type]={'sale'}
    >}
    name&surname)
    Total  -1503
    johnsmithrefund-500
    marybryantrefund-1000

     

     

     

    LOAD * Inline [
    name,surname,type,sales
    john,smith,refund,-50
    mary,bryant,refund,-100
    arthur,jones,sale,150
    brenda,patrick,sale,75
    lisa,jackson,sale,50
    ];

     

     

    Thanks in advance, 

    Jose

    Show Less
  • forum

    New to Qlik Sense

    Aggr SetAnalysis

    I need to get the minimum value from column F by excluding the values of column F where column E is emptyplease tell me how to do this using set analy... Show More

    Vittore8_1-1594279905453.png

    I need to get the minimum value from column F by excluding the values of column F where column E is empty

    please tell me how to do this using set analysis

    Show Less
  • forum

    New to Qlik Sense

    How to use a Set Analysis result as the n-value of AddYears function

    I want to use the AddYears function in a dimension (column of a table), but not with a static n-value that indicate the years to add or subtract.One o... Show More

    I want to use the AddYears function in a dimension (column of a table), but not with a static n-value that indicate the years to add or subtract.

    One of the Columns indicate the Depreciation Year. In order to indicate the depreciation years I had to do the following: AGGR(ONLY ({<[Attribute Code]={'DEPRECIATION YEARS'}>} [Attribute Value]),[Asset Code]))  this provides a number, e.g. 4

    I now what to use that value in another column to indicate the Remaining Depreciation Year. I wanted to do the following: AddYears([Commissioned On Date] , AGGR(ONLY ({<[Attribute Code]={'DEPRECIATION YEARS'}>} [Attribute Value]),[Asset Code])) . This does however not work. 

    When I do the following:  AddYears([Commissioned On Date] , 4) I get the answer I am looking for, but the n-value of the AddYears value will be dynamic for each Asset that is in the table.

    Thanks is advance

    Marisa

    Show Less
  • forum

    QlikView Creating Analytics

    A set analysis with an if statment with a set analysis within??

    Hi,I have a problem using set-analysis. In a pivot table with SKOLENR as dimension i have 2 expressions that works:Expression 1:=count(DISTINCT{1<GRLI... Show More

    Hi,

    I have a problem using set-analysis. 

    In a pivot table with SKOLENR as dimension i have 2 expressions that works:

    Expression 1:

    =count(DISTINCT{1<
    GRLID = {"20200303ex"},
    ONSKENR = {1},
    SKOLENR = {">=98 <=104"}
    >
    } Rnr)

    Expression 2:

    =count(DISTINCT{1<
    GRLID = {"20200303ex"},
    ONSKENR = {1},
    SKOLENR = {">=98 <=104"},
    KOMMNR = {">=1400 <=1499"}
    >
    } KOMMNR)

    So far so good. and I for example get that it is 57 Rnr at SKOLENR 98, and 7 KOMMNR at the same SKOLENR.

    Then the problem starts. For each SKOLENR I want to now how many KOMMNR there is where the number of Rnr is greater than 5.

    I hope someone can help me, even if it is summer!

    Regards,

    Torbjørn 

    Show Less
  • forum

    New to Qlik Sense

    Load Script error?

    Hello all,I am hoping someone can point out what I am clearly missing with load script.I am the following which creates a master linked table.  Let vA... Show More

    Hello all,

    I am hoping someone can point out what I am clearly missing with load script.

    I am the following which creates a master linked table.

     

     

    Let vAssociationTableName = 'AssociationTable';
    
    $(vAssociationTableName):
    LOAD * INLINE [
    _FactCounter
    1
    ] WHERE 1 = 0;
    
    LET vNoOfTables = NoOfTables();
    FOR vTableNumber = 0 to ($(vNoOfTables) -1)
    LET vTableName = TableName($(vTableNumber));
    LET vTempTableName = '$(vTableName)';
    IF Right('$(vTableName)',7) = '_NOLOAD' THEN
    LET vTempTableName = Left('$(vTableName)',(Len('$(vTableName)')-7));
    END IF
    LET vFactFieldName = '_Fact_' & '$(vTempTableName)' & 'Key';
    IF FieldNumber('$(vFactFieldName)','$(vTableName)') > 0 THEN
    LET vLoadString = 'CONCATENATE (' & '$(vAssociationTableName)' & ') ' & Chr(13) & Chr(10) & 'LOAD DISTINCT ' & '$(vFactFieldName)' & Chr(13) & Chr(10);
    LET vNoOfFields = NoOfFields('$(vTableName)');
    FOR vFieldNumber = 1 to $(vNoOfFields)
    LET vFieldName = FieldName($(vFieldNumber), '$(vTableName)');
    IF Left('$(vFieldName)',1) = '_' AND Right('$(vFieldName)',2) = 'ID' AND Left('$(vFieldName)',6) <> '_Fact_' THEN
    LET vStringStart = Index('$(vFieldName)','_',-1);
    LET vStringEnd = (Len('$(vFieldName)') - 2);
    LET vStringLen = $(vStringEnd) - $(vStringStart);
    LET vThisField = Mid('$(vFieldName)', ($(vStringStart)+1), $(vStringLen));
    LET vThisFactField = '_Fact_' & '$(vThisField)' & 'Key';
    IF '$(vThisFactField)' <> '$(vFactFieldName)' AND ISNULL(TableNumber('$(vThisField)')) = 0 THEN
    LET vLoadString = '$(vLoadString)' & ',' & '$(vFieldName)' & ' AS ' & '$(vThisFactField)' & Chr(13) & Chr(10);
    END IF
    END IF
    NEXT ;
    LET vLoadString = '$(vLoadString)' & ', ' & 'TableName($(vTableNumber))' & ' AS _FactType' & Chr(13) & Chr(10);
    LET vLoadString = '$(vLoadString)' & ',1 AS _FactCounter' & Chr(13) & Chr(10);
    LET vLoadString = '$(vLoadString)' & 'RESIDENT ' & '$(vTableName)' & ';' ;
    $(vLoadString)
    End If
    NEXT ;

     

    The script is adding pink highlight to the last "End if" as seen below, but I can not figure out why. I should also add that it runs fine and does what I am aiming to do.

    What are your thoughts?

    Thank you in advance.

     

    loadscriptError.PNG

    Show Less
  • forum

    New to QlikView

    How to link text box and show data based on certain selection

    Hi,I got a requirement to develope a helpdesk dashboard. One of requirement for the dashboard is to link text box and show the data based on filter in... Show More

    Hi,

    I got a requirement to develope a helpdesk dashboard. One of requirement for the dashboard is to link text box and show the data based on filter in table. I've been looking for the solution but still can't get it. 

    Example as per below: 

    If I click on view details text, then the detail list of high priority data will be display in table in other sheet.

    Lily_1-1594194776169.png

    Lily_2-1594194801393.png

    https://demos.qlik.com/qlikview/HelpdeskManagementQV?q=helpdesk

    Any solution to do that? 

    Thank you for your help. 

    Show Less
  • forum

    New to Qlik Sense

    Line Chart - Multiple Measures

    Hi, I have a line chart which uses 2 x Dimensions (1 x Group and 1 x Line).However, I only have the option to include one measure. Is there anyway of ... Show More

    Hi, 

    I have a line chart which uses 2 x Dimensions (1 x Group and 1 x Line).

    However, I only have the option to include one measure. Is there anyway of adding in another measure without it being an alternative view please?

     

    Show Less
  • forum

    New to Qlik Sense

    MinString Date

    hi, tell me please how i can use MinString(B) to get the result:2020-01now I get: 2019-01I should get min a date where column A is not null 
  • forum

    QlikView Scripting

    How to load a table with month stored above headers?

    Hi QV Experts, my first post and new to QV scripting. I am trying to load the below sample data with the "month-year" under Header 5 (as Month), every... Show More

    Hi QV Experts, my first post and new to QV scripting. I am trying to load the below sample data with the "month-year" under Header 5 (as Month), every line to repeat (Sep-19) but unsure how to script this in the code. 

    Loading the headers and the data content is easy. 

    I have multiple tables/files to load across in the same format too. 

    Appreciate the help! Cheers 

       Sep-19
    Title   
    Header 1Header 2Header 3Header 4
    a124
    b235
    c346
    d457
    Show Less
  • forum

    Qlik Server Side Extensions Discussions

    R integration in qlik sense desktop not working?

    Hi Friends,I have installed R in my qliksense desktop(April 2020 release) following all the steps mentioned in the attached document. and also downloa... Show More

    Hi Friends,

    I have installed R in my qliksense desktop(April 2020 release) following all the steps mentioned in the attached document. and also downloaded the sample app Airline Passengers and Iris species app but I am not able to see the chart in these app. It is giving an error message 'Client specified an invalid argument'. Did anybody face the same issue? Could somebody please suggest if I need to redo the installation process ?Where am I getting wrong?

    Thanks 

    Shilpa

    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