Hi,

We have around 10 tasks which are triggered at the same time. I notice that after few tasks completed successfully, one of the task stuck at 50%progress(in Running status) even after generating the excel reports in output folder. So this and rest of the tasks stays in the queue for hours until i restart the 'Qlik NPrinting Engine'.

Any suggestions, please

Hello,

I have this load script for one of my app in Qliksense.

Table1:

Load

First_Name,

Last_Name,

Salary,

Fiscal_Year

SQL Select

FirstName as First_Name,

LastName as Last_Name,

Salary,

FY as Fiscal_Year

From XYZ_Table

In the sheet, I have this simple table with Fiscal_Year column that shows all the data for all the years.

User requested to filter the data to only shows the current year and two previous years. I have adjusted my code to this:

Table1:

Load

First_Name,

Last_Name,

Salary,

Fiscal_Year

SQL Select

FirstName as First_Name,

LasrName as Last_Name,

Salary,

FY as Fiscal_Year

From XYZ_Table

WHERE Fiscal_Year >= (YEAR(GETDATE())-2);   //to get only year 2024 and 2023,2022//

It loaded successfully and I got no errors, but when I go to my table in the sheet, I still see years from 2016-2021

I am not sure what I am missing. Could someone please help me with this?

thank you!

Hi everyone,

I hope this message finds you well. The reason of my message is that I'm working on a business flow in which I have to send a PDF report to some recipients based on their plan. For example, I have four customers, three of whom have the LIGHT plan (ID Plan 1) and one who as the FULL plan. In this automation, I would like to send the report to only those who have the LIGHT plan. However, the filter list block does not quite filter out the one with has the FULL plan (ID Plan 2).

I am getting of the four emails from a table I have in a Qlik App which is correct.

The condition I have in the filter list is the following:

However, I still have four items after filtering them.

On the other hand, here are the values that are stored in the variable, which are the emails based on their plan.

The emails are sent, but the mail block fails with the following error, “You must provide at least one recipient email address.” Therefore, the filter list block does not really filter that one value out.

Could anyone guide me of how to properly use the filter list block please?

Thanks a lot!

Hi ,

Can you give some example how to gives access group level qlik sense section access.

I have some requirement like below:

let's we have Total 6 user: They are divided into 2 Group.

How to Give access 2 group different level country access.

ex: 1st group need IND,USA access 

     2nd  group need UK,AUS access

I have provided the Data below

Sales:
Load * inline

[

Year, COUNTRY,Sales
2019, IND, 100
2020, IND, 200
2021, IND, 300

2019, USA, 120
2020, USA, 220
2021, USA, 500

2019, UK, 350
2020, UK, 650
2021, UK, 150

2019, AUS, 850
2020, AUS, 750
2021, AUS, 450
];