Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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.
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.
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.
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
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