Set analysis on a "fields = values of list box"

[#1]

Hi,

We've  got a problem on set analysis. We want to filter on values selected in the listbox

example :

=sum(

               {1<[Product_Family] = {"List of selected object"}

  Sales

The user can select on or multiple values

Thx a lot

[bbi_mba_76 · Accepted solution]

Hi,

maybe with

=sum({1<[Product_Family]=p([Product_Family])>}Sales)

[#3]

I have perhaps sth for you:

To get everything, except one or two fields, see the excellent post by Smakovskiy :

  http://community.qlik.com/docs/DOC-1334

If I want everything (All values) except for 2 dimensions: PRODCUT and MONTH, I would write: 

=sum({$<[$(=Concat({1<$Field-={'PRODUCT','MONTH'}>}distinct $Field,']=,[' )&']=')>} VALUE)

Fabrice

[Clever_Anjos]

Does your listbox attached to Product_Family field?

[#5]

Works fine thx !