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

Hi

A user can export and import existing application in QMC but cannot from Qlik Community.

i.e. https://community.qlik.com/t5/Official-Support-Articles/Top-10-Viz-tips-part-VII-QlikWorld-2023/ta-p/2068005

Also unblocked the file after download.

As I am Admin I can do it. So what could be possible issue?

Hello,

I want to view my dashboard. But after I logged in it says "No Tenants to manage". I don't want to use qilk sense, But I just want to access my old dashboard. Please help me out with it.

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.