Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, All,
Our NPrinting DEV server (May 2023 IR) has been running well for months. But yesterday I noticed its engine status is offline. Meanwhile, a task hangs (with 'Running' status) there forever.
So far I have checked/done the following but they do not help:
. All NPrintng services are running.
. I have rebooted the server a couple of times.
I found this error in engine.log and scheduler.log: RabbitMq service is not connected - trying again in 60 seconds. ERROR: RabbitMQ.Client.Exceptions.BrokerUnreachableException: None of the specified endpoints were reachable
I followed the instruction in this link (https://help.qlik.com/en-US/nprinting/May2023/Content/NPrinting/Troubleshooting/Qlik-NPrinting-Messaging-Service-startup-connection-problems.htm) and executed ''rabbitmqctl.bat status' command, it gave me error saying I need to run 'rabbitmqctl start_app' command first. So I ran that 'rabbitmqctl start_app' command. It only displayed a message 'Starting node xxxxx...' and then returned. But the problem remains.
I have submitted Qlik support ticket. Just want to seek advice from the community while I am waiting.
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 🙂
Hi,
We are dynamicly renaming the columns of a tDBInput. Up to now it has been a mysql where we got our data from but we have decided to move to Snowflake but when we exchange the tDBInput (mysql) to tDBInput (snowflake) the same code fails with an index outOfBounds exception where the index is -1 in an array with the length of the number of columns. After doing a java debug and stepping through the code i saw that for some reason the snowflakeInput requires the columnnames to always stay the same because for some reason it trys to look at the metadata of the first dynamic row while loading the second so the job fails after the first row. This is also true when using the jdbc connector directly via tJDBCInput
The isolated job setup looks like this:
tDBInput(Snowflake)(schema: resultset -Dynamic) -> tJavaFlex -> tLogRow
Pseudo Code in tJavaFlex (Main):
for(Columns in resultset){
if(columName starts with "H_"){
rename columnName so it Starts with HS instead;
}
}
As i said using any other tDBInput (oracle or mysql) this setup works, same code but with snowflake as the input the job explodes. Why is that and is there a workaround? (Talend Version we are using is 7.x)
Hi,
In the example of getting the impersonation access token data-get-access-token is associated with the function that fetches the access token.
If I already have the access token because I fetched it earlier, how would I format it so that it fits the variable or if I have to, set it in the function getAccessToken()?
Oi galera.
Integrei uma base de dados My SQL de um servidor local no Qlik Cloud.
Algumas tabelas consigo adicionar pelo Gerenciador de dados em outros casos aparecem a mensagem de que os dados não podem ser adicionados.
Eu acho que pode ser Timeout.
Alguém já passou por isso? Podem me dar algumas dicas, sou novato no Qlik.
In URL/Expression window I have this (simplified url) and this works
='http://mycompany.net/jump.ashx?employeeId=' & [Employee Id]
I’m going to use this in 10+ places so like to put this in a Script variable
Cannot figure out the syntax for referencing the dimension in a script variable, so I created a script variable for the dimension, Employee Id
In Script
vEmpId ='[Employee Id]';
in the URL/Expression Window, the variable works
='http://mycompany.net/jump.ashx?employeeId=' & $(vEmpId)
But when I tried to put that statement into the script format and I cannot figure out how to do it
varURL = ='http://mycompany.net/jump.ashx?employeeId=' & '$'&' (vEmpId);
varURL = ='http://mycompany.net/jump.ashx?employeeId=' & chr(36) & (vEmpId);
Surprisingly I am getting a lot of
Thanks in advance
Team,
I developed 2 container in which there is a 4 separate tab common in both container.
Now the request is if i selected New user tab in First Container it should select New User tab in Second Container.
Is it possible to implement, If Yes can i get some help on this.
Thanks
Farsana
Hello all,
I am posting this relatable question many times but didn't get correct answer till now
I have 4 different columns
I created 4 different filter panes with one column each
Now I need to create a button when I click on that button all the values in 4 filter panes has to be selected at a time
Please help anyone.
Thanks
Kindly advise which kind of charts should I use for getting these box containers in Qlik sense.
Hi guys, I have an input table with the % of comission for each Product Type Sale for each SalesMan.
The table looks like this (in the real case the SalesManID is dynamic, it's not only for 4 salesman) :
4 | 5 | 12 | 14 | ||||
CompanyCode | FamilyCode | SubFamilyCode | FamilyDescription | SalesmanId4 | SalesManId5 | SalesManId12 | SalesManId14 |
1 | ANIM | ********** | XXX | 10% | 5% | 10% | 10% |
1 | APPR | ********** | YYY | 5% | 10% | 5% | 10% |
1 | AV | ********** | ZZZ | 10% | 10% | 10% | 5% |
And I'd like to get an output of a desired table like this :
FamilyCode | SalesManId | %Comission |
ANIM | 4 | 10% |
ANIM | 5 | 5% |
ANIM | 12 | 10% |
ANIM | 14 | 10% |
APPR | 4 | 5% |
APPR | 5 | 10% |
APPR | 12 | 5% |
APPR | 14 | 10% |
AV | 4 | 10% |
AV | 5 | 10% |
AV | 12 | 10% |
AV | 14 | 5% |
Could anybody help me please? I don't know if crosstable it's the best option, I'm trying to do it but with no results.
PD : I've attached the example in excel, in order to make it easier for everyone to understand.
Kind regards, Marcel.
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!