Qlik Community

Qlik Healthcare User Group

A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights.

Highlighted
Pdmotta
New Contributor

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.

Tags (1)
1 Solution

Accepted Solutions
Pdmotta
New Contributor

Re: Set Analysis , excluding a table

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
toddbuss
Contributor

Re: Set Analysis , excluding a table

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
New Contributor

Re: Set Analysis , excluding a table

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
Contributor

Re: Set Analysis , excluding a table

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
New Contributor

Re: Set Analysis , excluding a table

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
New Contributor

Re: Set Analysis , excluding a table

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