topic Re: Set Analysis in QlikView

Set Analysis

Thu, 27 Nov 2014 11:07:21 GMT

Hi,

If I wanted to limit a calculation to certain dimension but still let the expression be effected by selection within those categories, how can I do that.

For example, If I want a chart to take the salary sum of only IT and consultants department, my set analysis would be like

sum({<Department = {'Consultants','IT'}>} salary)

It gives me salaries sum of only these two departments

However, If I would like this chart to be still selectable within these two departments, how can I do that. If from the listbox, I select either IT or consultants, it should show me the data only for that department. If no selection is made or any other department is selected, then show sum of both

Arif

Re: Set Analysis

Thu, 27 Nov 2014 11:22:51 GMT

Try using $ sign in the above example.

$ = current selection.

Regards

Pavan.

Re: Set Analysis

morganaaron — Thu, 27 Nov 2014 11:25:58 GMT

Hi Arif,

Try:

if(Match(GetFieldSelections(Department),'IT','Consultants'),

Sum(Salary),

Sum({<Department={'IT','Consultants'}>}Salary))

edit: removed > 0 as realised from anbu's post this isn't needed!

Re: Set Analysis

anbu1984 — Thu, 27 Nov 2014 11:28:35 GMT

If(Match(GetFieldSelections(Department),'Consultants','IT'),sum({<Department = {'$(=GetFieldSelections(Department))'}>} Salary), sum({<Department = {'Consultants','IT'}>} salary))

Re: Set Analysis

ashwanin — Thu, 27 Nov 2014 11:51:01 GMT

You can also use IF function

=IF(Dept='IT' OR Dept='Consultant',SUM(Salary))

Re: Set Analysis

Fri, 28 Nov 2014 08:55:17 GMT

Your solution is te separation of you two set analysis: sum({<Department = {'Consultants'}>} salary) + sum({<Department = { 'IT'}>} salary)

Re: Set Analysis

rubenmarin — Fri, 28 Nov 2014 09:14:14 GMT

Hi, you can use an operator to filter intersections:

sum({<Department *= {'Consultants','IT'}>} salary)