I am trying to figure out the participation rate for our company's medical benefits (Enrolled vs Eligible). I need to look at just the current report effective date data and I need to just to include those that are enrolled in each plan divided by those that are a part of a benefit group that is eligible for medical benefits. This is what I have and just need some guidance to make it work.

(Count(distinct {<
[ReportEffDate]={$(=Max([ReportEffDate]))},
[MedicalPlan]={'Medical-Anthem Choice PPO', OR 'Medical-Anthem HDHP-Core', OR 'Medical-Anthem HDHP-Value'}
>} [ID])

/

(Count(distinct {<
[ReportEffDate]={$(=Max([ReportEffDate]))},
[BenefitGroup]={'ACA Regular Part Time', OR 'ACA Only Benefit Group', OR 'Hourly', OR 'Salaried'}
>} [ID])))

I have this existing expression 

round(Avg({<[Item Type]={'Inventory Item','Inventory Cebu'}>}Aggr(Date([Order Date1],'DD/MM/YYYY') - date([Approved Date],'DD/MM/YYYY'),

[Purchase Order No.],ShipID)))

I want to add that if Date([Order Date1],'DD/MM/YYYY') - date([Approved Date],'DD/MM/YYYY') is negative it would use Order Date 2.

And also if Date([Order Date1],'DD/MM/YYYY') - date([Approved Date],'DD/MM/YYYY') is negative and also Order date 2 is null it will not add up to the round(avg).

we did a patching for QEM server, and we notice that the tags are removed and for few particular tasks, we are not able to assign new tags too...  

Hi all,

I have Nprinting 16.0 and a want upgrade to 16.7 oder 16.9 to export my Project.

where can I fand the Installation Files?

On a new Server I installed NPrinting February 2014 SR2 and I have do move my Projects from my old NPrinting.

I want to create an automation that iterates over Excel files in a folder on Sharepoint. For each file found the Excel file should be opened and a Worksheet (always the same name) should be read. I can list all Excel files in the folder (List Files on Microsoft Sharepoint with a path, but Excel's List Rows from Worksheet requires a File ID. I can find the FIle ID manually by lookup, but how do I find it automatically from all files in the folder?

I have a worksheet with multiple tables.

example:

The tables on the bottom have to be filtered by the filter 'team'.

the table on the top has to be filtered on a hard value, independent of what is selected in the filter in the blue square.

I created a filter for the upper table with the expression:

if(Team='Staf', Groep,)

which worked.

But then I created the lower 2 tables which do have to be filtered by the selected value in the blue square (only 1 selected possible). However, this changes the table on the top also.

I then thought: I create an alternate state for the table on the top so the selection in 'Team' doesn't affect this table, but I ended up with 'Team' being in the selection bar, showing 'selection in 2 states'.

I do not want selections in 2 states. I only want selections in 1 state.

How can I achieve this? Is it possible to have the top table filtered on a hard coded value and not being affected by any selection made in this variable AND the variable not having 'selections in 2 states' in the active selections bar? I want to be able to quickly change the selection of 'team' as I expect the user not to understand for which state the selection has to be changed.

Hi 
I trying to load data from xlsx files that are sitting in a SharePoint directory, but getting an error during the load
I am using 

for each file in filelist('lib://test_Space:Office_365_Sharepoint - Qlik/Shared Documents/testReports/*.xlsx')
    LOAD 
    wh_id,
    EXPORT_DATE,
    client_code
  FROM [$(file)] (ooxml, embedded labels);
next file

but I am getting an error  

The following error occurred:
Connector error: Failed on attempt 1 to GET. (-2147024894, System.IO.FileNotFoundException, File Not Found.)
The error occurred here:
for each file in filelist('lib://eGold_Space:Office_365_Sharepoint - Qlik/Shared Documents/eGoldReports/*.xlsx')

I'm only getting the error when trying to load wildcard (*.xlsx) but if I am using a full name of one of the files in the directory it works 

Thanks in advance