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?
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
dim 3 :
I have a table costumer with fields date, amount
Next what I do, is load new table, costumer2
if (isnull(amount ) and isnull(previous(amount)), '',
if (isnull(previous(amount), 10, peek(amount)*12)) as amount
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  (ar_odbc_stmt.c:2828)
00011328: 2023-12-06T01:12:33 [TARGET_APPLY ]I: Failed to execute bulk insert statement.
~--removed encrypted statment ~  (odbc_util.c:4504)
00011328: 2023-12-06T01:12:33 [TARGET_APPLY ]I: Failed to apply INSERT (1) for table 1  (bulk_apply.c:2997)
00011328: 2023-12-06T01:12:33 [TARGET_APPLY ]I: Failed to start bulk apply transaction  (sqlserver_bulk.c:396)
00011328: 2023-12-06T01:12:33 [TARGET_APPLY ]I: Rollback bulk statements failed  (bulk_apply.c:3074)
00011328: 2023-12-06T01:12:33 [TARGET_APPLY ]I: Error forwarding bulk  (bulk_apply.c:815)
00011328: 2023-12-06T01:12:33 [TARGET_APPLY ]I: Endpoint is disconnected  (endpointshell.c:4113)
00011328: 2023-12-06T01:12:33 [TARGET_APPLY ]I: Error executing data handler  (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  (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  (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)
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.
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.
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.
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?
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.
Discover why both Qlik and Qlik (Talend) were named as a Leader in the 2023 Gartner® Magic Quadrant™ for Data Integration Tools report.
Join other data diehards for 2.5 days of the hottest topics in data, analytics, and AI. Register now: June 3-5 in Orlando, FL.
If you are a customer, it's time to apply to be a Qlik Luminary. Applications are open through December 15.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Our featured member for December 2023
Join one of our Location and Language groups. Find one that suits you today!
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Welcome to the group for Brazil users. .All discussions will be in Portuguese.