Qlik Community

Welcome to Qlik Community

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

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.


Make Your Data Dance - Virtual Forum 2019

You’re managing more data than ever before. But are you getting the insights you need? The Qlik Virtual Forum is here to help you take control and make your data dance.

Recent Discussions

  • Qlik Education Discussions

    Dimensions

    Dear Friends,I have a dimension field(Month_Year) in my pivot table. I have some calculation based on measures. (shown below)here what I want is when ... Show More

    Dear Friends,

    I have a dimension field(Month_Year) in my pivot table. I have some calculation based on measures. (shown below)

    Screenshot_1.png

    here what I want is when I select a particular Month_Year in my list box   preceding 12 months  of the selected Month_Year  should appear in the columns like shown above  Eg. When I select Jun-2019 above months should be in columns. Since I am unable to modify the Dimension (Month_Year) to obtain the above output I kindly seek your help

    Show Less
  • New to Qlik Sense

    Understanding Rank in KPI

    Hi,I wish to understand how the Rank function actually works.In the table "Ranking" in attachment, I wish to get the top 5 Organization and displays t... Show More

    Hi,

    I wish to understand how the Rank function actually works.

    In the table "Ranking" in attachment, I wish to get the top 5 Organization and displays the count of the top 5 in a KPI object.

    My set analysis to get the top 5 and compute the total number of Tickets is as follows:

    =Count({<Organization = {'=Rank(Count(Ticket))<= 5' }>}Ticket)

    Logically I should be getting 10 as result (3+2+2+2+1), but I fail to understand why the set analysis returns 9!

    FYI: top 2 to top 13 results in 9

    As from top 14, result is 31

    Thanks to advise on this issue

     

    Show Less
  • New to Qlik Sense

    Tabbed container auto filtration

    Hi,Me and my team is trying to create a dashboard for our current project. I have a tabbed container object to show two types of data in the same obje... Show More

    Hi,

    Me and my team is trying to create a dashboard for our current project. I have a tabbed container object to show two types of data in the same object. However, I'm having issues as below:

    1) When one object tab is clicked, other object will be blank:

    sample1.PNG

     From the picture above, I clicked 'Risk' tab on all object, but table object for 'Risk' does not show the 'Risk' data.

    2) Is there any way to allow auto filtration of data for every object? For example, if I click 'Risk' in one of the object, then all other objects are automatically filtered by 'Risk'. This is because, our current tab need to be clicked manually on all 3 objects whenever we want to view a specific data. 

    Thanks.

    Show Less
  • New to Qlik Sense

    want to see the comparision with all unselected values against the selected valu...

    I have a table fact table that has branch id and sales amount, I want to see the sales value of all branches against the branch I selected.Fact TableB... Show More

    I have a table fact table that has branch id and sales amount, I want to see the sales value of all branches against the branch I selected.

    Fact Table

    BR_ID, Sales

    Dimension Table

    BR_ID, BR_Name

     

    Show Less
  • New to QlikView

    How to get ID and Name using Latest availavle date using Qlikview script(Please ...

    IDName StatusDate101PLANHold5/16/2019101PLANNo Issue5/9/2029102ApprovalResolved5/9/2019102ApprovalHold5/16/2019103ScopeHold5/19/2019103ScopeResolved5/... Show More
    IDName StatusDate
    101PLANHold5/16/2019
    101PLANNo Issue5/9/2029
    102ApprovalResolved5/9/2019
    102ApprovalHold5/16/2019
    103ScopeHold5/19/2019
    103ScopeResolved5/16/2019

     

    IDName StatusDate
    101PLANHold5/16/2019
    102ApprovalHold5/16/2019
    103ScopeHold5/19/2019

     

     

    Show Less
  • New to Qlik Sense

    'Start Date not found'

    Hi guys,I have the code as below:Newone:SET DateFormat='DD.MM.YYYY';Let vStartDate = Date(today()-8, 'DD.MM.YYYY');Let vEndDate = Date(today()-2, 'DD.... Show More

    Hi guys,

    I have the code as below:

    Newone:
    SET DateFormat='DD.MM.YYYY';
    Let vStartDate = Date(today()-8, 'DD.MM.YYYY');
    Let vEndDate = Date(today()-2, 'DD.MM.YYYY');
    LOAD
    Date([SalesDate]),
    [Index],
    [Item],
    if("[Quantity]">0, "[Quantity]"*-1, "[Quantity]"*-1)
    Resident [June_sales]
    where [SalesDate] >= vStartDate and [SalesDate] <= vEndDate;
    Drop Table [June_sales];

    I get the comment that field vStartDate is not found. What is wrong with this code?

    Show Less
  • QlikView App Development

    "Failed to contact QVS. make sure that the qvs is available with the correct cre...

    Hi Team,We are facing issue in QMC. When clicked on QVS we are getting error "Failed to contact QVS. make sure that the qvs is available with the corr... Show More

    Hi Team,

    We are facing issue in QMC. When clicked on QVS we are getting error "Failed to contact QVS. make sure that the qvs is available with the correct credentials "

    And not able to view folder Tab in QVS. and also User document folder is not accessible. but access point and scheduler is working. kindly help on this issue.

    Show Less
  • New to Qlik Sense

    How to add colour to expression?

    Hi experts,Can anyone tell me how to adjust the below expression so that 'Pass' is green and 'Fail' is red?=IF(Count({<SLAMet= {'Yes'}>} SLAMet)... Show More

    Hi experts,

    Can anyone tell me how to adjust the below expression so that 'Pass' is green and 'Fail' is red?

    =IF(Count({<SLAMet= {'Yes'}>} SLAMet)/Count(SLAMet)>.98,'Pass','Fail')

    Thanks!

    Show Less
  • Qlik Sense App Development

    Qlik Sense Oracle Connection load with Exists

    Hi,I have Table 1 load from QVD and I would like to load value from Oracle connection where exists from Table 1.Table1:Load DOC_ID,DOC_ID AS ... Show More

    Hi,

    I have Table 1 load from QVD and I would like to load value from Oracle connection where exists from Table 1.

    Table1:

    Load 

    DOC_ID,

    DOC_ID AS DOC_ID_DUPLICATE

    FROM LIB://.....QVD;

    Table 2:

    LIB CONNECT TO 'DB';

    LOAD DOC_ID,
    STAMP_UID,
    ;

    SELECT "DOC_ID",
    "STAMP_UID",
    FROM "BASW_PROD"."ACTION_LOG"

    WHERE EXISTS (DOC_ID_DUPLICATE, DOC_ID);

     

    Could you please help?

    Thanks

    Show Less
  • New to Qlik Sense

    Finding the hour with the maximum number of object by date

    Hello everyone,Assuming I have the following aggregated data:DateHour# of Objects06/25/1906:001006/25/1907:001506/25/1908:002006/25/1909:0025 To ... Show More

    Hello everyone,

    Assuming I have the following aggregated data:

    DateHour# of Objects
    06/25/1906:0010
    06/25/1907:0015
    06/25/1908:0020
    06/25/1909:0025

     

    To retrieve the maximum "# of objects" by date and hour, I'm using this expression:

     

    =Max(aggr(count(ObjectID),Date,[Hour (hh)]))

     

    It gives me the correct value (25), but I also want to find the relevant hour (09:00). 

    Can you assist me with this expression?

    Thanks in advance,

    Eli.

    Show Less

Blogs

Qlik Community Blogs

Check out our community blogs to stay current on the latest and greatest information about Qlik products.

7 Blogs

Groups

Join a Group

Join one of our Qlik Community groups related to an Industry, Location, Language, or Topic.

28 Groups

Events

Events & Meetups

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