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

Hello,

Thanks Omar , I need to display the total when i select two departments :

For example :

if i select department 1 = 2% and department2 = 3% i will have 5% like result

Highlighted
OmarBenSalem
Esteemed Contributor

Re: problem with map title

u mean :

dep1,dep2 = 5%?

OmarBenSalem
Esteemed Contributor

Re: problem with map title

change it as follow:

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

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

)

zied_ahmed1
Contributor III

Re: problem with map title

if i select all departments I will have 100%

if i select  3 departments it gives me the sum of %

OmarBenSalem
Esteemed Contributor

Re: problem with map title

or try as follow:

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

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

)

zied_ahmed1
Contributor III

Re: problem with map title

I select Rôhne = 3,25% and Indre 0,16% I have 3.41 it's good

But i don't know why if i select all departments i don't get 100 %

(I am not selecting any filters )

OmarBenSalem
Esteemed Contributor

Re: problem with map title

per analogy, this works for me :

if(GetSelectedCount(Dim1)=0 or GetSelectedCount(Dim1)=count(distinct total {1} Dim1)

, 'all : '&num( sum(Expression1) / sum(total {1} Expression1),'# ##0,00%'),   GetFieldSelections(Dim1)&' : '& num( sum(Expression1) / sum(total {1} Expression1),'# ##0,00%'))

Capture.PNG

Capture.PNG

Capture.PNG

zied_ahmed1
Contributor III

Re: problem with map title

The only problem now is the total it's 67,16 when i select all departments

non6.PNG

OmarBenSalem
Esteemed Contributor

Re: problem with map title

please show me ur filter bar?

I mean this:

Capture.PNG

and tell me, what's the exact expression u're using?

zied_ahmed1
Contributor III

Re: problem with map title

non10.PNG

Community Browser