Hello Everyone, I have a question for Qlik sense. I have a table that has a Date column and a quantity column. I need to create a master Item that calculates the month to date quantity. 

I am attaching an Excel file that has those 2 columns and also the column of the MTD that I need to calculate as a master item

Can you please Help ?. Thanks

Hi Everyone,

I have a folder with 3 years of data (monthly exports .csv files) there are total 36 files in the folder and names of files are Sales_Jan2023, Sales_Feb2023,Sales_Mar2023.

I am trying to load only the latest 6 months of data out of 36 files, How Can I do that, please help.

Hi All,

We are currently on May 2023 Patch10 version with Postgres12.

Understand from our security team that there are the below two vulnerabilities for Postgres

1. Cross-Site Scripting Vulnerability (CVE-2024-4216)

This vulnerability exists in pgAdmin, specifically inside the /settings/store API response json payload. Exploiting this vulnerability could allow a threat actor to execute malicious script on the client end and steal sensitive cookies.

1. Multi-Factor Authentication Bypass (CVE-2024-4215)

This vulnerability affects pgAdmin, which could allow a threat actor to bypass multi-factor authentication on affected versions.

Is anyone aware if it affect Qlik Sense enterprise on windows?

Thanks & Regards

Amar Shedage

I made a measure for taking into account the efficiency of certain producers 

(
	Sum(
    	Aggr(
        	Count( {< ACTION_CODE = {'LABOR_OFF'}>} distinct MainSFC) * Standard_Time,
            MainSFC)
	)
)
/
(
	Count( 
    	distinct WorkingDay) 
        * 7.5 * 60)

And it works fine for the single producer. I want to abstract this, make one that takes into consideration ALL of the producers/employees, so in my mind I tried to do: 

(
	Sum( {<Employee=>}
    	Aggr(
        	Count( {< ACTION_CODE = {'LABOR_OFF'}, Employee=>}} distinct MainSFC) * Standard_Time,
            MainSFC)
	)
)

/

(
	Count( {<Employee=>}
    	distinct WorkingDay) 
        * 7.5 * 60)

But this doesn't work, and gives me null values. How could I fix this? 

Hi,

I have migrated a .nsq file from NP-v16 to the Qlik Nprinting 2021 and changes to reports.

Now i want to import only one specific Report from .nsq zip file to overwrite the recent changes.

When i clicked on Import NP 16 Report(as in below screenshot), it shows all the other report except the report I want to replace. 

Any suggestions, please.

We have data in this format:

and I'd like to generate a table like this

I'd like to avoid any loops if possible, since we have many KPI's, Markets and Businesses.

“min(aggr(minvalue,[shed.id], medvacname”

Above expression is use to get the minimum loss by the medicine
in this expression ‘minvalue’ is a master measure which is

if(Min(aggr(Sum(Cumm_CulledMedicine)+sum(Cumm_MortalityMedicine),[shed.id],medvacname))>0,min(aggr(Sum(Cumm_CulledMedicine)+sum(Cumm_MortalityMedicine),[shed.id],medvacname)))

What I actually wants a name associated with the above expression(“min(aggr(minvalue,[shed.id], medvacname))”) but it is not working and I did not understand the problem. How can I get the medvacname where the minvalue in minimum but it should be greater than  zero

Hello. I have a table in table format, and you can add columns to it by selecting them. There are quite a few columns. There are three accounts that can access this table, and what I need is for only the selected account to be able to select all the columns. Other accounts should not be able to select all the columns.

We have some python scripts residing in one of the qlik nodes which is connected to qlik sense (which resides in aws server) through analytic connection
is it possible to move those scripts to aws lambda function and establish a connection from Qlik sense enterprise windows ? I believe AWS lambda connector will work with Qlik cloud only.

Hello Experts, 

I want to do an analysis on Normal Distribution for Revenue. But not sure how to proceed with it as my requirement is to develop Bell Curve for Revenue as a measure. I am not sure how to proceed with it. Can anyone help me on this as anyone did any analysis on Bell curve for revenue.  

     I am using web version so please do not send the qvf files as will not be able to open them.

Thanks in advance

Ferha