Hi All.

I am trying to count the number of records in my database which fall between 2 dates 'Target Date' and 'Issued Date'  So that I can tell how many items were issued on time.

I am using the following as an expression but getting zero as a result, however there are at least 4 which are issued within the target.

Count({<[Target Date] ={"<$(Date([Issued Date]"}>} [id])

Example dataThanks

Hey guys,

I started a new job couple of months ago and I have questions for you.

Company : Retail company with millions and millions of rows of sales. Thousand of sales daily

Currently : Each morning Qlik automations retrieve data for the DB and store it in .qvd files (qlik format) and then the different dashboard read those files

Scenario :

I'm the only BI person of the company and my job consist to retrieve data from the so called PostgreSQL "data warehouse" (but for me it's more of a database because it's straight raw facts and dimensions tables that we need to join) that our ERP company made available for us, transform that data and create different dashboards with Qlik.

At the moment, the company decided to do everything in Qlik, so the data is extract from the DB with qlik, transform in qlik load script and then use in the different reports.

I'm looking to modernize the stack, implement a more robust ELT/ETL process and create a more scalable approach because the company plan to grow a lot in the future.

What would you suggest to use at each moment of the process ? (preferably open-source)

Just so you know, intermediate person here (great ELT/ETL, SQL and Python knowledge).

Thanks !

Hi Experts,

I found some suspicious external programs tasks in the QMC on our Qlik Sense on premise. Is there a way to find who and how created those tasks? I suspect it was created by API calls, but I am not sure which user was used for those calls. Is there any log where I could find details about those calls?

Or in general, is there a way to block creating/executing all external programs?

Any idea will be very helpful.

Thanks

Dear All, 

Is there a way to Create/Trigger a notification for app reload status for Success/Failures.

Scenario 1: If app reload task fails in QMC -> Trigger email with details/message that - reload failed for that specific app.

Scenario 2: If app reload task is success in QMC --> Trigger an email with app name and time of reload.

Thanks in advance.

Hello All,

I wanted to learn and master Security rule and custom properties in Qlik Sense. However, it is hard to find any learning resource on this topic.

I have also seen the Continuous classroom courses which are provided by Qlik, However, didn't find any course related to this topic. 

Can anyone recommend where I get a video tutorial or in detailed documentation with different sort of scenarios and steps to achieve them? 

Dear all,

Sekking your kind guidance on how to get Qlik Partneship Certificate (my company is already partner and i have access to the partners portal).

Best regards,

Sakina

Binary [APP ID];

how can i use this in the app to take data from another app like 
i want the qvd i have to take 2023 only data
and the app im taking its bunary id to take only 2022 

how can i do this ? 

hello,
i have been loading 2022 2023 data everyday and works find expet today i got this 

Data has not been loaded. Please correct the error and try loading again.
The following error occurred:
Your quota limit of 5120.0MB was exceeded. You loaded 5142.3MB. Reduce your data within this application or buy additional capacity.
The error occurred here:

im trying to fix it but i dont know why, 

also i used to have 2021 2022 2023 data before so why does this happend how to fix it?? 

Dear all

Kindly advise how to exclude null value in using count function.

Not sure why count is 1 instead of 0 in Sept month since X is null (zero)?.

Thanks, Tracy

Hi All,

We are trying to extract Metadata and Lineage using QVF files for our Alation Catalog Project. We are facing difficulties while connecting to Qlik server and client is using On-Prem solution. Does any worked on Metadata and Lineage extraction from QVF files? if yes, can you please provide us the python script?

Regards
Bharath