Qlik Community

Welcome to Qlik Community

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

Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.

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 eight unique blogs. Check out the new Architecture Deep Dive Blog!

Find a forum to ask a question or start a discussion.

Discussion Boards and Documents for Qlik Services.

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

Discussion board and documents related to Qlik Associative Big Data Index.

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.


Introducing Qlik Gallery

Announcing the newest addition to the Qlik Community, Qlik Gallery!

Qlik Gallery is all about sharing – apps, outcomes, and ideas. This is your space to learn from each other as Qlik users, fans, thought leaders and data enthusiasts

Recent Discussions

  • New to Qlik Sense

    Frequency count in Filter Pane

    Hi Team,I would like to see frequency of each value in Filter pane(Qliksense).How it can be possible?Example: In Qlikview we can see frequency of each... Show More

    Hi Team,

    I would like to see frequency of each value in Filter pane(Qliksense).How it can be possible?

    Example: In Qlikview we can see frequency of each value in list box by checking the show frequency option.

     

    Regards,

    Masthan

     

    Show Less
  • QlikView Scripting

    My date field D/M/YY How to recode ?

    Hi AllMy date field as below :-MonthD/M/YYI try below , it does not work :-Date( Date#([Month], 'DD/MM/YY'), 'DD/MM/YYYY') as [date],Hope some one can... Show More

    Hi All

    My date field as below :-

    Month

    month.png


    D/M/YY

    I try below , it does not work :-

    Date( Date#([Month], 'DD/MM/YY'), 'DD/MM/YYYY') as [date],

    Hope some one can advise me.

    Paul Yeo

    Show Less
  • Community Corner

    Qliksense QMC & Hub Access was denied error after migration.

    Hi All,After migration Qliksense server Nov2019 from one machine to another with the same version. Facing Access was denied the issue after 6-7 hours ... Show More

    Hi All,

    After migration Qliksense server Nov2019 from one machine to another with the same version. 

    Facing Access was denied the issue after 6-7 hours of migration.

    Follow all the steps which are given on link:-  https://support.qlik.com/articles/000041283

    After doing all the steps QMC & Hub both works properly. After 6-7 hours it starts showing the attached error on both HUB & QMC.

     

    Show Less
  • Qlik Sense App Development

    Select a range of dates using a Qlik Sense button

    Greetings community. I need to use a button in QlikSense to select a range of dates (for example from 01/01/2019 to 12/31/2019): The variables From... Show More
    Greetings community.
    
    
    
    I need to use a button in QlikSense to select a range of dates
    (for example from 01/01/2019 to 12/31/2019):




    1a.jpg

     

    The variables From and To are controlled without problem:

     

    2a.jpg

     

    The problem I have is that there is only one field for this type of object 
    and I am not getting to stop selecting the full range of dates
    ... (365 days of the selected year):

     

    2.jpg

     

    In case someone has created this type of object in QlikSense before 
    and can enlighten me I would appreciate it .... Thank you!

     

    Show Less
  • Qlik Sense App Development

    How to display the most recent entries by selection for each id

    Hello,I have a complex (maybe only for me) situation. The sample data in a straigth table is:idcontract_identry_datesign_datechange_datesign_flagchang... Show More

    Hello,

    I have a complex (maybe only for me) situation. The sample data in a straigth table is:

    idcontract_identry_datesign_datechange_datesign_flagchange_flag
    112017-09-112017-09-11 10
    222019-01-012018-08-282019-01-0101
    322018-08-282018-08-28 10
    432019-05-062019-05-06 10
    542015-01-062015-01-062015-01-0601
    642017-01-012015-01-062017-01-0101
    742020-01-012015-01-062020-01-0101
    842015-01-062015-01-06 10
    952007-03-222007-03-22 10

    It is kind of self explanatory. entry_date has values of change_date if it is not null or sign_date value if change_date is null. contract_id 4 (and it is no mistake) has been signed and changed on the same day, so it has two entries for 2017-12-30.

    On the side there is a calendar created for filtering. If the analyst selects, for example, 2017-12-30 - the table needs to show the most recent entry_date for each contract_id that is not greater than the selection.

    So, for the selection of 2017-12-30, the table needs to look like this:

    idcontract_identry_datesign_datechange_datesign_flagchange_flag
    112017-09-112017-09-11 10
    642017-01-012015-01-062017-01-0101
    952007-03-222007-03-22 10

    Only one entry per contract needs to be displayed. If the analyst selects 2015-01-06, the table needs to look like this:

    idcontract_identry_datesign_datechange_datesign_flagchange_flag
    542015-01-062015-01-062015-01-0601
    952007-03-222007-03-22 10

    This needs to be done in expressions, since it is based on selection. Any help would be appreceated.

    Show Less
  • QlikView Scripting

    macro to replace character in field table

    Im creating a table in macro and and I have to replace all the "," for ";" in all column and rows using macro. How can I do that? 
  • Qlik Sense Integration, Extensions, & APIs

    Plotly in Qlik Sense Extension - SyntaxError: Unexpected token '<'

    Hello everybody,I'm currently trying to integrate Plotply into Qlik. However, I always get the error message: "Uncaught SyntaxError: Unexpected token ... Show More

    Hello everybody,

    I'm currently trying to integrate Plotply into Qlik. However, I always get the error message: "Uncaught SyntaxError: Unexpected token '<'".

    The Plotply script works outside of Qlik, so I assume that the problem belongs to Qlik himself or my programming skills in Qlik. ;D

    This is how I integrated it into Qlik:

    define( [
            'jquery',
    		'qlik',
    		'Plotly'
        ],
        function ( $, qlik, Plotly ) {
            'use strict';
    
            return {
    
                paint: function ( $element, layout ) {
    
    				$element.empty();
    				
    				$(document).ready(function() {
    					var s = document.createElement("script");
    					s.type = "text/javascript";
    					s.charset = 'utf-8';
    					s.src="https://cdn.plot.ly/plotly-1.2.0.min.js";
    
    					$("head").append(s);
    					
    				});
    				
    //############################Other Stuff
                }
            };
    });

    That's how I call it (Simple example from the Plotply page: https://plot.ly/javascript/getting-started/😞

    TESTER = document.getElementById('tester');
    Plotly.plot( TESTER, [{
    x: [1, 2, 3, 4, 5],
    y: [1, 2, 4, 8, 16] }], {
    margin: { t: 0 } } );

    After calling "Plotply.plot (TESTER ...);" I get the following error message: "Uncaught ReferenceError: Plotly is not defined". I think that's because there were problems interpreting the script...

    Can you detect a mistake? The current version with the link "https://cdn.plot.ly/plotly-latest.min.js" and as local  plotly-latest.min.js doesn't work either.

    Thank you very much for your help and have a nice weekend

    A456B123

    Show Less
  • New to Qlik Sense

    How can I count something under certain conditions?

    Dear All,I would like to count how many technicians worked a daySick technicians are to be deducted from this figure.So my formula: Count(Distinct(TEC... Show More

    Dear All,

    I would like to count how many technicians worked a day
    Sick technicians are to be deducted from this figure.

    So my formula: Count(Distinct(TECHNIKERNAME))

    So far it will calculated correctly.

    But how can I deduct the number of technicans where the Job result is "Sick"?

    Show Less
  • QlikView Scripting

    How to create Year Month wise Qvd dynamically

    Hi,I have requirement to create year wise qvd dynamically.EX:-if Source file:-  Market.xlsIn Market file have contain multiple year (Like year field c... Show More

    Hi,

    I have requirement to create year wise qvd dynamically.

    EX:-if Source file:-  Market.xls

    In Market file have contain multiple year (Like year field contain 2010 to 2019 )

    So i need to create qvd like :- Market_2010_Jan.qvd,...Market_2011.qvd_Jan,....Market_2019_Dec.qvd

    Show Less
  • New to Qlik Sense

    Complex (impossible?) expression

    Hello Everyone,I have a problem with an expression today . I think what Iwant to achieve is impossible but.. But maybe someone will have a magical ide... Show More

    Hello Everyone,

    I have a problem with an expression today . I think what Iwant to achieve is impossible but.. But maybe someone will have a magical idea 😉 ?

    We sell a product  with a base on wich can be added options.

    Information are stored in a database in 2 differents tables :

    1 stored the SN (serial number of a system - unique indentifier of a system sold) with global options selected by the customer , Attention the customer can begin with Base system with or not options and in the future he can add Options, it will be still 1 line but add info to the SN : simplified exemple :

    BASE 1 :

    SNBaseOPTION 1OPTION 2OPTION 3
    11111101
    22221111
    333311 1
    44441001
    55551001
    6666100

    1

     

    If I want the total of Option 3 in the market : answer is 6

    Now I want have the number of this option 3 (or even system it is the same problem), sold per year or month, 

    I have an other database , which store every Orders by SN and date.

    So every time I have an entry it is a new line, If a customer update his system or add a new options :

    SNOrder Date
    11111janv-05
    22222mars-06
    33333juin-07
    44444janv-07
    55555mai-07
    66666mars-08
    11117juin-08
    33338juin-09
    22229juil-10
    222210mars-11
    111111juil-12

     

    Problem :

    I joined the 2 tables with Qlik to chart my sales per year or month.

    But If I make a chart to display the number of Options 3 or Systems per year for example (or month), The total through the years will be 11 instead of 6 because it will show every orders of Systems with the Option 3 for example. (If I want numbers of Option 1 instead by years, the real total is 3 but if I am charting it by years, it will display a total of 8 (because it will show every orders containing SN with option 1).

    The only solution I came up with was to do something like :

    To have Options 3 sold in 2012 for example

    (Total of Options 3 from year 0 to year 2012) - (Total of Options 3 from 0 to 2011)

    But this will give me number but I can't chart it anymore by using standard chart with Date as a dimension... Right ?

    I know it is not easy to understand but if somebody has an idea :)... 

     

    Show Less

Blogs

Qlik Community Manager Blogs

Hear from the Qlik Community team about the latest platform enhancements, announcements, and more.

Blogs

Qlik Education Blog

Check out the latest Education Blog written by Kevin Hanegan,Qlik Chief Learning Officer.

Blogs

Blogs

Hear directly from Qlik employees and stay current on the latest and greatest information about Qlik products. We have 8 blog types for you to choose from.

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 Insider Webinar Series

What's New in 2019. Register for the Qlik Insider Webinar Series to stay connected on our latest releases

Available On Demand Webinar

Events

Events & Meetups

Participate in an upcoming Qlik related event, webinar, or local meetup.

Events

Welcome to Qlik

Join the “Welcome to Qlik” webinar and learn about the Qlik Ecosystem

Tuesday, August 27, 2019 Webinar