Hi, 

I was checking if we could install NPrinting, Alerting and Geo Analytics on the same server. couldnt find any articles related to it. I know that Qlik doesnt support QS and NP on a same server but not sure of NP and Qlik Alerting on the same server. 

Thanks in Advance

Qlik NPrinting Qlik Alerting Qlik GeoAnalytics 

I have an Application, In that a button is given to reload the data from the Sheet. Is there any possibility that the reload can be the done from the user end after publishing and giving access to the users to that dashboard.

Thanks in Advance.

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 , 

I am trying to develop a graphic extension. I created a button in the extension properties field. When I click on the button, I want to add the dropdowns that already exist . For example, when I press the dateDropdown button, it should be added to the properties field again.However, it does not make this addition with the code below. Do you have a solution? Thank you.

Preciso achar o Valor da Coluna 1 * Coluna 2(Relativo). Mas não estou conseguido.

Preciso criar um set analysis que trate (Pois o valor correto é diferente). 

Preciso de ajuda. 

So I have a table in my sheet in which I have amount, description and year so I want to have a column for the amount of the previous year for all the materials so that when we select any particular year the amount of the year selected and the amount of the previous year should come, how can it be done, I have tried set expressions but the desired output is not coming.

Before I start:

Talend Open Studio for Data Integration v8.0.1.20211109_1610

Windows 10

Java 17.0.8.7-hotspot

jtds driver

I am trying to Guess Schema for a tDBInput (Microsoft SQL Server) component. I get the missing library dialog, but there is no way to download the missing jar file.

I have a good connection to the internet as I am able to download and install other libraries. Just this one fails. Not even sure why I am getting this dialog on v8.0 as it does not happen with v7.3.

Hi, Below is the master calander we are using and the fiscal start month is = 7.

Here I want o calculate the daynumber starting month July every year.

Datefield:
LOAD date($(varMinDate)+IterNo()-1) AS DateNum_Fisacal
AUTOGENERATE (1)
WHILE $(varMinDate)+IterNo()-1<= $(varMaxDate);
Set vFM = 7 ; // First month of fiscal year

Calendar:

Load * ,Dual(fYear-1 &'/'& fYear, fYear) as FYear, // Dual fiscal year
Dual(Month_F2, fMonth) as FMonth; // Dual fiscal month

Load *,Year_F2 + If(Month_F2>=$(vFM), 1, 0) as fYear, // Numeric fiscal year

Mod(Month_F2-$(vFM), 12)+1 as fMonth; // Numeric fiscal month

Load Year(DateNum_Fisacal) as Year_F2, // Your standard master calendar

Month(DateNum_Fisacal) as Month_F2,

DateNum_Fisacal

Resident Datefield;