Hi, 

I am trying to build a department count KPI where the count is the same when a department is selected from 2 different filters.

Here is a sample data set:  it's a many to many relationship

When a department is selected from Assigned Department, the count derived (i.e. 5) is the correct count.  In this example, I'm selecting Dept 1 from Assigned and the associated records in Responsible are Dept 1, Dept 2, and Dept 3.  However, the count is 5 because the set analysis is only taking into account Assigned Department.

I need help with the expression so that when I also select the same department from the Responsible column, that the count will behave the same way, which is to take only Dept 1 into consideration.  Right now the count becomes 10 because it includes Dept 2.

It is correct to assume that both columns contain the same departments.  I tried using E() and P() but that doesn't work for Responsible Department. I still get 10 instead of 5.

Could anyone provide guidance on how I can force this count to work?

Thanks!

Hello,  when I do it, it works : 

LOAD *

FROM [lib://Sharepoint /Shared Documents/Offre /04/01- azer/1.01 vetement/file1.xlsx]

(ooxml, embedded labels, table is [RENDU ]));

I got just a file xlsx in my folder (1.01 vetement)

When I try to automate, I did : 

LOAD *

FROM [lib://Sharepoint /Shared Documents/Offre /04/01- azer/1.01 vetement/*]

(ooxml, embedded labels, table is [RENDU]));

The first code works  but the 2nd code say me :

error : BadFileSize

Thanks for reading me

Hi Fellow Qlikers, 

I need help with getting ranks for my data, the issue is that when a dimension value is having a same rank i.e 4-5, I need to sort that value based on another field, I have tried doing it but it seems to be not working as I am getting 1 as the same rank for all the values. 

Basically the data currently looks like this. 

Expression in Rank 1: 

Aggr

I want to sort the rank 4-5 into 4 & 5 giving [# 175 - Polymer Wax Polish 250 ml] as 4th rank and [# 170 - Wax Shampoo 250 ml] as 5 th rank. 

Meaning that I want them to be sorted on lift if the ranking is coming out to be same and want to show it in the Simple KPI rather than the chart. 

Do let me know if anything further can be provided for understanding the issue. 

Hello,

Does anyone know is there somekind service user for geoanalytics? or what user it uses?

I am running on prem enviroment with own qlik server and own geoanalytics server.

-V

Hi there,

I have a text box, which works like a selection object and enables users to choose day of the month. Is there a possibility to always select the last available day?

For example, if in my text box I have today numbers:

1 , 2, 3, 4, 5, 6, 7, 8, 9, 10

I would like to show all of the numbers, but select 10, because it is the most recent data. If tomorrow 11 appeared, I would like it to automatically switch to 11. Any hints?

Thanks in advance!

Hi everyone,

My requirement is to show Fiscal Year Revenue as a default number if no filter is selected but if  I select Effective_Region filter or Channel_type filter then numbers should change based on filter selection. I am using below condition for the same but unable to get output. Please help its a bit urgent

sum({1<Effective_Region=P()>+<Channel_Type=P()>} if(
[DateOfConfirmation.autoCalendar.Date]>=yearstart(addyears(today(),0),0,4) and
[DateOfConfirmation.autoCalendar.Date]<=Yearend(addyears(today(),0),0,4), TotalFeesbeforetax))

Thanks in Advance

Dear all,

Need help for below calculations:

Three measure to be calculated:

1) No. of hours between two dates including weekends

2) No. of hours between two dates excluding weekends.

3) Network days.

Note: Also need to make setting to consider first day of the week as SUNDAY and WEEKENDS days will be FRIDAY and SATURDAY.