# Healthcare User Group

cancel
Showing results for
Did you mean:
Contributor II

## Set Analysis , excluding a table

In a set analysis how to excluded everthing but a table , for example :

I have a INSURED table , I want to apply an set analysis only to this
table ignoring to the others.

I want to count how many insured we have in a period for example but I won´t
to aplly to another column/dimensions.

Apply all filters setted to then table INSURED and not aplly to another.

Thank you.

1 Solution

Accepted Solutions
Contributor II
Author

The solution if helps someone

```Count({
<
[Data Inclusão]={"<=\$(vDataRefMax)"},
[Data CTRL Bloq Usu]={">=\$(vDataRefMax)"},
[\$(=Concat({1 - <\$Table={'Beneficiarios'}>} Distinct \$Field, ']=,[') & ']=')
>
} Distinct [Nome Beneficiário]&[Data Nascimento])```

the line

[\$(=Concat({1 - <\$Table={'Beneficiarios'}>} Distinct \$Field, ']=,[') & ']=')

inserts a

[feild]=,

to every field of all coluns of all tables but table Beneficiarios

5 Replies
Creator

I think you will need to use set-analysis on ALL of your tables  except INSURED to prevent selections from affecting them.

to prevent selections from influencing tables other than INSURED, use the identifier of 1.

ex:  Sum({1} [Sales])

I'm a noob, so please forgive me if this isn't right.

Contributor II
Author

I believe it´s not that .

The real problem , in an Helth Insurance I have to calculate the "per capita" of the Total Cost by life,  no matter if he/she has cost in period or not.

But , the filter applies to all column is INSURED table , for example , GENDER , AGE etc , but not applies to consultations or examinations (the total portfolio of insured it´s not affted by it).

I hope it was clear.

Creator

Sorry, I can't figure out what you're asking for.  Perhaps one of the gurus here can help if you provide a sample application, screenshots, or other description of what's in your application.    If you upload anything, be sure to remove any metadata that can be connected with PHI.

Contributor II
Author

I´ve tried this

```Count({\${1 - <\$Table={'Beneficiarios'}>}
<
[Ano Referência]=,
[Mês Referência]=,
[Nº Ano Mês Referência]=,
[Data Inclusão]={"<=\$(vDataRefMax)"},
[Data CTRL Bloq Usu]={">=\$(vDataRefMax)"}
>
} Distinct [Nome Beneficiário]&[Data Nascimento])```

translate from Portuguesse

Beneficiarios - Insured

[Nome Beneficiário]&[Data Nascimento] Name%date of birth

but does not work

Contributor II
Author

The solution if helps someone

```Count({
<
[Data Inclusão]={"<=\$(vDataRefMax)"},
[Data CTRL Bloq Usu]={">=\$(vDataRefMax)"},
[\$(=Concat({1 - <\$Table={'Beneficiarios'}>} Distinct \$Field, ']=,[') & ']=')
>
} Distinct [Nome Beneficiário]&[Data Nascimento])```

the line

[\$(=Concat({1 - <\$Table={'Beneficiarios'}>} Distinct \$Field, ']=,[') & ']=')

inserts a

[feild]=,

to every field of all coluns of all tables but table Beneficiarios