Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Bar chart selecting particular fields

i have data employees on x-axis and salaries on y axis.i want some particular emps salarys only example mahesh,kiran,seetha,anil etc only remaining should be groped to others and others info sholud be presented last only on barchart

others field grouping visible like last on bar char can u please let me know how many ways this can be done in qlik view.

let me know where exactly we have to write scripting as well help asap on this to do my application

regards

mahesh

2 Replies
jerem1234
Specialist II
Specialist II

1. You could use a calculated dimension such as:

=if(match(Employees, 'Mahesh', 'Kiran', 'Seetha'), Employees, dual('Others',0))

Then sort based on numeric value ascending and text (the formula may have to change depending on sorting/preference).

OR

2. You can make use of dimension limits:

First.PNG.png

But that would depend how you have your names sorted (might need to use a field to rank them or some kind of expression).

Hope this helps!

angelaecheverri
Creator
Creator

you can do it by selections...

as dimension you can use it

=if(Aggr(Sum(1), Names)>0,

  'Selected: $(=Concat(DISTINCT Names, ', '))',

  'Others: $(=Concat({<Names=E({$})>} DISTINCT Names, ', '))')

as Expresion:

Sum({<Names=>} Value_Salary)

and make a list with Names

so if you select some of them you will see to groups in your chart...

one the selected ones and the other group name it "Others"

Good luck

I hope it will be usefull....