Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

qluser01
New Contributor III

Selections and pie chart: show among all and among selection

Hi all!

I want to show a client position in all benchmark data, and also - in his/her industry.

What I have:

When I select a client (CLnum) in filter - I see pie chart colored where he relates to.

I use {1} in count() formula in order to leave all the data in pie chart.

I need to implement a Industry filter.

And If I also select an Industry - I need the data in pie chart show only the numbers of industry selected.

Now when I select the industry - it changes nothing on pie chart because I use {1} in formula....

How to do it?

See the attached file...

Tags (3)
1 Solution

Accepted Solutions
omarbensalem
Esteemed Contributor

Re: Selections and pie chart: show among all and among selection

Like this?

See the attached app:

New measure: Count({<Response=,Cl_answ=,CLnum=>}Response)

5 Replies
laddu_927
Valued Contributor

Re: Selections and pie chart: show among all and among selection

Can you share sampe data or a .qvf??

omarbensalem
Esteemed Contributor

Re: Selections and pie chart: show among all and among selection

Like this?

See the attached app:

New measure: Count({<Response=,Cl_answ=,CLnum=>}Response)

qluser01
New Contributor III

Re: Selections and pie chart: show among all and among selection

Exactly!

What does this measure mean? (please give a link to description )

You state nothing after equation sign 0-0

NOW, when you select CLnum  -> you have only one Industry available to select (thats correct) - but I don't want to see the list with gray industries:

IS IT POSSIBLE to show "SHOW IN IN INDUSTRY" button - if its pressed (on) - GREEN - the Industry of the Client filter applies, if its not pressed (regular) - no industry filter applied.

omarbensalem
Esteemed Contributor

Re: Selections and pie chart: show among all and among selection

Count({<Response=,Cl_answ=,CLnum=>}Response)

That means, count response no matter the selection of respnse, Cl_answ and CLnum.


When you were using the measure:

count({1}Response) ; the 1 meant count response no matter any selection on any field.

But you can break this appart and choose what to work with ifor you specific measure.


In fact; as I previously said Response= means don't take onto consideration the selections made in the field Response; but in other words, and more accurate one, that means, work with ALL OF THE VALUES of the Response fields.

So Response= means Response=All values.


And that's why if you select a Response, your chart won't be affected since you forced it to work with all the values of the field Response.


Hope that was rather clear

qluser01
New Contributor III

Re: Selections and pie chart: show among all and among selection

Is it possible to state not fields you want the chart to be immune to:

Count({<Response=,Cl_answ=,CLnum=>}Response)


but only those fields you want chart to be responsive to

how to state "react only to Industry field" ?