Qlik Community

Welcome to Qlik Community

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

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!

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

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.

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!

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

Recent Discussions

  • No Boards Found
  • forum

    QlikView Creating Analytics

    Figer des données dans une formule

    Bonjoursur un graphe je voudrai figer des autres critères comme la raison: retard prod, le secteur qui s'appelle Sticky et Mixing et j'aimerai compter... Show More

    Bonjour

    sur un graphe je voudrai figer des autres critères comme la raison: retard prod, le secteur qui s'appelle Sticky et Mixing et j'aimerai compter le nombre de raison

    voici ce que j'ai écrit mais cela ne me prend que le critère prod 

    = count ({$ <Reason = {'retard prod'}> + 1 <secteur = {'Sticky'}> + 1 <secteur = {'Mixing'}>} [Reason])

    est ce que quelqu'un aurait la solution svp?

     

    Show Less
  • forum

    Qlik Sense Deployment & Management

    Very high cpu usage in Central Node repository service

    We are on Qs Nov 2019 patch 3Sometimes the repository service at our central node starts running at 90-100% cpu usage for a period.When this happens t... Show More

    We are on Qs Nov 2019 patch 3

    Sometimes the repository service at our central node starts running at 90-100% cpu usage for a period.

    When this happens the QMC becomes unresponsive.

    If we are lucky, the CPU usage goes down after 10-20 minutes, but sometimes we have to kill and restart the service.

     

    Does anyone knows what can cause this?

    We tried to find something in the logs, but haven't seen anything specific for these periods.

    Show Less
  • forum

    New to QlikView

    How to change values based on the field values without selections in text box

    Hi All,I have data like Year, Month, Incremental and Sales data is there.Years like 2018,2019,2020 and 2021 and every years having months data and inc... Show More

    Hi All,

    I have data like Year, Month, Incremental and Sales data is there.

    Years like 2018,2019,2020 and 2021 and every years having months data and incremental field is having Yes, No .

    Current year is 2020 and incremental data is having Yes, No.

    I want to see the data like if Incremental is Yes or No or Yes/No in text box with current year and same thing like i want to see the Sum of sales also.
    for example 2020 is having Incremental is having Yes and No then i want to see 2020 Yes/No in text box.
    if incremental values is having all months yes then 2020 Yes.

    I want to change dynamically  I tried below code.

    '2020'& if(ONLY({<Incremental={"Yes"}>} Incremental)='Yes' ,'Yes', if(ONLY({<Incremental={"No"}>} Incremental)='No', 'Y/N')).

    But some it is showing either Yes or No. but current i am having Incremental data is yes and No then i want to see Yes/No .

    Please suggest me how to achieve this scenario.
    Please see the below example for your reference.
     

     

    Thanks & Regards,

    Lakshman

    Show Less
  • forum

    New to QlikView

    How to write the condition for to separate and create Q1-2020 from Submissions o...

    Please help on to separate and create Q1 - 2020 from Submissions of Q1 2020 using subfieldField name = QuarterQuarter =Submissions of Q1 2020,Submissi... Show More

    Please help on to separate and create Q1 - 2020 from Submissions of Q1 2020 using subfield

    Field name = Quarter

    Quarter =Submissions of Q1 2020,Submissions of Q2 2020,Submissions of Q3 2020

    Requirement =Q1 - 2020,Q2 - 2020,Q3 - 2020

     

    Show Less
  • forum

    New to Qlik Sense

    Cannot connect points on graph

    Hello, first of all I want to apologies for my English, didn't practiced for a long time, but I will try to explain.I need to make a graph which repre... Show More

    Hello, first of all I want to apologies for my English, didn't practiced for a long time, but I will try to explain.

    I need to make a graph which represents correlation between price of product and different types of Inflation on same graph. The issue is, Qlik Sense doesn't want to connect some points to make a graph, leaving just some points.  I've tried to switch of "include null values", but it connects only few points, not all. My assumptions about this problem:

    1. It seems that Qlik Sense thinks, that there missed information and don't know how to fill gaps.

    2. There also might be a problem with the format. I mean that I have results for product price weekly, while inflation rate counts monthly. However, my results represented in DD.MM.YYYY form, like I have results for price for 01.01.2020, 07.01.2020, 15.01.2020 and so on, while inflation rate represented by the first day of each month. Like this:

    DateProduct Price
    01.01.2020123
    07.01.2020345
    15.01.2020678

    and the second table

    DateInflation 1 Inflation 2 Inflation 3 Inflation 4
    01.01.20200.70.20.70.4
    01.02.20200.30.10.50.9
    01.03.20200.40.20.40.3

     

    So, it looks like this format some how breaks the logic of Qlik Sense and it starts to thinks that there are some missing data. This assumption is supported by the last three points of Inflation rate, last three points are connected on all three inflation rate graphs, where I don't have any data for product price. 

    So, my question is, is there a way I can fix it? Thank you in advance

    Show Less
  • forum

    New to QlikView

    Use previous to compare data records from previous year and month

    Hello everyone, Basically what i want to do about this data set is the following oneIf the sameID appears in the previous year and month  with value >... Show More

    Hello everyone,

     

    Dashboard - Qlik Issue E.permanent.JPG

    Basically what i want to do about this data set is the following one

    If the sameID appears in the previous year and month  with value >0 and appear also in current year with the previous month as well with value > 0 then it gets '1' in the column permanent staff.

    I would like to do it in the script just to have a brand new column permanent staff but i don't know how i could do that ?

     

    In my script it is this 

    // LIB CONNECT TO 'BO_DATABASE';

    // LOAD YEAR,
    // MONTH,
    // ID,
    // Value,
    // if(ID = Previous(ID) and ANNEE = Previous(ANNEE)+1
    // and MONTH = Previous(MONTH) and Value >0 and Previous(Value)>0, 1, 0) as PermanentStaff;

    // [DATA_TABLE]:
    // SELECT "YEAR",
    // "MONTH",
    // "ID",
    // "Value"
    // FROM SAP_BO_DATABASE;


    // // UNTITITLE:
    // // LOAD*,
    // // if(ID = Previous(ID) and YEAR = Previous(YEAR)+1
    // // and MONTH = Previous(MONTH) and Value >0 and Previous(Value)>0, 1, 0) as PermanentStaff
    // // Resident [DATA_TABLE];
    // // Drop Table [DATA_TABLE];

     

    But i get PermanentStaff field with zero value everytime.

    Where i sample small data like this,

     

    Temp:
    Load * Inline
    [
    ID, Year, Month, Value
    180, 2019, 1, 55
    181, 2019, 2, 0
    182, 2019, 3, 65
    183, 2019, 4, 0
    184, 2019, 5, 65
    180, 2020, 1, 58
    181, 2020, 2, 87
    182, 2020, 3, 47
    183, 2020, 4, 88
    184, 2020, 5, 89
    ];

     

    I get the field "permanent staff" right but it doesn't come from a SAP BO Database.

    ANyone could help me.

     

    Show Less
  • forum

    New to Qlik Sense

    Converting numbers to days in expression

    Hi All,,I have a requirement . i have written one expression sum(actuals) and the result gives me in a number. but i have to convert that number into ... Show More

    Hi All,,

    I have a requirement . i have written one expression 

    sum(actuals) and the result gives me in a number. 

    but i have to convert that number into days. 

    if FTE i calculated as Sum({<Metric _Name = {'FTE'}>}Actuals) i need to get the result in days. 

     

    REgards

    srujana

    Show Less
  • forum

    Qlik Sense Deployment & Management

    Can I set N Trigger for 1 task

    Hello, everyone.I'd like to ask for an answer from anyone.I want to reload 1 app 3 times every day at 10, 10:30 and 10:50.So I made up 3 triggers by s... Show More

    Hello, everyone.

    I'd like to ask for an answer from anyone.

    I want to reload 1 app 3 times every day at 10, 10:30 and 10:50.

    So I made up 3 triggers by setting 1 task as Daily.

    I wonder if this is the right way.

    Show Less
  • forum

    Qlik Sense Integration, Extensions, & APIs

    QS 2019 how to kill sessions

    Hi,I have a web portal (in Angular) where I am opening QS hub in a hidden iframe so the user gets authenticated that way (not the perfect way). this p... Show More

    Hi,

    I have a web portal (in Angular) where I am opening QS hub in a hidden iframe so the user gets authenticated that way (not the perfect way). this page has a link that when clicked, opens another page that displays list of Qlik apps user has access to. I am calling engine APIs to get list of apps etc. i recently upgraded to June 2019 version of QS.

    On and off, some of the users are having issues where session count is going above 5. i can see the errors in repository logs. I can also see the error in chrome console saying QS 400 error, as the hub cannot open in iframe. Also, we asked users to use Chrome all the time, but after this error, they switched to firefox and it works there for some reason !! why it works when it's above 5 sessions?

    Session inactivity timeout : 30 mts, and using SAML auth. (ExcelUDC) 

    what is the solution for this ? how can i kill those sessions ? or should i go for an actual authentication method instead of opening QS in iframe like this? I do not know how/which authentication api to use with engine APIs.

    please advise. 

    thanks.

    Show Less
  • forum

    Qlik Sense App Development

    Auto selection in Filter Qliksense

    Hi Everyone,I have a requirement in Qliksense to select a value in a filter based on a selection from another filter. ( Similar to 'select in field'  ... Show More

    Hi Everyone,

    I have a requirement in Qliksense to select a value in a filter based on a selection from another filter. ( Similar to 'select in field'  - field event triggers in Qlikview)

    My table is designed as following. 

    Requirement :

    1. Defined value: If I choose 'Product 1' in Column 1, I wanted to reset the selection in Column 2 and have 'All' selected in 'Column 2'

    2. Min String: If I choose 'Product 1' in Column 1, I wanted to reset the selection in Column 2 and have the min string selected 'Sub Product 1a' selected in 'Column 2'

    Could you share your thoughts 

    Column 1Column 2Column 3
    Product 1ALL30
    Product 1Sub Product 1a10
    Product 1Sub Product 1b10
    Product 1Sub Product 1c10
    Product 2ALL60
    Product 2Sub Product 2a20
    Product 2Sub Product 2b10
    Product 2Sub Product 2c30
    AllAll90

     

    Thank you.

    Show Less

Top Participants

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.

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

Data Revolution Virtual Summit

The new normal requires a new approach to data. Join this event to learn about the latest trends and approaches for accelerating value from your data.

October 27 - 29, 2020 Virtual Summit

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