Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I've been stuck on this all day and its driving me nuts. I've gone through similar posts but haven't been able to crack it. Even help from one of my experienced colleagues didn't crack it...
I have calculated the time duration between 2 time stamps. I now want to categorise this time duration.
The first part of the script works fine:
[vw_ngd_consumer_ee_pn_trdb.test_initiate_time] as "RunTime_Initiate_Time",
[vw_ngd_consumer_ee_pn_trdb.test_completion_time] as "RunTime_Completion_Time",
Time(Timestamp([vw_ngd_consumer_ee_pn_trdb.test_completion_time],'YYYY-MM-DD hh:mm:ss')-timestamp([vw_ngd_consumer_ee_pn_trdb.test_initiate_time],'YYYY-MM-DD hh:mm:ss'),'hh:mm:ss') as "NGD Run Time",
Now here's where my issue is. I want to create a new table that categorises this field. Alternatively I could add this categorisation as an extra column in the original dataset, but I thought it might be easier to create a new table. Maybe now?
So the script I've created currently looks like this:
Run_Time_Table:
LOAD
[NGD Run Time],
IF(Time([NGD Run Time]),'hh:mm:ss')<=('00:01:00'),'Less than 1 minute',
IF(Time([NGD Run Time]),'hh:mm:ss')<=Time('00:02:00'),'Less than 2 minutes',
IF(Time([NGD Run Time]),'hh:mm:ss')<=Time('00:03:00'),'Less than 3 minutes',
IF(Time([NGD Run Time]),'hh:mm:ss')<=Time('00:03:00'),'greater than 3 minutes','Unknown' as "RunTime_Category"
Resident [NGD_Test_Data];
This results in the following error message:
I'm completely stumped as to what the issue is. I've checked the field names and I can't see any duplicate fields, but obviously I am using [NGD Run Time] field a few times, but that should be fine?
Can anyone spot where I'm going wrong?
Hi
When a pie chart or a donut chart is natevely created in the PixelPerfect template, there is a bug displaying the last label of the percentage.
In fact if the last percentage and first percentage values are between 1% and 3% than their label get swapped clockwise after the first label. Wrongly displaying the labels.
The Resolve Overlapping Mode property behavior does not move the label to the right side. See attached images.
It happens on all NPrinting versions.
How can this be fixed?
Kind regards
Hatus Peters
hi all
i have data in which i want create Hierarchy which is having multiple parent and Multiple Child\
i have Attched data file
and image also the Hierarchy which i want to create
is it possible in qlikview
plz help
thanks and regards
All, Does QS Business SaaS have a limitation on the number of objects within an area? I set the Max visible objects to 10000 and yet I see empty spots. Can you please advise?
@Anonymous
Hello Community,
Recently I discovered that I can make que QlikViewServer Service make a CalData.pgo.xml, so i wanted to do an app to see the document cals assigned and last used, but the Last used date comes encrypte like this:
I want to know if is there any way to decrypt those dates so I can do some kpis with them.
Thank you.
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 everybody!
I'm setting up an integration with Json Web Token (JWT) and I want to create sessions longer than an hour, is this possible?
The payload I am using is the following:
const payload = {
jti: uid.sync(32),
sub: `${userName}`, // Usuário obtido do banco de dados
subType: "user",
name: `${userName}`,
email: `${email}`,
email_verified: true,
iat: Math.floor(Date.now() / 1000),
exp: Math.floor(Date.now() / 1000) + 60 * 60, //Here I want to increase the timeout to more than an hour
nbf: Math.floor(Date.now() / 1000),
iss: "myISS",
aud: "qlik.api/login/jwt-session",
groups: [
"Analytics Admin",
"Data Admin",
"Data Space Creator",
"Developer",
"Managed Space Creator",
"Shared Space Creator",
"Tenant Admin",
],
};
Hi, we are in the process of porting a Qlikview app to Qliksense cloud, though we are running into a problem right now. On our qlikview app, we have a document trigger/action which automatically selects possible value(s) for some certain fields, with a few of them being hidden fields(leading underscore fields such as _UserTypeID and _GranteeID). We are unable to emulate this behavior on Qliksense, as the sheet actions will only allow us to choose non-hidden fields. Is this a limitation from Qliksense that we cannot bypass? And if so, what are the workarounds that we can use? Thanks.
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
Hi all,
i'm trying to login to qlik using a JWT token but when i try to post to https://horsadev.eu.qlikcloud.com/login/jwt-session with the the web integration id and the bearer token i get the following error.
the token is made up like this:
user details: name sub and email are the exactly like the console.
any idea of what can go wrong here?
thanks,
Loris
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!