Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Just need a conformation of header__timestamp in regards to reading from the Log stream task:
Is the header__timestamp in the S3 json file the timestamp of the change on the source?
Or the time the change was written to the log stream?
Estoy con un problema en qlikview, estoy usando o tratando de publicar un tablero con un mapa en svg, en el developer el reporte trabaja bien, el problema esta cuando entro al publisher, el mapa no se ve.
ya instale y desinstale the svg extension, ya copie el contenido de la carpeta de la extencion a una ruta dentro del server, y aun asi no logro ver el mapa.
las direcciones donde esta el contenido del svg son.
C:\ProgramData\QlikTech\QlikViewServer\Extensions\Objets y C:\Users\administrador\AppData\Local\QlikTech\QlikView\Extensions\Objects.
Este es el post
https://community.qlik.com/t5/Qlik-Application-Automation/Publish-Image/m-p/2441326#M3681
Gracias
Hi QV Community, i need help i hope any one can help me.
I have a project to publish a vector image, a map converted to vectors, I have already made the map, it is already connected to the database, on the desktop it works very well, but when I want to see that published image, the report does not show it .
Any idea, Tks.
Hi Support,
We have recently seen an issue where the Qlik Enterprise Manager service fails to start with the QEM logs indicating the following error:
"[ERROR] REPO-E-FACSQLREP, Failed to connect to SQLite repository 'C:\Program Files\Attunity\Enterprise Manager\data\rtdata.sqlite' "
We were able to resolve the issue by stopping the QEM service and renaming the rtdata.sqlite file to rtdata_old.sqlite, and then renaming the rtdata.new.sqlite file to rtdata.sqlite. After then running the command to upgrade the repository (aemctl.exe repository upgrade), the QEM service was able to run and the console could be accessed.
Previously when we have seen an issue with a data repository file it has been a result of memory or disk space issues on the server. However, in this case, there have been no reported memory/disk space issues on the server. What we'd like to understand is what are the possible reasons the rtdata.sqlite file becomes unreadable/corrupted.
This instance of Enterprise Manager is v2023.11.0.259
Thanks,
Nak
After using AutoML to predict weather, I inputted the predicted results and actual temperature table into Qlik Sense. The two are connected by date.
Formula of date for predicted weater:
Date#('202303' & num([automl_row_index]+1,'00'), 'yyyymmdd'), 'yyyy/mm/dd')
Formula of date for actual weater:
Date( Date#( Year & Num(Month(Date#(Month, 'MMM')),'00') & num(Day,'00') ,'yyyymmddd'), 'yyyy/mm/dd')
Yet, the dates are sorted like this in the filter pane:
it is orderd by day instead of month and then day
Hi - I am using an Org Chart Custom Object from the Qlik Visualization Bundle. I was wondering if I could place a KPI inside the org chart so that clicking it navigates the user to a different sheet inside of the app. The reason I am asking this is because our org chart is large and I would like to have different divisions on different sheets.
I would like to have the tree look something like this:
President
|
v
CFO
|
V
"Click here for Finance Department Org Chart" KPI that navigates to a different sheet
Hi everyone
i am creating a Pie chart where i need a common year filter i already tired with Canonical Date data is coming wrong
I currently have a Pivot Table that is displaying the total number of records in different work queues, broken down by their current SLA status (Green, Yellow & Red). Sample screenshot shown below:
What I'm trying to accomplish, if possible, would be to have a couple of Qlik buttons that could perform filtering of what is being displayed on the Pivot Table. For example, Button 1 could filter out any Queues with zero records. Button 2 would filter the pivot table to only display queues that have records in a Red SLA status. Is this possible? I've tried numerous things that I've found online but haven't found the right answer or example yet.
Thanks for any assistance that can be given!
Qlik Compose for Data Warehouses
We run Compose on-prem, writing to a SQL Server instance also on-prem. Our DBA has 4-hour backups for all the company's SQL Servers which is supposed to truncate the transaction logs for all the databases after doing so. However, the logs for both my test and production data warehouse databases seem to be immune to such truncation:
Notice in particular the fact that the log for the test data warehouse is actually bigger than the test data warehouse itself!
Any systems-knowledgeable folks out there have any insights?
Is there a setting in Compose that I have inadvertently toggled to cause such behavior?
Hello everyone,
I have two similar tables that I want to do a full outer join on to become one. I want to include all fields from both tables where there is a match and create a column that explains whether the row is on the left table, both tables or right table. I've looked this up both the other questions in the community don't work for me. Example data below.
Server Warehouse:
Warehouse ID | Warehouse Name | Warehouse Manager | Warehouse Description |
WH1 | Cleveland_Main | John | This warehouse stores servers and is managed by John. |
WH2 | Richmond-1 | Bill | Warehouse for servers. |
WH3 | WH300 | Adam | Adam's warehouse. |
Database Warehouse:
Warehouse Code | Warehouse ID | Address | Assets | Status |
A382 | WH1 | 11125 Third St. | 201,362 |
Active |
B392 | WHID9 | 234 Reading Rd. | 580,122 | Active |
B555 | Ware2 | 8249 Foster Ave. | 586,322 | Inactive |
Expected Outcome:
Warehouse ID | Warehouse Name | Warehouse Manager | Warehouse Description | Warehouse Code | Address | Assets | Status | Group |
WH1 | Cleveland_Main | John | This warehouse stores servers and is managed by John. | A382 | 11125 Third St. | 201,362 | Active | Server and Database Warehouse |
WH2 | Richmond-1 | Bill | Warehouse for servers. | Server Warehouse | ||||
WH3 | WH300 | Adam | Adam's warehouse. | Server Warehouse | ||||
WHID9 | B392 | 234 Reading Rd. | 580,122 | Active | Database Warehouse | |||
Ware2 | B555 | 8249 Foster Ave. | 586,322 | Inactive | Database Warehouse |
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.
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!