topic Re: Getting all possible for a dimension (Set Analysis) in QlikView

Getting all possible for a dimension (Set Analysis)

zagzebski — Sun, 17 Sep 2017 22:47:20 GMT

I need set analysis where if "Hammer" is selected from the below data it will add all Salary and Revenue for that specific Region (which is "East") because Hammer belongs to that Region.

Thanks,

Re: Getting all possible for a dimension (Set Analysis)

vishsaggi — Mon, 18 Sep 2017 01:12:42 GMT

Try this?

LOAD * Inline [

Region, Department, Salary, Revenue

EAST, Nails, 4000, 50000

EAST, Hammer, 5000,

WEST, Screws, 6000, 60000

WEST, Saw, 7000, 70000

];

Using straight table:

Add no dimensions

Add Expressions like:

Salary

= IF(GetSelectedCount(Department) > 0, Aggr(Sum(Salary), Department), Sum(Total Salary))

= IF(GetSelectedCount(Department) > 0 AND Sum(Total Revenue)= 0 , Aggr(Sum({<Department=>} Revenue), Region), Aggr(Sum(TOTAL Revenue), Department))

Re: Getting all possible for a dimension (Set Analysis)

antoniotiman — Mon, 18 Sep 2017 04:59:59 GMT

Hi Steve,

try

Sum({<Region=P(),Department>} Revenue)

Regards,

Antonio

Re: Getting all possible for a dimension (Set Analysis)

zagzebski — Mon, 18 Sep 2017 11:55:03 GMT

Thanks. Worked!