Qlik Community

Qlik Sense Deployment & Management

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

Highlighted
zied_ahmed1
Contributor III

Re: problem with map title

same value 1073

omarbensalem
Esteemed Contributor

Re: problem with map title

what about this?

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


ps: you have departments that are not associated with the existing docs; that's why when u do not select any department, u'll have the total count of the docs existing in ur model

but when u select all departments, u'll only have docs that are associated to ur departments

zied_ahmed1
Contributor III

Re: problem with map title

Yes same value


I think they will not select all departments so i seems good for me

Thanks a lot

omarbensalem
Esteemed Contributor

Re: problem with map title

ur model is not well created..

please close the thread

omarbensalem
Esteemed Contributor

Re: problem with map title

Try this:

count(total{<[DepartementsFR.Name]=p({<[DepartementsFR.Name]>}[DepartementsFR.Name])>} Docs)

and then :

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

GetFieldSelections([DepartementsFR.Name])&' : '& Num(Count(Docs)/

count(total{<[DepartementsFR.Name]=p({<[DepartementsFR.Name]>}[DepartementsFR.Name])>} Docs)

,'###0,00%')

)

zied_ahmed1
Contributor III

Re: problem with map title

This is the correct answer

Thanks Omar