topic Re: Set Analysis Subset Selections in QlikView

Set Analysis Subset Selections

Tue, 03 Nov 2015 11:00:01 GMT

Hi,

Is it possible to restrict the values available in a chart via set analysis, but then allow the result to still be filtered on by the user?

e.g.

Department:

Finance

Supplies

Corporate

Expression:

=sum({<Department = {'Finance','Supplies'}>}cost)

This expression would sum the cost for Finance and Supplies, excluding Corporate. If I then wanted to filter down to Finance by selecting it in a list box, it would not alter the sum.

Is there a way to make that happen?

Thanks in advance.

Tom

Re: Set Analysis Subset Selections

sunny_talwar — Tue, 03 Nov 2015 11:27:01 GMT

This:

=Sum({<Department *= {'Finance','Supplies'}>}cost) // if you want to filter down to finance on selection

Your current expression should not alter the sum actually. Do you want it to just show Finance when you select Finance or still show both?

Re: Set Analysis Subset Selections

Tue, 03 Nov 2015 11:44:03 GMT

Hi Sunny,

Yes, I just wanted it to show finance if finance is selected.

The new expression gets highlighted with a syntax error, but it works as I want it to.

Thanks

Re: Set Analysis Subset Selections

coloful_architect — Thu, 20 Jun 2024 18:59:54 GMT

I had same issue..but why sometimes the set expression seems to allow me to delve into the subset of filter , in this case "France" , but sometime it does not... I thought that $ sign always allows to select other dimensions...only 1 is to lock.