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?

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.

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

dim2 : 

dim 3 :

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

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)

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. 

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?

Dept, Trigger_Date, Rate_Date, 30Day_Rate, 30Day_Returns, 30Day_Totals
Sales, 2023-01-01, 2023-01-01, 58.5%, 1696, 2901
Legal, 2023-01-01, 2023-01-01, 57.5%, 1609, 2800
AP, 2023-01-01, 2023-01-02, 58.4%, 1630, 2790
IT, 2023-01-01, 2023-01-02, 59.4%, 1737, 2926

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.