Pls, help me with set analysis

[#1]

Hello

I need to show data in the table, excluding one of the specified conditions. I have such data:

Table:

LOAD * INLINE [

    Person, STUFF_ID

    Anna, 11

    Sam, 23

    Joy, 34

    Joy, 11

    Bella, 11

];

The user has set a condition: Person = Anna. I need to show in the table all of the people who have STUFF_ID = 11.

Help It's easy, but I can't remeber how to do it with SA ;(

[ashfaq_haseeb]

Hi,

Dimension

Person

Expression

=count({<STUFF_ID={11}>} Person)

Regards

ASHFAQ

[its_anandrjs]

In Script side do with

Table:

LOAD * INLINE [

    Person, STUFF_ID

    Anna, 11

    Sam, 23

    Joy, 34

    Joy, 11

    Bella, 11

];

Query:

Load

Person,

STUFF_ID as STUFF_ID_11

Resident Table

Where STUFF_ID = 11;

Or on the Front end do with

Dimension:- If(STUFF_ID = 11 , Person)

Expression:- Count(STUFF_ID)

Note:- And select Suppress when value is null.

[#4]

thanks

but you can make a formula that does not specify exactly "11", and taking into account the user-selected STUFF_ID?

I mean such current selections:

Person=Anna

Stuff_ID = 'any value, I don't know value when I write SA formula'

I need to show in ANOTHER table persons who have stuff_id =11 also, but I can't remove condition Person=Anna.

[swuehl · Accepted solution]

To ignore a user selection, e.g. in field STUFF_ID, use something like

=Count({<STUFF_ID = >} Person)

or if you want to remove selection in Person:

=Count({<Person = >} Person)

or combine with a selection in STUFF_ID:

=Count({<Person= , STUFF_ID={11}>}Person)

[maxgro]

count({$ <Person=,STUFF_ID={$(=concat(distinct STUFF_ID, ','))}>} Person)