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? 

In QlikView, you can set a variable's value at the time the QVW is opened, by using the 'Set Variable' action in the 'OnOpen' trigger. 

I know that in Qlik Cloud, field selections can be set to default values when the app is opened by defining the field selections in a Default Bookmark, but how do you set a variable's default value when the Qlik Cloud app is opened? I can't find a way to set a variable's default value within the Default Bookmark config, so how else can this be done in Qlik Cloud, to provide an equivalent to QlikView's 'Set Variable' feature in the OnOpen trigger?

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.

I want to upgrade my existing version of Qlik Sense Enterprise from release February 2023 to February 2024. The existing version still uses the PostgreSQL 9.6 database. So I want to use the Qlik PostgreSQL Installer to upgrade and unbundle the PostgreSQL database.

I used version 1.3 instead of 1.4 of the QPI tool as my folder where Qlik is installed is not the default "C:\program files\qlik\sense" folder.

After a few minutes the QPI returns an error and refers to the log folder. Within this log folder in the install-postgresql.log file, the following lines are included:

-----------------------------------

Called ClearAcl (C:\Program Files\PostgreSQL\14\data)...
Executing batch file 'rad811EC.bat'...
C:\Program Files\PostgreSQL\14\data NT SERVICE\TrustedInstaller:(I)(F)
NT SERVICE\TrustedInstaller:(I)(CI)(IO)(F)
NT AUTHORITY\SYSTEM:(I)(F)
NT AUTHORITY\SYSTEM:(I)(OI)(CI)(IO)(F)
BUILTIN\Administrators:(I)(F)
BUILTIN\Administrators:(I)(OI)(CI)(IO)(F)
BUILTIN\Users:(I)(RX)
BUILTIN\Users:(I)(OI)(CI)(IO)(GR,GE)
CREATOR OWNER:(I)(OI)(CI)(IO)(F)
APPLICATION PACKAGE AUTHORITY\ALL APPLICATION PACKAGES:(I)(RX)
APPLICATION PACKAGE AUTHORITY\ALL APPLICATION PACKAGES:(I)(OI)(CI)(IO)(GR,GE)
APPLICATION PACKAGE AUTHORITY\ALL RESTRICTED APPLICATION PACKAGES:(I)(RX)
APPLICATION PACKAGE AUTHORITY\ALL RESTRICTED APPLICATION PACKAGES:(I)(OI)(CI)(IO)(GR,GE)

Successfully processed 1 files; Failed processing 0 files

Removing inherited ACLs on (C:\Program Files\PostgreSQL\14\data)
Called Die(Failed to reset the ACL (C:\Program Files\PostgreSQL\14\data))...
Failed to reset the ACL (C:\Program Files\PostgreSQL\14\data)

Script stderr:
Program ended with an error exit code

-----------------------------------

I'm an admin and I run the tool as administrator. Also I disabled UAC, but without any success. Please help.

Hi all,

I am trying to access files in a folder on a remote server.

The first issue was that I could reach the folder but could not see the files - this was solved by giving the Qlik user full control over the files.

Now the issue is that when I press one of the files to open it and choose whatever I need - nothing happens. it does not response.

The user has "Root admin" role.

Any ideas?

Regards.

Hello May! We are halfway through 2024. This month's focus is on a rising star. A member who joined the Qlik Community not seven months ago has already posted over one hundred times. You can see him on the monthly leaderboard. Many of the answers he’s provided are marked as accepted solutions. He shows his appreciation regularly by liking others' posts. This May, we are featuring a Qlik Partner and a Community member with a rank of Creator II, Maxime Piquet, AKA mpc.

Check out our rising stars story:

Allow me to introduce myself; I'm Maxime. As a seasoned data consultant, I've been harnessing the power of Qlik tools since 2016. My journey began with QlikView 11.2, followed by Qlik Sense in June 2017, and then Qlik Cloud. I've honed my skills in various areas, including app development, optimization, architecture, administration, upgrade, and migration. I'm proud to say that I'm newly certified.

When I embarked on my Qlik journey, the Community became my guiding light. It was my go-to for knowledge enhancement and assistance. Today, I'm privileged to give back and support my fellow Qlik Community members. Sharing and helping are not just values I hold dear but also ones that my company cherishes.

I like to eat, drink, and repeat. I enjoy strength training and climbing. I love cooking, mechanical work, and sports. In addition, I enjoy DIY projects and the watchmaking industry. I’m curious, and I love to discover new things! Share with me your hobbies!

Please show Maxime how much we appreciate his contributions to the Qlik Community. He is an inspiring example of a rising star. Like and comment, and, as Maxime said, share your hobbies.

Thank you, Maxime, for being our May featured member. @Jamie_Gregory @calebjlee @nicole_ulloa @Melissa_Potvin @mpc