Qlik Community

Ask a Question
Welcome to Qlik Community
cancel
Showing results for 
Search instead for 
Did you mean: 
2,258 online

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

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.

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.

Qlik Academic Program

Enabling professors and students with data and analytics.

About

Get started, 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

    New to Qlik Sense

    Summarize by date with drill-down to months

    I have some complex reporting I'm trying to build, and at a total loss at several parts of it. I'm totally new to Qlik Sense and, frankly, am finding ... Show More

    I have some complex reporting I'm trying to build, and at a total loss at several parts of it. I'm totally new to Qlik Sense and, frankly, am finding it horribly slow and frustrating, spending hours on what should be simple. Trying to break things down into smaller chunks, one of the difficulties I'm having is trying to get data summarized by month and year of a field (ultimately something to be calculated based on a few factors, but let's leave that out for now). 

    What I need is something like this (minus some decent formatting due to HTML limitations): 

    PlatformTracking201920202021           20222023
        JanFebMarAprMayJunJulAugSepOctNovDec  
    Location 1Planned1633 16612 449 21   83 
     Actual Complete16 33 1647         
     Recovery Month     2021-May2021-Jun         
    Location 2Planned Date402986340 983171298873101 748  10101160 
     Actual Complete40340  38317576527        
     Recovery Month    2021-May 2021-Jun         

     

    Note the tracking date across the top summarizing by year but in the current year breaking it down by month.  So far, I can't even figure out how to make Qlik show data by the month if the month is not represented in the data. Given the other built-in drill-down capabilities of Qlik, I had thought this would be something built into the tool as a commonly needed tool... summarize by year, then click on a year to expand to see the months. Am I just missing something obvious and built-in?

    Taking a little further, is there some training/tutorial on how to build something that works like the above? Perhaps I'm going about it from the wrong angle at the start. 

    Thanks!

    Show Less
  • forum

    New to Qlik Sense

    Count Where One Value is Not In Another Field

    Hello Folks, I have a datamodel that has three tables.  On the UI side, I have a straight table showing the data.  What I would like to do is count th... Show More

    Hello Folks,

     

    I have a datamodel that has three tables.  On the UI side, I have a straight table showing the data.  What I would like to do is count the number of times a value in Field A does not appear in Field B.

    For example, the data set below:

     

    AllowedTerminals:
    LOAD * Inline
    [
        'Bill To Terminal', 'Order Bill To Id'
        'GSP', 'IBM',
        'CLT', 'IBM',
    ]
    ;
    
    Orders:
    LOAD * Inline
    [
        'Order #', 'Order Bill To Id'
        '18CA7B', 'IBM'
        '63D95E', 'IBM',
    ]
    ;
    
    
    Assets:
    LOAD * Inline
    [
        'Order #', 'Tractor', 'Tractor Terminal'
        '18CA7B', '123 Freightliner', 'GSP',
        '63D95E', '900 Mack', 'LAX'
    ]
    ;
    
    EXIT Script
    ;

     

     

    In the example above, the tractor used for Order #18CA7B is terminaled at GSP.  GSP exists in the [Bill To Terminal] field that is linked to the [Order Bill To Id] of IBM.

    However, Order #63D95E used a tractor terminaled at LAX, and LAX is not in the [Bill To Terminal] list.

     

    I'm trying to get something like the following where the field CrossTerminalCount reflects the number of times this has happened.

     

    Order #Order Bill To IdTractor TerminalCrossTerminalCount
    18CA7BIBMGSP0
    63D95EIBMLAX1

     

    Order Bill To IdCrossTerminalCount
    IBM1

     

    The only solution that I can think of revolves around using the P() function, but every time my mind has gone in that direction, I've always had to backtrack.

     

    Any help is greatly appreciated.

    Show Less
  • forum

    Public Sector Group

    State dropping old COVID dashboard for new one called 'Qlik;' PBC makes request

    On Tuesday, Palm Beach County Commissioners were briefed on the new COVID-19 dashboard the state will be migrating to soon, known as "Qlik."Learn more... Show More

    On Tuesday, Palm Beach County Commissioners were briefed on the new COVID-19 dashboard the state will be migrating to soon, known as "Qlik."

    Learn more.

    Show Less
  • forum

    App Development

    Gantt

    Hi guys!Following question because i think i go crazy.I have a table with "reclamations" and this "reclamations" have different Date "Positions"Some a... Show More

    Hi guys!

    Following question because i think i go crazy.

    I have a table with "reclamations" and this "reclamations" have different Date "Positions"

    Some are notificated = we was informed that there is a problem, some are picked up from us from the customer, some are arrived our stock.

    then there are timestamps when the customer is informed about costs and when for him its ok the date when gives us the ok.

    start repair date, delivery etc.

    All i want to have is a gantt with a timleine where i can mke this visible but i dont check it.

    example for a line:

    3 days from notification to pickup, 7 days from pickup to arrive our company, 15 days from inform the customer to his answer, 8 days for repair / production, 4 days from delivery stock to shippment.....

     

    Has anybody an idea how i can solve this problem?

     

    Thank you very much!

    Show Less
  • forum

    App Development

    $ expansion of a conditional function in load editor, load as a field

    Hello I have this variable Set f_GroupScore ='If( (Sum(ACDTIME) + Sum(ACWTIME) + Sum(HOLDTIME)) / Sum(ACDCALLS) >= GroupScore1,1,If( (Sum(ACDTIME) + S... Show More

    Hello I have this variable 

    Set f_GroupScore =
    'If( (Sum(ACDTIME) + Sum(ACWTIME) + Sum(HOLDTIME)) / Sum(ACDCALLS) >= GroupScore1,
    1,
    If( (Sum(ACDTIME) + Sum(ACWTIME) + Sum(HOLDTIME)) / Sum(ACDCALLS) >= GroupScore2,
    2,
    If( (Sum(ACDTIME) + Sum(ACWTIME) + Sum(HOLDTIME)) / Sum(ACDCALLS) >= GroupScore3,
    3,
    If( (Sum(ACDTIME) + Sum(ACWTIME) + Sum(HOLDTIME)) / Sum(ACDCALLS) >= GroupScore4,
    4,
    If( (Sum(ACDTIME) + Sum(ACWTIME) + Sum(HOLDTIME)) / Sum(ACDCALLS) >= GroupScore5,
    5,
    If( (Sum(ACDTIME) + Sum(ACWTIME) + Sum(HOLDTIME)) / Sum(ACDCALLS) >= GroupScore0,
    1,
    Null()
    )
    )
    )
    )
    )
    )';

     

    I am trying to load it as a field but in the table it isn't expanding.  I loaded it as:

    AHT:
    Load
    KEY_IdDate,
    REPORT_GROUP,
    GroupScore1,
    GroupScore2,
    GroupScore3,
    GroupScore4,
    GroupScore5,
    GroupScore0,
    ACDCALLS,
    ACDTIME,
    HOLDTIME,
    ACWTIME,
    TOTALACDCALLS,
    ACDCALLS/TOTALACDCALLS as Weight,
    '$(f_GroupScore)'*(ACDCALLS/TOTALACDCALLS) as Weight1
    resident Temp2_AHT
    ;

    I want to expand it in the load editor so I can then filter certain values from showing up in the grids but instead of evaluating the expression it is only returning the string of the expression.  I've tried 'set', and 'let', I've tried inputing '=' in the parantheses.  Not sure what I'm missing is it not evaluating because it is an if statement?  Any help would be appreciated.  

     

    Thanks, 

    Show Less
  • forum

    QlikView App Dev

    Count ID based on field

    I have ID, Date, MonthYear and Status as fields.1. I have to count all the IDs that have more than one Running or Pending or Complete Status2. I also ... Show More

    I have ID, Date, MonthYear and Status as fields.

    1. I have to count all the IDs that have more than one Running or Pending or Complete Status

    2. I also have to count IDs that have more than one Running or Pending or Complete Status and fall within one year from the Date.

    For problem 1,  I am using Count(DISTINCT {<ID = {"=Count({<Status = {'Running', 'Complete', 'Pending'}>} Status) > 1"}>} ID) but this also counts other ID rows with other Status values.

    For problem 2, I am using Count(DISTINCT {<ID = {"=Count({<Status = {'Completed'},MonthYear ={">=$(=MonthName(addmonths(today(),-12)))"}>} Status) > 1"}>} ID) but this does not work either. The Set expression starts treating everything after 'MonthYear' as some kind of variable and gives errors.

    I am attaching my QVW with some sample data. I have reached out before but couldn't really find the end solution for these 2 requirements. So reposting for bumping this question up. Any kind of help is highly appreciated.

     

     

    Show Less
  • forum

    App Development

    AutoNumber(RowNo(),[MyField]) takes too long

    I'm using AutoNumber(RowNo(),[MyField]) and it takes 25 minutes with 800k rows and I'm only going to have more as time goes by. (In SQL I'd use Row_Nu... Show More

    I'm using AutoNumber(RowNo(),[MyField]) and it takes 25 minutes with 800k rows and I'm only going to have more as time goes by. (In SQL I'd use Row_Number() over Partition By, but I can't use that here.) How can I accomplish the same thing in substantially less time? 

    Below is a Load Script that does what I want with some fake data. The point is to have a column that numbers the rows in which a patient visit took place in multiple departments on the same day. For example, a patient is admitted to the Emergency Department (ED) and transferred to the ICU. The ED row is '1', the ICU row is '2'. How can I do this for lots of data very quickly?

    TempTable2:
    LOAD * INLINE
    [VisitNum, Dept, Date,
    1000, ED, 2021-06-10
    1001, ED, 2021-06-10
    1001, ICU, 2021-06-10
    1002, MedSurg, 2021-06-11
    1003, ICU, 2021-06-10
    1003, MedSurg, 2021-06-11
    1004, ED, 2021-06-11
    1004, MedSurg, 2021-06-11
    ];

    TempTable1:
    LOAD
    *,
    (VisitNum & '-' & Date) as PatientDayPresent
    Resident TempTable2
    ;

    DayPresent:
    Load DISTINCT
    *
    ,AutoNumber(RowNo(),PatientDayPresent) as PatientDayPresentIndex
    Resident TempTable1;

    Drop Tables TempTable2, TempTable1;

     

     

     

     

     

    Show Less
  • forum

    Qlik NPrinting Discussions

    Embedded HTML Report in Email Losing CSS Formatting

    Hi,I am using NPrinting 17 September 2019 release and have found an issue with publishing an HTML Report.I am using a publish task to distribute HTML ... Show More

    Hi,

    I am using NPrinting 17 September 2019 release and have found an issue with publishing an HTML Report.

    I am using a publish task to distribute HTML reports to users, and have been asked to include the report as both an attachment and embedded in the email body.

    As part of my template, I have used CSS to create a table structure for formatting the report. In the email attachment, the CSS settings are being applied correctly and the reports looks as i want it to. However, when embedding the report in the email body the CSS settings are not applied and i get the information as raw text.

    Is is possible to apply CCS on HTML reports in the email body?

    Kind Regards,

    Stephen

    Show Less
  • forum

    QlikView App Dev

    Looking for Multiple Values

    Hi All,Consider below table,Input:A, B1,Area1,Club2,District3,Country3,StreetOutput:While looking for Values 1 - Area, Club 2 - District, 3 - Country,... Show More

    Hi All,

    Consider below table,

    Input:

    A, B

    1,Area

    1,Club

    2,District

    3,Country

    3,Street

    Output:

    While looking for Values 1 - Area, Club 2 - District, 3 - Country, Street as like i need multiple values as output.

    Anybody can help. Thanks in Advance.

    Show Less
  • forum

    New to Qlik Sense

    Association between two tables is unmatched causing loss of data when filtering

    Hello,I currently maintain a mapping excel sheet (lets call it Table A) that I upload to Qlik. The file contains Dimension values that are then associ... Show More

    Hello,

    I currently maintain a mapping excel sheet (lets call it Table A) that I upload to Qlik. The file contains Dimension values that are then associated to a different table (Table B) that I am uploading through a QVD. 

    The dimensions in Table A have an almost hierarchical structure of "Object" --> "Program" --> "Project", where a single Program can be aligned to multiple Objects and there can be multiple Projects aligned under a single Program. 

    I have a requirement to show and drilldown from the Object level to the Programs and then Projects that are found in Table A, which is straightforward. But, I also have to show all other Projects not found in Table A that are associated with the Program/Object being filtered on (think of a long filter pane with all these fields next to each other drilling  down). The issue is that Table A is a much smaller subset of Table B and the Object Name field is only found in Table A.

    I am associating the two tables through a primary key, but since Table A is only a subset of data, as soon as an Object Name field is selected the Project Field only shows values contained in Table A and there is no way to see the other Projects that are in Table B. The rest of the projects can be found within the tables if you were to only use fields native to Table B, but I need to use the Object Name field coming from Table A as a filter. 

    So far I have tried ApplyMap() without success since it is a one to many relationship, as well as a Link table that I cannot get to work. 

    Any help would be much appreciated. Thanks in advance!

    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 QlikView.

May 18, 2021 10AM EST

Events

Qlik Insider - Webinar Series

This webinar will cover key new capabilities that drive Active Intelligence in your organization, helping your users go beyond the dashboard, to collaborate and take action at the point of decision.

May 26, 2021