Hi team,

I have filter, In that i have some values.

Eg:

A

B

C

D

if I select A and B its to display sum(Sales)

If I select A and B and C etc its to display count(Sales)

For Particular Selection, I need to show one measure,

If extra anyone Value is added in the filter it should show other measure...

Thanks in Advance

TLDR : I want to access an Excel file based on a sharepoint path I give manually.

What I've tried : you can give to a "Open file on Microsoft Sharepoint" component a path directly linking to a document, and then use a "Read Data From File on MS" to open it but it only works for CSV and JSON documents. 

You can also acces the document based on a Drive ID and Item ID with a "List Rows With Headers" for example. This solution however needs me to access every item of the file tree until i get to the file containing the excel wich is not really sustainable. 

So I would need a component that either open an xlsx document based on a path or give a Drive ID and Item ID based on a path.

Any other idea would help.

Thanks in advance,

Maxim Perolle

Hi Team,

We are getting below error in a task.

Could you please help us with the same.

SYS-E-HTTPFAIL, Cannot connect to sql server.
SYS,General_Exception,Cannot connect to sql server , sqlstate:08001 NativeError:-2146893016 Message:[Microsoft][ODBC Driver 18 for SQL Server]SSL Provider: The received certificate has expired.

Task Name replication task encountered the following error:
Creating Metadata Manager's utility components failed Cannot create the target utility component failed while preparing stream component 'Task Name'.
Cannot coonect to SQL Serv
RetCode: SQL_ERRO SqlState:08001 NativeError:- 2146893022 Message:[Microsoft][ODBC Driver 18 for SQL Server]SSL Provider:The target principal name is incorrect.

Regards

Mrunal

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!

Hello

We have a Qlik CDC only task and we performed a modification on a filer transformation on a table.

We stopped that task , perform Import task with the desired modifications and perform (for mistake) resume processing of the same task.

The filer was loaded correctly (and unexpectedly !)

We remember in the past documentation that , if we have to perform a filter modification, we are aware that we will perform stop+import of the task (or perform modification by Qlik Enterprise Manager GUI and save the currently running task) and perform reload target

Can you explain us what happened ? in what case resume processing is acceptable for filter modifications scanarios ?

Lt us know

Regards

Alessandro Ferrario

Hello,

I want to remove a colum from dynamic type input in tjavarow.

I tried this but it didn't work :

Dynamic dyn = row3.table;

dyn.removeColumn("NameColonneToDelete");

Can anyone help me ?

Thanks

Is there any way to remove Cloud Engine from the Task Config in Cloud?  I have a cluster I run of servers on AWS setup and I do not use Cloud Engine at all.  I have a separate workspace (not default) and it still shows 2 cloud engines in my drop down when configuring a task.  Even though I have it turned off.  I would prefer not to see Cloud if cloud is turned off.  Every job we setup defaults to cloud and we have to change it to our cluster each time.