Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 173,169 members
  • 1,391 online
  • 1,792,990 posts
  • 137,105 Solutions
Announcements
You can succeed best and quickest by helping others to succeed. Join the conversation.

Welcome to Qlik Community

Recent Discussions

  • forum

    App Development

    How to ...

    Hello guys. I want to make a graph where I have a dates, each one represents the end of month, and a measures the situation of the portfolio (accounts... Show More

    Hello guys.

    I want to make a graph where I have a dates, each one represents the end of month, and a measures the situation of the portfolio (accounts receivable) and on the other hand the sales.

    Accounts receivable is at the end of the month, since I cannot accumulate these values ​​daily because it would create a distortion, while sales need to be accumulated each month so that it reflects the data and metrics that I need to present. How can I make the graph?

    Thanks for your time and help.

    Show Less
  • forum

    New to Qlik Sense

    My tenants looks not working

    Hi, I'm testing qlik sense, started yesterday, but the tenants stop working, what I have to do? Thanks Michele 
  • forum

    Qlik Cloud Data Integration

    How to reload specific table ( or all tables ) with Onbording task

    Hi, I'm doing some test with Qlik Cloud Data Integration. I want to know how to reload specifig table (or all tables ) in Onbording task. there are no... Show More

    Hi, I'm doing some test with Qlik Cloud Data Integration.

    I want to know how to reload specifig table (or all tables ) in Onbording task.

    there are no descriptions about this operation in the product document...

     

     

    Best Regards,

    Keishi Miyachi

    Show Less
  • forum

    Qlik Cloud Data Integration

    Error SAP HANA ( database connector) QCDI

    Hi, I'm trying with the SAP admin to use the SAP HANA (database) connector but get an error when I want to get the tables. Database is 2.0, multi-tena... Show More

    Hi,

    I'm trying with the SAP admin to use the SAP HANA (database) connector but get an error when I want to get the tables. Database is 2.0, multi-tenant but used as single with SAP Business One.

    With the specific created user we dont get a succesful connection with the TEST button. If we use the SYSTEM user then the connection is succesful. The problem occur when we want onboard data and Qlik is searching for tables. This error message will appear. Please note: gateway is connected.

    Service returned unsuccessful status code 'NotFound' on 'GET' at '/v1/replicate-agents/$onboarding_LANDING_SAAS_MANAGED$/tasks/44bGvDPwb8HlmIkBxPXnZh7YnZ8ktiId/schema-list' with 'Not Found' - content: '{"errors":[{"title":"Failed to retrieve schema list","detail":"QEM-PROXY-REQUEST-FAILED-1, Proxy request to remote Data gateway failed, QEM-19, HTTP request failed, Failed to connect using Data Movement gateway local_repsrv. Verify the status in Management Console > Data gateways is \"Connected\" and then retry the operation.","code":"REPLICATE-AGENT-GET-SCHEMA-LIST-FAILED","status":404,"meta":{"id":"088Ic59Gfyvi5xlhujcsBwejiuKVieKc","serverName":"local_repsrv","ctx":{"msgId":"-tgHli1B43IdfGn6D-LJ9LrFX55tU4mI","guid":null,"detailedMessage":"SYS,GENERAL_EXCEPTION,SQLite general error. Code <14>, Message <unable to open database file>.,Error execution statement SQLite general error. Code <14>, Message <unable to open database file>.","exceptionCode":"GENERAL_EXCEPTION","errorMessage":"SYS-E-HTTPFAIL, SQLite general error. Code <14>, Message <unable to open database file>.."},"code":"QEM-SERVICE-24"}}],"traceId":"0000000000000000f1eebe1b0f3be30d"}'

    It looks like if the permission level isn't right. The SAP admin gave all database roles to the SYSTEM use and SELECT & TRIGGER on schema. Still same problem. We can not open database file.

    I raised already a ticket at Qlik support. But maybe a SAP expert see this thread also. Both I and the SAP admin does not know what to do anymore.

    Does somebody has a clue?

    Thank you!

     

    Show Less
  • forum

    Water Cooler

    Migrate Community Account

    Hi I had to switch accounts for work reasons, is it possible to move the history of my old community account to this new one? my previous one is User ... Show More

    Hi

    I had to switch accounts for work reasons, is it possible to move the history of my old community account to this new one? my previous one is User ID 70848.

    @Anonymous @itsupport 

    Thanx

    Roberto

    Show Less
  • forum

    New to Qlik Sense

    5 questions for QSBA

    I am preparing QSBA. Found some old exam questions from different sources but provided questions do not seem always right.  Appreciate if any one can ... Show More

    I am preparing QSBA. Found some old exam questions from different sources but provided questions do not seem always right.  Appreciate if any one can shed some lights

    1. A business analyst creates an app for a large retailer. The app is based on me past 2 months of transactional data in CSV form. After successfully demonstrating the app, the retailer provides a big file that contains another seven years of data
    After the new data is loaded. The previously responsive app takes 10 times longer to respond to users' selections. The app has many complex expressions
    Which two actions should the business analyst take to resolve the issues? (Select two)

    A. Request the data architect to create flags in the data model to optimize set analysis expressions
    B. Use JOIN statements to reduce the number of tables m the data model
    C. Make sure a the master items contain variables that define the expressions
    D. Replace set analysis with calculated fields in the data manager
    E. Create versions of the app using a WHERE clause m the data manager to restrict the data
     
    I go for A and D. but provided answer is A and C. 
     

    2

    coloful_architect_0-1695254826318.png

    I thought this is a no brainer of B, but it says A is the correct answer.

    I guess A could remove some of outliers but 2 interquartile ranges wont' be sufficient to remove the outlier far way from 

    major whiskey bar, right?  or am I reading this question at a wrong way? 

    3.

    To improve efficiencies a hospital mustanalyze how often a surgery is started late by operating room and surgeon.
    The business analyst must consider several factors
    • Dates of each surgery
    • Number of minutes the start of the surgery is delayed
    • Operating room
    • Surgeon name

    Which visualization should the business analyst use to meet these requirements?

    I go for B, but answer is D ...no idea why it is line chart

    4.  After a campaign a marketing group has data that snows distinct increases of product sales over a 12-month period. The group needs to highlight the products that show the highest revenue.
    What should be developed to meet this requirement?

    given by it is over 12 month period, I feel like this should be B...but why it is D...there is no contribution to show at all

    5. 

    CEO wants to review total sales in terms of cost and gross profit, if you could only use one viz tool to represent it. which one is the best. 

    scat plot, bar, waterfall, KPI

    should it be waterfall? I mean , cost and gross profit is one negative and one positive, waterfall could be better than bar.

    what you think?

    Show Less
  • forum

    New to Qlik Sense

    Count script table

    I don't understand why this not work on table   count({<QC_Grade = {'1 '}>} MonthYear)And first colum is MonthYear  
  • forum

    New to Qlik Sense

    Sum skript

    This not working sum({<QC_EvaluationResult>} MonthYear)And I must show on label colum MonthYear and I is possible choose dimension panel MonthYear  or... Show More

    This not working

    sum({<QC_EvaluationResult>} MonthYear)

    And I must show on label colum MonthYear and I is possible choose dimension panel MonthYear  or Year


    kkarlste_0-1695479715476.png

     

     

    Show Less
  • forum

    App Development

    Sum previous date record count

    Creating a snapshot for our database and using RUN_DATE as the date in which each database run is completed. I need to sum values based on max date -1... Show More

    Creating a snapshot for our database and using RUN_DATE as the date in which each database run is completed. I need to sum values based on max date -1 (previous day totals)

    Currently WORKING Max Date Sum:

    Sum( {<RUN_DATE={'$(=Max(RUN_DATE))'}>} RECORD_COUNT)

     

    How can I run the previous days totals? I'm used to seeing something like date(max(RUN_DATE)-1)

    Show Less
  • forum

    New to Qlik Sense

    Increase actual Year by 2 Years

    I would like to increase the actual years in my Calendar by two years. The actual first and last years in the date field of the Order table, on which ... Show More

    I would like to increase the actual years in my Calendar by two years. The actual first and last years in the date field of the Order table, on which the current Calendar is based, are 2010 and 2021 respectively.  The script would change these years to 2012 and 2023 respectively. I have tried AddYears in the Calendar script, but this does not work. 

    Thanks in advance for any help!

    Here is my Calendar script (note that I have commented attempts below to make this work using the AddYears function):

    DateRange:
    LOAD
    min(Date) as MinDate,
    max(Date) as MaxDate
    // AddYears(min(Date, 2) as MinDate,---> did not work
    // AddYears(max(Date, 2)) as MaxDate,---> did not work
    // Min(AddYears(Date, 2)) as MinDate,---> did not work
    // Max(AddYears(Date, 2)) as MaxDate,---> did not work
    Resident POS;

    LET vMinDate = Peek('MinDate',0,'DateRange');
    LET vMaxDate = Peek('MaxDate',0,'DateRange');

    TempCalDate:
    LOAD
    date($(vMinDate) + RowNo() -1) as CalDate
    AutoGenerate $(vMaxDate) - $(vMinDate) + 1;

    Calendar:
    LOAD
    CalDate as Date,
    day(CalDate) as Day,
    WeekDay(CalDate) as WeekDay,
    Year(CalDate) as Year,
    Month(CalDate) as Month,
    week(CalDate) as Week,
    'Q' & Ceil(month(CalDate)/3) as Quarter,
    4*Year(Today())+Ceil(Month(Today())/3)-4*Year(1)-Ceil(Month(1)/3) AS [QuartersAgo],
    date(monthstart(CalDate), 'MMM-YYYY') as MonthYear,
    date(QuarterStart(CalDate), 'QQ-YYYY') as QuarterYear
    Resident TempCalDate
    order by CalDate asc;

    drop Tables DateRange, TempCalDate;

    Show Less
Leaderboard

Customer Story

New Data Integration Customer Story + Video

Real-time Responses Delight Burgan Bank's Customers.

Customer Story

Talking Analytics to the Frontier

Alaska’s Northrim Bank wins the SBA Lender of the Year award, using Qlik to target unique local needs.

Location and Language Groups

Choose a Group

Join one of our Location and Language groups. Find one that suits you today!

Collaborate

Healthcare User Group

Healthcare User Group

A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..

All are welcome

Japan Group

Japan

Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。

Request to join

Brasil Group

Brazil

Welcome to the group for Brazil users. .All discussions will be in Portuguese.

open to all

Blogs

Community News

Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!