Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Pdmotta
Contributor III
Contributor III

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
Pdmotta
Contributor III
Contributor III
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

View solution in original post

5 Replies
toddbuss
Creator
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.

Pdmotta
Contributor III
Contributor III
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.

 

toddbuss
Creator
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.

 

Pdmotta
Contributor III
Contributor III
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

 

Pdmotta
Contributor III
Contributor III
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