Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 181,274 members
  • 3,944 online
  • 1,804,078 posts
  • 138,226 Solutions
Announcements
MAINTENANCE ALERT: Dec. 12th starting 9 AM CET. Community will be read-only. GET DETAILS

Welcome to Qlik Community

Recent Discussions

  • forum

    Connectivity & Data Prep

    REST Connection with No Content

    I have created a data connection in Qlik Sense using the REST connection. The purpose of the connection is to perform a "logout" to invalidate the log... Show More

    I have created a data connection in Qlik Sense using the REST connection. The purpose of the connection is to perform a "logout" to invalidate the login token. But the response from the REST API is without any content. Due to this, I cannot "execute" the API call in QS. (Since it require me to select something to generate the script)

    What can I do?

    Show Less
  • forum

    New to Qlik Sense

    Pivot Table

    Hello All, with below attached data i am trying to create pivot table as  dim - Dim1 -> dim2 -> dim3  measure - measure 1  -> measure 2 and in appeara... Show More

    Hello All,

    with below attached data i am trying to create pivot table as 

    dim - Dim1 -> dim2 -> dim3 

    measure - measure 1  -> measure 2

    and in appearance only intended rows is selected  and give me resulat as follows.

    Satish251_0-1702002120983.png

    if i expand 1 dim then it shows only dim2 value and dim1 value blank and if i expand till dim3 then measure value for dim1 & 2 shows blank , only shows dim3 value.

    Default as Measure value for Dim1,

    on 1st expand measure shows value for dim2 of respective dim1

    and 2nd expension measure shows values of dim3 of respective dim1 and dim 2

    as below images 

    dim1

    Satish251_1-1702002330244.png

    dim2 : 

    Satish251_2-1702002354113.png

    dim 3 :

    Satish251_3-1702002387257.png

     

     

     

     

     

    Show Less
  • forum

    New to Qlik Sense

    Cant take newly counted previous row into current row in load script

    Hello everyone, I have a table costumer with fields date, amount date, costumer 1.1.2021,   500 1.2.2021, 600 etc   Next what I do, is load new table,... Show More

    Hello everyone,

    I have a table costumer with fields date, amount

    date, costumer

    1.1.2021,   500

    1.2.2021, 600

    etc

     

    Next what I do, is load new table, costumer2

    load
    date,

    if (isnull(amount ) and isnull(previous(amount)),    '',

                                                                               if (isnull(previous(amount), 10, peek(amount)*12)) as amount

    Resident costumer;

    The thing is that it does not count , it lefts as null. 

    If I write precious instead of peek, for first date it takes 500, but others it takes amount as not not calculated, but as it is in table customer. I mean for 1 january, it saves 10, but for 1 february it takes previous(amount) as 500 and multiplies it by 12.

    How to explain to qlik to take 10, instead of 500?

     

    Hope, explained it well

    Show Less
  • forum

    Qlik Replicate

    ODBC Time-out and no error notification?

    Strange issue today... Got an ODBC Timeout, no email, no notification on the UI...only evidence was users complaining and this in the log files. Log l... Show More

    Strange issue today...

    Got an ODBC Timeout, no email, no notification on the UI...only evidence was users complaining and this in the log files.

    Log levels are right down the middle across the board...why didn't Replicate report the error and are there time-out setting(s) to allow this to be a bit more resilient?  We had a db-log backup that started up right about this time, which by itself is normal...but might have used enough resources to cause Replicate operations to time-out...only theory we have at the moment.

    00011328: 2023-12-06T01:12:33 [TARGET_APPLY ]I: RetCode: SQL_ERROR SqlState: HYT00 NativeError: 0 Message: [Microsoft][ODBC Driver 17 for SQL Server]Query timeout expired [1022502] (ar_odbc_stmt.c:2828)
    00011328: 2023-12-06T01:12:33 [TARGET_APPLY ]I: Failed to execute bulk insert statement.
    ~--removed encrypted statment ~ [1022506] (odbc_util.c:4504)
    00011328: 2023-12-06T01:12:33 [TARGET_APPLY ]I: Failed to apply INSERT (1) for table 1 [1022506] (bulk_apply.c:2997)
    00011328: 2023-12-06T01:12:33 [TARGET_APPLY ]I: Failed to start bulk apply transaction [1022502] (sqlserver_bulk.c:396)
    00011328: 2023-12-06T01:12:33 [TARGET_APPLY ]I: Rollback bulk statements failed [1022502] (bulk_apply.c:3074)
    00011328: 2023-12-06T01:12:33 [TARGET_APPLY ]I: Error forwarding bulk [1022506] (bulk_apply.c:815)
    00011328: 2023-12-06T01:12:33 [TARGET_APPLY ]I: Endpoint is disconnected [1020414] (endpointshell.c:4113)
    00011328: 2023-12-06T01:12:33 [TARGET_APPLY ]I: Error executing data handler [1020414] (streamcomponent.c:2026)
    00011328: 2023-12-06T01:12:33 [TASK_MANAGER ]I: Stream component failed at subtask 0, component st_0_test_to_phygenesys_repl [1020414] (subtask.c:1433)
    00011328: 2023-12-06T01:12:33 [TARGET_APPLY ]I: Target component st_0_test_to_phygenesys_repl was detached because of recoverable error. Will try to reattach (subtask.c:1548)
    00011328: 2023-12-06T01:12:33 [TARGET_APPLY ]E: Failed to get table (null).attrep_changes93EDA050474F5777 [1022502] (ar_odbc_conn.c:1060)
    00011328: 2023-12-06T01:12:38 [STREAM_COMPONEN ]I: Target last committed record id from the previous run is '26829843' (streamcomponent.c:1689)
    00011328: 2023-12-06T01:12:38 [TARGET_APPLY ]I: Bulk is set to ignore max row size warnings (sqlserver_endpoint_imp.c:1752)
    00011328: 2023-12-06T01:12:38 [TARGET_APPLY ]I: Working with collated columns (sqlserver_endpoint_imp.c:1812)
    00011328: 2023-12-06T01:12:38 [TARGET_APPLY ]I: Working with BCPKeepNull set to TRUE (sqlserver_endpoint_imp.c:1816)
    00011328: 2023-12-06T01:12:38 [TARGET_APPLY ]I: Target endpoint 'SQL Server' is using provider syntax 'SQLServer' (provider_syntax_manager.c:957)
    00011328: 2023-12-06T01:12:38 [TARGET_APPLY ]I: Going to use provider syntax for datatype mapping (sqlserver_endpoint_imp.c:1843)

    Show Less
  • forum

    New to Qlik Sense

    Logout in Mashup

    Hi,I want to create a logout button in QlikSense mashup  . Can anyone help me out with the html and javascript codes. Functionality : It should logout... Show More

    Hi,

    I want to create a logout button in QlikSense mashup  . Can anyone help me out with the html and javascript codes. 

    Functionality : It should logout from Qlik on clicking on button and it should not take me back to Qlik page on clicking on back button in web browser.

    Thanks ,

    Raghavi

    Show Less
  • forum

    New to Qlik Sense

    Stack bar chart : How to show values in small segment

    I don't see the values displayed for smaller segments as in the below screenshot. Could you please help me resolve this? Thanks.  
  • forum

    Integration, Extension & APIs

    Enigma API GetLineage Method Help

    Hi all, For reference we are using Qlik Sense Feb 2023 and Qlik SaaS is not an option for us. We are working on tracking data lineage on a few of our ... Show More

    Hi all,

    For reference we are using Qlik Sense Feb 2023 and Qlik SaaS is not an option for us.

    We are working on tracking data lineage on a few of our critical apps. The method is working for most of our apps and circumstances but its returning some apps as null. We use these apps as extracts, so they load the data into a table, push it into a QVD, and then drop the table.

    All of those apps specifically are returning null responses and those are where a lot of our QVDs originate. I wanted to know if someone has more info.

    Are there limitations that aren't listed? Or am I missing something? Just trying to find out if this is a viable option or if we should be going down another route.

    Show Less
  • forum

    New to Qlik Sense

    Combine multiple fields into one field

    I'm a total beginner to QLik sense. I'm trying to combine multiple fields into one. For example, in the screenshot below, I want to combine [ Phone_gr... Show More

    I'm a total beginner to QLik sense. I'm trying to combine multiple fields into one. For example, in the screenshot below, I want to combine [ Phone_gross_adds, tablet_gross_adds, smartphone_gross_adds] into one field called "Gross Adds" and the other three fields into "Net Adds". All the gross adds products are measures, but I want the new field Gross Adds to be a dimension to create a stacked bar chart to show products by Gross Adds and Net Adds separately. Appreciate your response! Thanks. 

    Thrive_0-1701976935438.png

     

    Show Less
  • forum

    App Development

    Reference a resident table field in a do while loop while calculating date based...

    I have a a need to iterate through a resident table making calculations that will go into another table. Yet, anytime I try to add a field from the re... Show More

    I have a a need to iterate through a resident table making calculations that will go into another table. Yet, anytime I try to add a field from the resident table to my do while loop I get 'invalid calculation' with no other hints.

    I have a resident table like this:

    RecNo, Trigger_Date, Return_Date, Item, Dept

    I need to get three things

    1) the number of records with trigger and return dates between vStartDateGA and vEndDateGA for a 30Day_Returns count.

          1a the vStartDateGA and vEndDateGA will be calculated for every calendar date for 3 years.

    2) the number of records with just trigger dates between vStartDateGA and vEndDateGA for a 30Day_Totals count.

    3) the percentage of 30Day_Returns/30Day_Totals to get a 30Day_Rate.

    Psuedo code:

    Count the number of distinct records when the Trigger Date is between 30 days prior to the 'Rate Calc Date' and is not after the 'Rate Calc Date' and the Return Date does not equal '12/31/1899'
    then divide by the
    Count of distinct records where the Trigger Date is between 30 days prior to the 'Rate Calc Date' and is not after the 'Rate Calc Date'

    Return this as a 30Day_Rate of return percentage

     

    I am looping through to do the calculations -

    [Rate_Calendar_Dept]:
    
    SET DateFormat='YYYY-MM-DD';
    
    LET vRateCalcDate = '2023-01-01';
    
    LET vStartDateGA = '2023-01-01';
    
    LET vEndDateGA = '2023-03-31';
    
    
    
    do while vStartDateGA <= vEndDateGA
    
       Let vRateCalcDate = date('$(vStartDateGA)','YYYY-MM-DD');
       
       Load
       
       '$(vRateCalcDate)' as Rate_date,
       NUM(Count( distinct IF( [Trigger_dt] >= Date('$(vRateCalcDate)'-30) AND [Trigger_dt] <= Date('$(vRateCalcDate)') AND DATE(Return_Dt) <= DATE('$(vRateCalcDate)') AND DATE(Return_Dt) <> DATE('12/31/1899','MM/DD/YYYY'), RecordNum,0) )/Count( distinct IF( [Trigger_dt] >= Date('$(vRateCalcDate)'-30) AND [Trigger_dt] <= Date('$(vRateCalcDate)'), RecordNum,0) ), '#,###.0%') as '30Day_Rate',
       Count( distinct IF( [Trigger_dt] >= Date('$(vRateCalcDate)'-30) AND [Trigger_dt] <= Date('$(vRateCalcDate)') AND DATE(Return_Dt) <= DATE('$(vRateCalcDate)') AND DATE(Return_Dt) <> DATE('12/31/1899','MM/DD/YYYY'), RecordNum,0) ) as '30Day_Returns',
       Count( distinct IF( [Trigger_dt] >= Date('$(vRateCalcDate)'-30) AND [Trigger_dt] <= Date('$(vRateCalcDate)'), RecordNum,0) ) as '30Day_Totals'
        
       Resident Report_Table;
    
       let vStartDateGA = date('$(vStartDateGA)'+1,'YYYY-MM-DD');
    
    loop  

     

    When I add any other field to the statement after Load I get the 'Invalid calcuation' error; how can I add Trigger_Date and Dept into my Load statement?

     

    Show Less
  • forum

    App Development

    Filtros Independientes

    Hola a todos, dejo la siguiente consulta: Tengo una app que tiene un disparador que al abrirla, selecciona la fecha actual, cuando esa fecha queda sel... Show More

    Hola a todos, dejo la siguiente consulta:

    Tengo una app que tiene un disparador que al abrirla, selecciona la fecha actual, cuando esa fecha queda seleccionada (ademas tiene activada la opcion "siempre un valor seleccionado"), todos los demas filtros de la app se  limitan a los valores posibles, por lo tanto no puedo hacer selecciones en otros campos o bien si los selecciones no hay cambios.

    No se si trabajarlo a nivel filtros o calendario.

    Espero puedan ayudarme, muchas gracias.

    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!