Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi Christian
That is very interesting... but how does the second one exclude A? HAve you mistyped it, or am I misunderstanding something?
Thanks
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
That's right I mistook.
I've corrected it.
Oh, I see Thanks
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
That's very useful.
I'll use it.
Thanks Steve.
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