Excluding names from a Chart

[#1]

Hi All,

I'm struggling to exclude certain names from a BAR CHART n X-axis,  I have created

Field is Employee Names on X-axis and taken  Sum(Salary) on Y-axis.

As it stands, the Bar Chart is displaying every person's name in the company but i'd like to hide a few of them if possible so they no longer feature in the Chart...

in this i have some names like Ram, Vidya,Gopal,Bhavin,Amit,Sneha,Nisha,Isha,Sharan,Rekha only..

I am new QlikView please suggest me...

Thanks

venu gopal

[richard_simpson]

Hi Venu & Steve

Just remember that if you use set analysis like this, as well as hiding the unwanted names from your chart, it will also mean that if the user selects just one name in a filter (e.g. Gopal) the chart will still display salaries for all those named in the set analysis expression!

Steve's script option is a much neater solution if users are likely to filter by names...

Good luck

Richard

[richard_simpson]

Hi Christian

That is very interesting... but how does the second one exclude A? HAve you mistyped it, or am I misunderstanding something?

Thanks

[fkeuroglian]

Hi,

there is a correct way to do it but it is more dificult  and there is a fast way that i give you and example

you have to put it in the dimension, have to use a calculated dimension like this

=if(Employee<>'Ram', if(Employee<>'Gopall', if(Employee<>'Vidka',Employee) ))

you have to do it with all the user you DONT WANT TO SEE in the chart.

good luck!

Fernando

[christian77]

That's right I mistook.

I've corrected it.

[richard_simpson]

Oh, I see Thanks

[stevedark]

Hi Christian,

You will see in my expression the * before the equals symbol.  This means that current selections are taken into account.  Testing again I see that this is the case with the -= also (I don't think it was always).  When you are specifying an include set then the * before the equals is very handy.  It means you can still limit based on other selections and if there is no intersection between your selections and your set then nothing is shown.

Steve

[christian77]

That's very useful.

I'll use it.

Thanks Steve.

[#9 · Accepted solution]

Hi Venu

try this

=if(Match([Employee Name],'Ram','Vidya','Gopal',),sum(Salary))---this is better to use than set analysis because

we can do this by single if statement so performance is good.

Sum({<Employee*={'Vidya','Gopal','Bhavin')>}Salary)----

Both of above can be written in expression.

I hope it helps you.

regards

Mahesh T