Qlik Community

Qlik Sense Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

zied_ahmed1
Contributor III

Re: problem with map title

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

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

)

OmarBenSalem
Esteemed Contributor

Re: problem with map title

the expression u're using?

Highlighted
zied_ahmed1
Contributor III

Re: problem with map title

this one :

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

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

)

OmarBenSalem
Esteemed Contributor

Re: problem with map title

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
Contributor III

Re: problem with map title

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
Esteemed Contributor

Re: problem with map title

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

zied_ahmed1
Contributor III

Re: problem with map title

you mean count (Docs)

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

OmarBenSalem
Esteemed Contributor

Re: problem with map title

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

zied_ahmed1
Contributor III

Re: problem with map title

yes yes

OmarBenSalem
Esteemed Contributor

Re: problem with map title

what if u change this:

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


to


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

Community Browser