Qlik Community

Ask a Question

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
3,765 online
Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources. Prep for the big move: READ DETAILS

Data Analytics

Forums for Qlik Data Analytics solutions. Ask questions, join discussions, find solutions, and access documentation and resources.

Data Integration

Forums for Qlik Data Integration solutions. Ask questions, join discussions, find solutions, and access documentation and resources

Qlik Academic Program

Qlik gives qualified university students, educators, and researchers free Qlik software and resources to prepare students for the data-driven workplace.

Qlik Gallery

Share your best Qlik apps and discuss impacts with peers! Show your work and get recognized for innovative uses of Qlik technologies.

Ideation

Participate in Qlik Technical Previews, submit ideas, and review documentation.

Events

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

Groups

Join a Group that is right for you and get more out of your collaborations. Some groups are closed. Closed Groups require approval to view and participate.

About

Get started on Qlik Community, find How-To documents, and join general non-product related discussions.

Blogs

Hear directly from Qlik employees in our ten unique blogs.

Qlik Resources

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

Support

Access Support programs, Knowledge Base, Updates blog, and Release Notes.

Community Sitemap

Here you will find a list of all the Qlik Community forums.

Recent Discussions

  • No Boards Found
  • forum

    App Development

    Script Load rows for to 4 Values in field

    I need to load only rows which fall into the top 4 values in a fieldRisks:RiskIDScore123450123524123645123745123827123932124035 So for the above table... Show More

    I need to load only rows which fall into the top 4 values in a field

    Risks:

    RiskIDScore
    123450
    123524
    123645
    123745
    123827
    123932
    124035

     

    So for the above table, I only need to load RiskID 1234, 1236, 1237, 1239, 1240 as the scores fall into the top 4 for the field

     

    |Regards

     

    Show Less
  • forum

    New to Qlik Sense

    Sum YTD

    I'm a little embarrassed to be asking, but I'm having some issues creating a year to date sum using Set Expression. I have a field Amount that I would... Show More

    I'm a little embarrassed to be asking, but I'm having some issues creating a year to date sum using Set Expression.

     

    I have a field Amount that I would like to do a YTD sum, with dates ranging from 01/2021 to 12/2021 called FinPeriod. I've been scratching my head all afternoon trying to come up with the expression and it's just not coming together, could someone please point me in the right direction?

     

    Cheers

    Show Less
  • forum

    New to Qlik Sense

    How to create a stacked bar chart coming from 2 tables - Qlik sense

    Hi All! I have a two tables. I have created stacked bar chart from 1 table. I want to add one more on this stacked bar chart and the amount is coming ... Show More

    Hi All! 

    I have a two tables. I have created stacked bar chart from 1 table. I want to add one more on this stacked bar chart and the amount is coming from a different table. 

    manisha10_0-1632381448504.png

    Stacked bar chart from table 1: 

    manisha10_1-1632381472191.png

    Desired Output: 

    manisha10_2-1632381522587.png

     

    Thank you!

    Qlik Sense Business 

    Show Less
  • forum

    New to Qlik Sense

    Number Format

    Hi Qlik,I've below two columns in my Dimension value which needs to be format to 00.0% format. Ex: 23.1%  (Need one decimal with %).My original value ... Show More

    Hi Qlik,

    I've below two columns in my Dimension value which needs to be format to 00.0% format. 

    Ex: 23.1%  (Need one decimal with %).

    My original value is 

    MuraliPrasath_0-1632407088618.png

    Any help would be highly appreciated. thanks!

    Show Less
  • forum

    Deployment & Management

    Not able to duplicate own apps with Load Balancing

    Hi Folks,we have a problem in a clustered enviroment: Users are not able to duplicate their own apps in the hub in their own workspace.They get this e... Show More

    Hi Folks,

    we have a problem in a clustered enviroment:

    Users are not able to duplicate their own apps in the hub in their own workspace.
    They get this error:
    2020-08-20 11_39_00-DELIN-QlikView-DEV - Remote Desktop Connection - __Remote.png

    The cluster is with a central node and 2 rim nodes (PRD and DEV).
    All node purposes are on "both".
    The virtual proxy of the central node has the rim node engines for load balancing.

    All published Apps should be run on the PRD node and unpublished apps should be run on the DEV node.
    The Load Balancing rules are as follows:

    Load Balancing RulesLoad Balancing Rules

    Qlik Support told me this:

    1. The engine used to duplicate the app doesn't have "permissions" to create the app in "my work"
    2. When you try to duplicate the app in the stream, it will use the engine on the PROD node, but that engine is not able to create the app in "My work" as per LB rules
    ​3. Only the engine on DEV node is allowed to do that with those LB rules
    ​4. You can create an app because create an app will use the engine on the DEV node.
    5. When you duplicate, it can only use 1 engine to do the whole process, and the PROD engine doesn't have rights to create apps in my work

    So, ok now I know what is causing the problem but I still do not have a solution.
    Unfortunately they could not help me further, so I am trying my luck here 🙂

    Does anybody have an idea?

    Show Less
  • forum

    New to Qlik Sense

    Qlik Sense Performance Logging-Warning Level

    I want to automate Qlik Sense Engine Logging to Warning Level by using a script. I found some related documentations here:https://community.qlik.com/t... Show More

    I want to automate Qlik Sense Engine Logging to Warning Level by using a script. I found some related documentations here:

    https://community.qlik.com/t5/Knowledge/How-to-enable-Qlik-Sense-QIX-performance-logging-and-use-the/ta-p/1711405

    https://community.qlik.com/t5/Knowledge/How-to-enable-QlikView-QIX-performance-logging/ta-p/1716038

    https://community.qlik.com/t5/Knowledge/How-to-enable-Qlik-Sense-Desktop-debug-level-logging/ta-p/1798988

     

    Following the above guides, I put the following lines in C:\ProgramData\Qlik\Sense\Engine\Settings.ini

    [Settings 7]
    SystemLogVerbosity=2
    WarningProcessTimeMs=30000
    ErrorProcessTimeMs=60000
    WarningPeakMemory= 1073741824
    ErrorPeakMemory= 2147483648

    But it does not work even after I restart Proxy service and/or engine service. Is there some way I can automate this configuration? Doing manually using GUI is not an option!

    Show Less
  • forum

    New to Qlik Sense

    Without selection previous quarter in pie chart dynamically

    Hii Guys,I have pie chart, I want to show the previous quarter values in pie chart without any selection by expression its change dynamic,when user op... Show More

    Hii Guys,

    I have pie chart, I want to show the previous quarter values in pie chart without any selection by expression its change dynamic,when user open the dashboard ,with selection it's show accordingly.

    Can help me this anyone please.

    Thanks in advance.

    Regards,

    Subba

    Show Less
  • forum

    QlikView App Dev

    Data Mapping Issue

    Hi All,Can some help me with below scenario..I have 2 tables 1. Employ table with employ no, country and date(date when he was present in that country... Show More

    Hi All,

    Can some help me with below scenario..

    I have 2 tables 

    1. Employ table with employ no, country and date(date when he was present in that country).

    Emp_NoEmp_Start_DateCountry
    10017/05/2008UK
    10004/02/2009US
    10009/07/2010AUS

      2. Insider table with employ no, incident number(issues he worked on) and incident_created_date(when that issue was raised).

    Emp_NoIncident NumIncident_Created_date
    1001017/05/2007
    1002017/05/2007
    1003031/07/2007
    1004007/05/2008
    1002311/06/2008
    1003211/06/2008
    1001112/01/2009
    1002104/02/2009
    1003114/01/2010
    1002418/06/2010
    1005309/07/2010

     

    Now i want to join both the tables and get Country field in Insider table. 

    Based on Incident_Created_date <= Emp_Start_Date

    i.e.  for Incident_Created_date <= 17/05/2008 Country should be UK

             Incident_Created_date <= 04/02/2009 Country should be US

            Incident_Created_date <= 09/07/2010 Country should be AUS

    Emp_NoIncident NumIncident_Created_dateCountry
    1001017/05/2007UK
    1002017/05/2007UK
    1003031/07/2007UK
    1004007/05/2008UK
    1002311/06/2008US
    1003211/06/2008US
    1001112/01/2009US
    1002104/02/2009US
    1003114/01/2010AUS
    1002418/06/2010AUS
    1005309/07/2010AUS

     

    Thanks in Advance,

    Show Less
  • forum

    New to Qlik Sense

    Quarter wise lines

    Hii guys,I am new in Qlik senses.I have a bar chart, dimension is month,I want show the lines in quarter wise.Example:  Q1 Jan,Feb, March after line ,... Show More

    Hii guys,

    I am new in Qlik senses.

    I have a bar chart, dimension is month,I want show the lines in quarter wise.

    Example:  Q1 Jan,Feb, March after line ,next bars Q2 April, May, Jun, after line,how to implement this line in quarter wise.

    Plese help me anyone.

    Thanks in advance 🙏

    Regards,

    Subba

    Show Less
  • forum

    Qlik NPrinting Discussions

    Qlikview User name in Footer

    Hi Team,                I am new to NPrinting and i am facing the issue on User name in NPrinting Footer. Tasks : Need to show QVuser name in NPrintin... Show More

    Hi Team, 

                   I am new to NPrinting and i am facing the issue on User name in NPrinting Footer. 

    Tasks : Need to show QVuser name in NPrinting. 

    Please refer below my Steps(but i am not getting what i am expected)

    1. Created One variable in Qlikview (vPrepared By = 'Prepared By: ' & Subfield(OSUser(),'\',2) 

    2. Value is showing as Prepared By: Sakthivel. Selvaraja 

    3. Taking this variable in Nprinting Variable. 

    4. If I Use this variable in Qlik Nprinting it is showing as NPAdmin(which is Nprinting Admin User)

    5. But what my expectation is shown as the same above which is Prepared By: Sakthivel.Selvaraja. 

     

    Will anyone help me to resolve this . It is very urgent

     

    Thanks and Regards, 

    Sakthivel.S

    Show Less

Get Started On Community

Start Here Get Started On Community

Top Participants

Blogs

Product Innovation Blog

Learn about what's new across all of the products in our growing Qlik product portfolio.

Blogs

Qlik Community Manager Blog

Hear from the Qlik Community team about the latest platform enhancements and other topics.

Blogs

Support Updates Blog

Important and useful support information about end-of-product support, new service releases, and general support topics.

German Group

Deutsche User Group

German speaking - This group makes it easier to collaborate in your local language.

Request to join

Brazil Group

Brazil

This group for Brazil users. All discussions are in Portuguese.

open to all

Industry Group

Public Sector Group

This is a open Group for the Public Sector

All are welcome

Events

Espresso Webinars - From Data Integration to Analytics in Action

These webinars get straight to the point, they are strong, short, and with immediate effect – like an espresso.

Upcoming and On-Demand

Events

Talk to Experts Tuesday

You’ve got questions? We’ve got answers! Talk to Experts is a live Q&A Webinar series! Join and ask your questions about Qlik Sense Enterprise, Client Managed.

June 29, 2021 10AM EST

Events

Cloud Data and Analytics Tour

Ready to steer your business towards data-informed growth? Our Cloud Data & Analytics Tour is the perfect place to start your journey.

Choose your Region