Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a SQL Server database that has merge replication configured with another SQL Server, I need to replicate some tables using Qlik Replicate, we know that CDC cannot be activated, I would like to know what the restrictions are in relation to transactional replication, if This impacts merge replication that already exists, if Qlik uses other logs than the one already being used by MERGE.
Hi,
I am trying to get the data from previous month and also that has a specific condition. I am using this formula:
count({<Column.Variable = {'Condition'}>}Column.Variable), count(InMonth(Date.DateAppointment,today(),-1), [Record_ID]))
I can use both conditions separate but cannot find the way them together to get the records for that specific condition for the previous month.
Thanks,
Hi
I am trying to trigger to Qlik Sense task from c# .net code. Is there any sample code or any useful links which can help me get started?
Many thanks
Hello Everyone, I have a question for Qlik sense. I have a table that has a Date column and a quantity column. I need to create a master Item that calculates the month to date quantity.
I am attaching an Excel file that has those 2 columns and also the column of the MTD that I need to calculate as a master item
Can you please Help ?. Thanks
Hello all,
I'm facing a challenge getting last year sales based on a last year date we have, I have to use this date for comparison so I can't use the AddYear() or any of the system functions because of some special cases that require this logic. Basically I have my table below, and I want to write an expression for a master item (Sales LY). I've simplified the question in the below table.
Date | Date LY | Sales | Sales LY |
27/04/2024 | 29/04/2023 | 1,000 | ? |
26/04/2024 | 28/04/2023 | 2,340 | ? |
25/04/2024 | 27/04/2023 | 1,291 | ? |
24/04/2024 | 26/04/2023 | 3,382 | ? |
23/04/2024 | 25/04/2023 | 3,928 | ? |
| | | | | | | |
| | | | | | | |
29/04/2023 | 30/04/2022 | 1,283 | ? |
28/04/2023 | 29/04/2022 | 3,728 | ? |
27/04/2023 | 28/04/2022 | 1,827 | ? |
26/04/2023 | 27/04/2022 | 3,827 | ? |
25/04/2023 | 26/04/2022 | 7,482 | ? |
if I put this master item in a table with the 3 already provided columns, the orange numbers would populate the question marks.
Appreciate your support 🙂
Hello,
I am quite new to Qlik and have no real knowledge yet. So I apologize for what is probably a very simple question for you.
I would like to make an evaluation where I would like to count the number of our invoices using the count function.
The problem is that the same field which is called "Document No." also contains delivery note numbers.
I only want to count the invoices that start with AR....
Which settings should I make?
I hope you can help me
Boa tarde, Estou tentando fazer uma comparação entre o período atual - período passado / período passado * 100, o objetivo é conseguir uma variação de vendas em %, por exemplo, em meu filtro estou comparando o mesmo período em anos diferentes Fevereiro de 2023 e Fevereiro de 2024
A EXPRESSÃO QUE ESTOU USANDO É:
( ( Sum({<Ano_DC={"$(VAnoAtual_DC)"}, Mes_DC={"$(VMesAtual_DC)"}>} TOTAL_ITEM_DC) - Sum({<Ano_DC={" $(VAnoAnterior)"}, Mes_DC={"$(VMesAtual_DC)"}>} TOTAL_ITEM_DC) ) ) / Soma({<Ano_DC= {"$(VAnoAtual_DC)"}, Mes_DC={"$(VMesAtual_DC)"}> } TOTAL_ITEM_DC)
ENVIANDO AS VARIAVEIS
VAnoAtual_DC:
=MAX(Ano_DC)
VAnoAnterior:
=MAX(Ano_DC) -1
VMesAtual_DC:
=MAX(Mes_DC)
Hi,
Recently we tried to upgrade our Qlik Sense from May 2023 to August 2023 (IR). The upgrade went well for DEV and QA servers. But it failed on production servers. We had to restore production servers with backed up AMI. Now we are investigating the reason why it failed. We have realized that we made a mistake when upgrading QS production which has two nodes: We stopped services on both nodes and then ran installation on two nodes at the same time. We know it is incorrect. But why did it cause problem? I am writing a report and need to gather deeper information.
Based on installation log files, I can tell the failure occurred at ServiceDispatcher step. Error occurred when it tried to create schema 'qlik_notifier_service'. I checked the log file for the successful installation on DEV server. When it tried to create schema 'qlik_notifier_service' there, it skipped this step because "Schema 'qlik_notifier_service' already exists" (the sentence in log). Why did the installation not skip it during production installation?
The attached ServiceDispatcher_installation_logs.txt contains related content from log files.
We need to make sure there is nothing else which caused installation failure. Please advise.
Thanks
Hi,
I want to upgrade my existing version of Qlik Sense Enterprise from release February 2023 to February 2024. The existing version still uses the PostgreSQL 9.6 database. So I want to use the Qlik PostgreSQL Installer to upgrade and unbundle the PostgreSQL database.
I stopped all Qlik services except the Qlik Sense Repository Database. Then I start the QPI tool and at the first screen it displays 'No supported existing Qlik Sense PostgreSQL database found. This program will install a new PostgreSQL v14.8 database".
Why doesn't this QPI tool detect my existing database?
When I press next and fill out all fields, field 'database port' becomes red with message 'Database port already used by an external service in the system'. Port 4432 is used by the postgres.exe so then it detects?!
I have attached the pg_hba.conf and the postgresql.conf from folder "C:\ProgramData\Qlik\Sense\Repository\PostgreSQL\9.6". Files are renamed with .txt to be able to upload.
Also I have tried to change the 'listen_addresses' line to 'listen_addresses = '*' without any luck.
I'm trying to install the gateway, but during the RPM package installation, I'm getting the following error after the installation command:
I couldn't find anything related to this error in any part of the documentation.
I managed to generate the key, added it to the cloud successfully, but when I reach the step of activating the service, it simply doesn't exist. I don't know if there is any connection with the error before, but since it couldn't identify the file, when I try to start the service using systemctl, it says the service doesn't exist.
I don't know what went wrong with my installation. Could someone help me?
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.
Join us on May 15th at 11 AM ET to discuss the Qlik Ideation Process. Bring your questions.
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!