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):

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:

1. Setting up data models for event-based projects?
2. How to visualize custom orders or real-time data using Qlik?
3. Any beginner tips for making the most of Qlik’s features for organizing large-scale events?

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.