Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone, so I have geo map which shouldn't affect when I select year month, So I have provided the expression to ignore this dimension but in size&shape properties, there are two layers point layers and area layers, except size&shape all the properties are dimension, so How should I stop the dimension from reflecting from year-month?
right now after selecting it is removing countrys(area layer) and some station(point layer) when I select year-month.
Used expression: SUM({<[YEAR_MONTH]=>}[GEO_AVG_PRICE] * [GEO_QTY])
Before selecting year month filter:
after selecting (it shouldn't change anything, It should show the grap as it was before as in above image):
Hello.
I'm following these steps to use an IFrame to embed in my Razor Application a Qlik Cloud Sheet.
Qlik Sense Enterprise SaaS: How to embed a chart in an iFrame
From @Damien_Villaret
I'm moved to the login page in Chrome, and redirected back to my page where I can see the embedding content with no problem. But, in Firefox or Incognito, I got stuck in a loop where it keeps getting 401 from the /users/me endpoint and the login page returning 302 (It seems like I'm already logged in and I'm redirected back to the returnTo value) but never popping the login page.
There are no errors in console related to this process apart from the 401.
P/D: I'm also trying to implement Qlik-Embed with OAuth, but right now I'm only able to see the classic/app version of it, as soon as I put an object or analytics/sheet I get a full empty page with no content. Some of the graphs are not Nebuja.js but I understand that I should be able to see at least the page content rendered.
I will open another question about this and link it here, but this post is the most important for me right now as my requirements include sending some variables to the sheet that I cannot do with qlik-embed.
when we are trying for CDC Load for ODBC connection the job is getting failed with below errors.
Error 1:
I have a table with 100 columns
I want to check for column 1 = 'ID001' if the other 99 columns has a certain date value say '2025-01-01'
But my code is throwing the error fieldname not found in the for loop...
what i did
// first filter column 1 for ID001
[TEST]: NoConcatenate LOAD Distinct * Resident[MAIN_TABLE] where column1='ID001';
// Loop to check for date value = '2025-01-01' if have flag as 1
For f = 1 to NoOfFields('TEST')
LET F1 = FieldName($(f), 'TEST');
[Fields]:
Load distinct FieldName($(f), 'TEST') as Field, If(Date(Floor($(F1)))=Date(Floor(' 2025-01-01')),1,null()) as check
AutoGenerate 1;
Next f
DROP Table[TEST];
Any idea how to solve? Thanks in advance!
Olá.
Por favor, há alguma solução de somase para o caso?
Tenho uma tabela com campo "NF", "NF vinculada", "Operação" e "Frete".
Operação há dois valores "Receita" ou "Remessa".
O valor do frete está ligado às notas de "remessa", mas preciso trazer a soma dos fretes junto às respectivas notas de "Receita".
Há menção da respectiva nota de "receita" para cada nota de "remessa".
Obrigado.
Hi Qlik Team,
Source : Microsoft SQL Server
Target : Oracle
Getting following error while capturing CDC while using Batch optimized apply
Error : Invalid timestamp value in table 'USER1.attrep_changes050CD0AC_0000001' column 'col2'; the value will be changed to '~{AwAAAK1+/hLLxSTxKFlEHbyAduwSuSAXDWOomhCCeqPAFTg3}~'
Logs :
00017412: 2024-04-25T16:24:22:723736 [TARGET_APPLY ]T: Finished applying bulk changes for tables (bulk_apply.c:6100)
00017412: 2024-04-25T16:24:22:723736 [TARGET_APPLY ]T: Going to start applying bulk changes for table '2' (bulk_apply.c:6026)
00017412: 2024-04-25T16:24:22:723736 [TARGET_APPLY ]T: Start handling table 2 which is in the bulk (bulk_apply.c:5257)
00017412: 2024-04-25T16:24:22:723736 [TARGET_APPLY ]V: Apply UPDATE in Bulk. Event - 'UPDATE (3)' for table 2, stream position '0000003D:000184F8:0002' (bulk_apply.c:5045)
00017412: 2024-04-25T16:24:22:723736 [TARGET_APPLY ]V: Enter: bulk_apply_i_create_datarecord_from_update (bulk_apply.c:4153)
00017412: 2024-04-25T16:24:22:723736 [TARGET_APPLY ]V: Enter: oracle_bulk_handle_insert_to_net_changes (oracle_endpoint_bulk.c:370)
00017412: 2024-04-25T16:24:22:723736 [TARGET_APPLY ]T: INSERT statement for table 'USER1.attrep_changes050CD0AC_0000001' was not found in the pool, going to allocate a new statement (statement_manager.c:1892)
00017412: 2024-04-25T16:24:22:723736 [TARGET_APPLY ]V: oci_stmt_mng_create_statement: Batch size for table 'USER1.attrep_changes050CD0AC_0000001' is '1000' (oracle_endpoint_imp.c:703)
00017412: 2024-04-25T16:24:22:723736 [TARGET_APPLY ]V: ar_oci_create_statement. Create and bind the statement 'INSERT INTO "USER1"."attrep_changes050CD0AC_0000001"("seq","col1","col2","ind1","ind2","seg1") values (:1,:2,:3,:4,:5,:6)' batch size is '1000' (ar_oci_stmt.c:1543)
00017412: 2024-04-25T16:24:22:723736 [TARGET_APPLY ]V: Resolve bind type and length using source column 'seq' (ar_oci_stmt.c:970)
00017412: 2024-04-25T16:24:22:723736 [TARGET_APPLY ]V: Resolve bind type and length using source column 'col1' (ar_oci_stmt.c:970)
00017412: 2024-04-25T16:24:22:723736 [TARGET_APPLY ]V: Resolve bind type and length using source column 'col2' (ar_oci_stmt.c:970)
00017412: 2024-04-25T16:24:22:723736 [TARGET_APPLY ]V: Resolve bind type and length using source column 'ind1' (ar_oci_stmt.c:970)
00017412: 2024-04-25T16:24:22:723736 [TARGET_APPLY ]V: Resolve bind type and length using source column 'ind2' (ar_oci_stmt.c:970)
00017412: 2024-04-25T16:24:22:723736 [TARGET_APPLY ]V: Resolve bind type and length using source column 'seg1' (ar_oci_stmt.c:970)
00017412: 2024-04-25T16:24:22:724739 [TARGET_APPLY ]V: ar_oci_stmt_set_param_value. Set value for column 'seq' table 'USER1.attrep_changes050CD0AC_0000001' (ar_oci_stmt.c:395)
00017412: 2024-04-25T16:24:22:724739 [TARGET_APPLY ]V: ar_oci_stmt_set_param_value. Set value for column 'col1' table 'USER1.attrep_changes050CD0AC_0000001' (ar_oci_stmt.c:395)
00017412: 2024-04-25T16:24:22:724739 [TARGET_APPLY ]V: ar_oci_stmt_set_param_value. Set value for column 'col2' table 'USER1.attrep_changes050CD0AC_0000001' (ar_oci_stmt.c:395)
00017412: 2024-04-25T16:24:22:724739 [TARGET_APPLY ]W: Invalid timestamp value in table 'USER1.attrep_changes050CD0AC_0000001' column 'col2'; the value will be changed to '~{AwAAAK1+/hLLxSTxKFlEHbyAduwSuSAXDWOomhCCeqPAFTg3}~' (ar_oci_stmt.c:507)
00017412: 2024-04-25T16:24:22:733735 [TARGET_APPLY ]V: ar_oci_stmt_set_param_value. Set value for column 'ind1' table 'USER1.attrep_changes050CD0AC_0000001' (ar_oci_stmt.c:395)
00017412: 2024-04-25T16:24:22:733735 [TARGET_APPLY ]V: ar_oci_stmt_set_param_value. Set value for column 'ind2' table 'USER1.attrep_changes050CD0AC_0000001' (ar_oci_stmt.c:395)
00017412: 2024-04-25T16:24:22:733735 [TARGET_APPLY ]V: ar_oci_stmt_set_param_value. Set value for column 'seg1' table 'USER1.attrep_changes050CD0AC_0000001' (ar_oci_stmt.c:395)
00017412: 2024-04-25T16:24:22:733735 [TARGET_APPLY ]T: Start applying of 'UPDATE (3)' events for table 'dbo'.'Transaction' (2). (bulk_apply.c:2903)
00017412: 2024-04-25T16:24:22:733735 [TARGET_APPLY ]T: Bulk UPDATE statement for table 'USER1.Transaction' was not found in the pool, going to allocate a new statement (statement_manager.c:2016)
00017412: 2024-04-25T16:24:22:733735 [TARGET_APPLY ]T: Going to run update statement, from seq 2 to seq 2, statement 'UPDATE ( SELECT "USER1"."Transaction"."TransactionID" as "col1", CASE WHEN "USER1"."attrep_changes050CD0AC_0000002"."ind1" = 1 THEN "USER1"."attrep_changes050CD0AC_0000002"."col1" ELSE "USER1"."Transaction"."TransactionID" END as "val1", "USER1"."Transaction"."Description" as "col2", CASE WHEN "USER1"."attrep_changes050CD0AC_0000002"."ind2" = 1 THEN "USER1"."attrep_changes050CD0AC_0000002"."col2" ELSE "USER1"."Transaction"."Description" END as "val2", "USER1"."Transaction"."Category" as "col3", CASE WHEN "USER1"."attrep_changes050CD0AC_0000002"."ind3" = 1 THEN "USER1"."attrep_changes050CD0AC_0000002"."col3" ELSE "USER1"."Transaction"."Category" END as "val3", "USER1"."Transaction"."Amount" as "col4", CASE WHEN "USER1"."attrep_changes050CD0AC_0000002"."ind4" = 1 THEN "USER1"."attrep_changes050CD0AC_0000002"."col4" ELSE "USER1"."Transaction"."Amount" END as "val4", "USER1"."Transaction"."Changes" as "col5", CASE WHEN "USER1"."attrep_changes050CD0AC_0000002"."ind5" = 1 THEN "USER1"."attrep_changes050CD0AC_0000002"."col5" ELSE "USER1"."Transaction"."Changes" END as "val5" FROM "USER1"."Transaction", "USER1"."attrep_changes050CD0AC_0000002" WHERE "USER1"."Transaction"."TransactionID"="USER1"."attrep_changes050CD0AC_0000002"."seg1" AND "USER1"."attrep_changes050CD0AC_0000002"."seq" >= :1 and "USER1"."attrep_changes050CD0AC_0000002"."seq" <= :2 ) tempview
set "col1" = "val1",
"col2" = "val2",
"col3" = "val3",
"col4" = "val4",
"col5" = "val5"' (oracle_endpoint_bulk.c:805)
00017412: 2024-04-25T16:24:22:756734 [TARGET_APPLY ]T: After get rows affected, rows affected 0 (oracle_endpoint_bulk.c:816)
00017412: 2024-04-25T16:24:22:756734 [TARGET_APPLY ]T: Failed to execute update statement:
~{BAAAANOx7ItEPVLD96J+5D5SiazliQyKU/iLkL07AajCMWNHekyF7cEZtu6vig4/oPJw3u9y7BZw+Ftd0ygcv8yDOPA2TfrKpeyS5+bEe8gRJsrMrqAbcrJqPZ7SpjYipZlUKwC2sN77gX3hJGl1aGB1bUy3z9q3QHHcxHhA38ra9+jsbxbUGx3D2+x+bhyLEu7XnTpqI+8UagCJ7iMg1bCwog3uRzibx9BXGPNXxhP8tMCL9KSiELSKExQuNQYDHrpn++DSHf6XHOd/qacSj/sBPJ4bTe4db0Rkc8ZnkTqHQzwNmNlUK3e7xnxEYkNBr9kndMC/4wJtg3zY9bQuEizRBNXfY2Geavq6/GbNJedr4hn2CbLBALuyJ6XA++FqukWCX8wJmyUujrjxXdtTy2oSBDTi980hucDNXeGsClrXEJJqbTYxt8Jro2aOW0qv5EVlB+OeDwpYJr3g0Vjmcb13akiJCi/YQBt9YY0pSMUAO6ef4amD8SUgUdNpKx/0cwD05s9vvWaouzI7IsmsswomqFcQJUwMv7xJ1zbDuhjqi9KxxSqAUlcc+yocY8WMBPFaNaJeBCO4EtWer49F50m6Hmmebe+Lokx32rZcytTG9uxG8o/JsLnWFGbXcLFXszooqvZcbYq2q8Vp6z82Eq6TGALSs8ENSIAutUAeknZ0K3TVjqRqmDL9WsxMRSVp+c0Tj85aOQkqg4n5fw404QGqvDItWJnUcg1XvmBYDt9nOspxfxlImLdkPg2GI1Aarnuz+xldAZoOCAXt5Lvjx9ADUk+sZHjv8CAzFTRcmdl+nig88a1PwP/SfZWpHgMNi7Cqs1UXu3fMgzIfg7wLmmgSx/lKrL15lVPCce8bbTqNcr/rHiymQepauVU9qPcj4lQvrakXpeVOC8BPekxizINorx6JDksIsp8Ahy7dJ4Vbk0/6f/pOHjdKA8IEPUdAS9NtWMqcwVeQATHQ0jV8+NrVZUdL47cARkmsG5cX3IZQKep/Dey1bksRjNpWZoDPfZZ36BNt0xwxMXOQniIhmZFYFnxqJ/p63jIBIj69BcO3suujfMFyf/Euquz47ZBQqmWRFLkG5zZa19Fo2pQINRjqoQg7Fc4jTjv6dnN+yq7cqV0VL5R2HBC6W/sw63IiUs5HhXF/5e6yfNcpU4dmANqn+vtQhmx1GFd6ZlOY+pC3yaMHWmgR7JC6b6j+M557cbt0wH+huXcS8IDSRNjKJgJTLS5hguLKELDwDE1fiSLAZPFNepuMmcTOhGYYfrgzVje9fEBY1rmgh9aJITnKnljv9m5/ivLrk7E4Rvm7umHPVMeH8DjUtbSMMDbkyKw9pODbXSUWvVaNC3JNmFWjC6we2TiTseMANf3RPjzQ6cG0Q81xM3fIbKwXVqeGAa99rqs66eWIJA9LSV2WEkV3z6G45ToxjQEkIyHwn/rFGVBzrADYVTrImvPynSxCdnIS0LqowoL549J619kbtOxGSRTA/L+x7FXi8OOkWTbSt2Tf+FzYjsEWXx6DtH6pH5XBbtwT7AwBOSerF6znth69/OLMzgLt9NVzeb4FAij/RJvK92UMRJWmm9/kL4L7HBCEgXiVK7/8Zf2a2GfvGoZvsKXxatSj/zQthS7MZA1pUn9A+UxaONamfIxb1IDdtNFr9iOj0b75I74G3nmnP8ffFjp3SHmLVcIhuCuiq5kgfTmIgdTUG6Dlmy2mfLYND1egtAV+8ubOt+pXVQdseLV/ggKY1BSu0W0h86zjQZRwl9QXzm2uxeSpufMhIX5lxc70mifr1C6Ya7qADAeDg35eDIVA273ibM9TpntX86RxglxEPX27oMWAhSaxbJpiRpsnv/oW5Przc8Nxs8iESwE/XXTKJjiAwHOo/QAy/YiLPCi6/HumuFWK/HUVwSy+KC2oY6JygUw8kOGbTxikmBeBM1z4ikUUmgc6Cj3vT+AHyot4dSfw9aTaO1QPhWjPF7KW9OGu2L9Jn7wVo4dBoCGHZuYHoZ4=}~ [1022510] (oracle_endpoint_bulk.c:825)
00017412: 2024-04-25T16:24:22:756734 [TARGET_APPLY ]T: Failed to apply UPDATE (3) for table 2 [1020427] (bulk_apply.c:3013)
00017412: 2024-04-25T16:24:22:756734 [TARGET_APPLY ]I: Bulk apply operation failed. Trying to execute bulk statements in 'one-by-one' mode (bulk_apply.c:2430)
00017412: 2024-04-25T16:24:22:756734 [TARGET_APPLY ]T: Going to start applying bulk changes for table '1' (bulk_apply.c:6026)
00017412: 2024-04-25T16:24:22:756734 [TARGET_APPLY ]T: Start handling table 1 which is in the bulk (bulk_apply.c:5257)
00017412: 2024-04-25T16:24:22:760732 [TARGET_APPLY ]V: Going to send all loopback table events. (bulk_apply.c:4703)
00017412: 2024-04-25T16:24:22:760732 [TARGET_APPLY ]V: Handle loopback table INSERT event (bulk_apply.c:4722)
00017412: 2024-04-25T16:24:22:760732 [TARGET_APPLY ]V: Enter: oracle_endpoint_handle_update (oracle_endpoint_apply.c:1271)
00017412: 2024-04-25T16:24:22:760732 [TARGET_APPLY ]V: Update Statement: ~{BQAAAP4b/BQ93/mfJpwgx4pj9Bvcs99TvA6SErC+s8LgRZ5GOrrcObF7YXraLG/F85YH8Y158Gk9RDr5cC5NZ5GqvNla6mlYDVGVB6tpWOgr5wHv/DsIYmCL6xow1a2g4+jreXHDV+cy8X5blwBDhV7x6+KpW4lrftlUWEPrgQdaoTMPtaj3zBTSohkknIsdD+k6tnGXoBsdoFO+yq9QbOtBSmA05F927avUkHmTS/atqo8kx6tSeV9+Jto+3Se+bRKI7JA1ZAxbAkHMMvreIaQHdX2Yh0lnoqGEAuGzcL4Y2+8hDZoTN4q+sLrXPFvKhYWtiPsUJ57cd/A1MFEja5eW4nfCJTxuR5OTSjRzeFsv269V2N2alULhk2wx5SlmvQu4fzAR+ME3DbFAPys8rHozD6XpsUIJvaytCDUSACocgu40lndEV1Oy+AWiEfs260/AKQ==}~ (oracle_endpoint_apply_util.c:1442)
Regards,
Harsh
Join Qlik Support's office-hours, recorded live, where our experts answer your questions and give more insight on Migrating Qlik Sense Client-Managed. This month's topic is: Migrating Qlik Sense Enterprise.
Questions:
Resources:
Did we answer your question? Let us know by clicking the like button!
Click here to see video transcript
I'm developing an AR dashboard and I'm having trouble figuring out how to implement a weighted average days outstanding (WADO) metric for the entire company.
I'm successfully using the following expression to calculate WADO at the customer level:
sum(AMOUNT_DUE_LOCAL*Days_Past_Due)/sum(AMOUNT_DUE_LOCAL)
But when trying to use the following expression to calculate it for the entire company (while weighting a customer's total amount due relative to the entire company's amount due), I run into a 'nested aggregation' error:
Sum(
aggr(
Sum(AMOUNT_DUE_LOCAL * Days_Past_Due)/Sum(AMOUNT_DUE_LOCAL), CUSTOMER_NUMBER)* Sum(AMOUNT_DUE_LOCAL))
/ Sum(TOTAL AMOUNT_DUE_LOCAL)
I've attached a simple Excel example of the desired functionality to clearly demonstrate what I'm trying to do.
Any thoughts?
Wondering about Qlik Talend Data Integration Sessions? There are 11, in addition to all of the Data & Analytics. So meet us in Orlando, June 3 -5.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Join us on April 24th at 10 AM ET for the next Do More with Qlik webinar focusing on Qlik’s Data Integration & Quality solutions.
Your journey awaits! Join us by Logging in and let the adventure begin.
Qlik enables a frictionless migration to AWS cloud by Empresas SB, a group of Chilean health and beauty retail companies employing 10,000 people with 600 points of sale.
Qlik Luminary Stephanie Robinson of JBS USA, the US arm of the global food company employing 70,000 in the US, and over 270,000 people worldwide.
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.
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!