Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
zied_ahmed1
Specialist
Specialist

problem with map title

Hello I have this map and i would like when i select one or N department i have the % of the Docs:

I used this but it doesn't work :

=If(GetSelectedCount([DepartementsFR.Name])=0,'',[DepartementsFR.Name]&' : '&

Num(Count({<[DepartementsFR.Name]={"$(=Only([DepartementsFR.Name]))"}>}Docs)/Count(ALL Docs),'###0,00%'))

%_1.PNG

%2.PNG

45 Replies
zied_ahmed1
Specialist
Specialist
Author

=If(GetSelectedCount([DepartementsFR.Name])=0,'',

GetFieldSelections([DepartementsFR.Name])&' : '& Num(Count(Docs)/Count(total {<[DepartementsFR.Name]>} Docs),'###0,00%')

)

OmarBenSalem

the expression u're using?

zied_ahmed1
Specialist
Specialist
Author

this one :

=If(GetSelectedCount([DepartementsFR.Name])=0,'',

GetFieldSelections([DepartementsFR.Name])&' : '& Num(Count(Docs)/Count(total {<[DepartementsFR.Name]>} Docs),'###0,00%')

)

OmarBenSalem

create 2 kpi objects:

1) count(Docs)

2) Count(total {<[DepartementsFR.Name]>} Docs)

at first don't select ANYTHING and tell me what numbers do u see? is it the same in both KPI

then select all departments, and see what happens

then select some departments and see what happens

zied_ahmed1
Specialist
Specialist
Author

if i don't select anything i have the same value

if i select all departments i have :

Docs2.PNG

if i select two departments :

Docs3.PNG

OmarBenSalem

when u do not select anything, u have count(docs) = 1073... ??

zied_ahmed1
Specialist
Specialist
Author

you mean count (Docs)

Docs = dos_ref_externe this is  just to simplify the name in the topic

OmarBenSalem

when u do not select anything, u have count(docs) = 1073... ??

zied_ahmed1
Specialist
Specialist
Author

yes yes

OmarBenSalem

what if u change this:

Count(total {<[DepartementsFR.Name]>} Docs)


to


aggr(Count(total {<[DepartementsFR.Name]>} Docs),[DepartementsFR.Name])