topic Re: Bar chart selecting particular fields in QlikView

Bar chart selecting particular fields

Tue, 03 Dec 2013 16:20:41 GMT

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

Re: Bar chart selecting particular fields

jerem1234 — Tue, 03 Dec 2013 17:13:12 GMT

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).

2. You can make use of dimension limits:

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!

Re: Bar chart selecting particular fields

angelaecheverri — Tue, 03 Dec 2013 18:34:14 GMT

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....