Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Requirement: I know how to do calculations but I need help how to input/handle data like monthly associated with (P Release date) and calculate monthly data in the table. (do i need any counter or loop or group by with resident load in script) ?
I have a huge data (P Release Date) from 2019 to current but here I am using inline table (sample data) to understand the requirements.
Inline Table (data):
main:
load * inline [
P Release Date, Deleted On, PO Release Date
12/21/2022, -, 1/18/2023
12/23/2022, 2/27/2023, -
12/27/2022, -, -
1/4/2023, 1/24/2023, -
1/4/2023, -, 1/17/2023
1/4/2023, -, 2/28/2023
1/4/2023, -, 11/30/2023
1/6/2023, -, 2/9/2023
1/6/2023, -, 2/16/2024
1/11/2023, 5/10/2023, -
1/17/2023, 3/17/2023, -
1/17/2023, -, 4/11/2023
2/2/2023, -, 2/7/2023
2/2/2023, -, 6/21/2023
2/6/2023, 6/6/2023, -
2/15/2023, 9/11/2023, -
2/15/2023, -, 3/14/2024
3/2/2023, -, 5/3/2023
3/2/2023, -, 8/16/2023
3/2/2023, -, 9/22/2023
3/6/2023, -, 1/2/2024
3/30/2023, 4/11/2023, -
3/30/2023, 6/7/2023, -
3/30/2023, 8/7/2023, -
3/30/2023, -, 4/20/2023
3/30/2023, -, 8/29/2023
];
Output Result (in the table):
|
Calculation 1 |
Calculation 2 |
Calculation 3 |
Calculation 4 |
Total of calculation 1,2,3, and 4 |
Jan 2023 |
0 |
1 |
1 |
0 |
2 |
Feb 2023 |
1 |
4 |
3 |
0 |
8 |
Mar 2023 |
1 |
3 |
4 |
0 |
8 |
Calculated Columns 1, 2. 3, 4, and 5.
Calculation 1 :
P Release Date is before start of month
Deleted On is blank
PO Release Date is blank
Calculation 2 :
P Release Date is before start of month
Deleted On is blank
PO Release date is after start of month
Calculation 3 :
P Release Date is before start of month
Deleted On is after start of month
PO Release Date is blank
Calculation 4 :
P Release Date is before start of month
Deleted On is after start of month
PO Release Date is after start of month
Calculation 5 :
Add 1, 2, 3, and 4.
Thanks in advance.
Sara.
I am trying to log into the Qlik Product Downloads page, but I get an error:
I've tried 2 accounts and see the same issue with both.
Is anyone else having the same problem? Wanted to get an upgrade done OOO, but looks like I'll have to do it one evening next week instead as there's no support until Monday (so the chat bot informed me).
https://community.qlik.com/t5/Download-Qlik-Products/tkb-p/Downloads
I’m new to Qlik and currently working on an event project where I need to track data like guest lists, custom pahare (glasses) orders, and engraving requests in real-time. I’m hoping to use Qlik to analyze this data and make everything run smoothly.
Any advice on:
Hi,
Would like to ask if how to automatically assign the new users as basic users.
the tenant of our client is using Google SAML as IDP and they don't want to manually assign every time there is a new user logged in.
Thank you.
Hey, We've just upgraded to Studio v8 and have republished all our existing jobs. They have all published and ran in the cloud successfully except for 1 job. For this job, the publish process completes with the success message but there is nothing in TMC or on the server so it hasn't worked, however, there are no errors or warnings anywhere. Furthermore this job runs fine locally in studio and i can do a build to my local machine again, without any errors so something is going wrong on the journey to the cloud.
Any ideas?
Studio 8 R2024-11v2
Thanks
Anyone faced the below error while migrating Qlik Apps to Cloud using CLI ?
qlik :
At Folderpasth\7_migrateapps.ps1:9 char:14
+ $cliuserid = qlik user me -q
+ ~~~~~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (:String) [], RemoteException
+ FullyQualifiedErrorId : NativeCommandError
Hi
I need to do a binary load from a Qlik Sense App to another QS app but the Qlik help isn't really helping me much.
The issue I have is that the apps stored in Qlik Sense don't appear to be stored as QVF's on our server, they seem to be stored as .FILE
So When I try to create a connection to the file, the format is not recognised. I seem to remember that when you export these files, they convert to QVF's? I can do this and save somewhere but then how would this exported file get refreshed so that my binary load is always getting latest data?
What am I missing?
Thanks
I have this situation that I have few schemas with the same table names in every schemas and when I am adding these tables names are changed to table_name_1 and it is replicating with the same name with "_1" which is different name like in the source. I would like to handle it somehow. In old qlik every table was represanted like schema.table_name and it was not any issue when few schemas had the same table names.
How can I filter a number of records from each table when replicating a database? For example, the database has 10 thousand tables and each table has 1 million records. I would like to replicate only 100 records from each table.
14x Olympic Medalist. 16x World Record Breaker. And Qlik Connect Keynote Speaker. Save $500 until Dec. 31, 2024
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row.
Qlik Reporting Service received a significant upgrade with several new features!
Join us on Jan. 15 for expert guidance on thriving post-AI with After AI: Reinventing Data, Insights, and Action Amidst the Noise.
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 enhances decision-making with high-speed insights, as Mayborn Group integrates data from various functions across their global operations, gaining a competitive edge in the childcare industry.
Nortera leads agricultural manufacturing analytics and automation with Qlik, reducing short-shipment rates and annual savings in water consumption.
Qlik Data Integration transforms Airbus' aircraft production, leading to over 150 replication tasks and informing more efficient analysis.
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!