Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Set Analisys exclusion intersection problem

Hi dear QV Community

I have the following problem, I'm making a pivot table that has the dimensions and field student, I do an exercise in which I calculate the average students see math or Spanish only, discarding those that are subject to time together. Use the following expression,

avg({<Materia = {'Matematicas', 'Español'}> -(< Estudiante = P({<Materia = {'Matematicas'}>}) > * < Estudiante = P({<Materia = {'Español'}>}) >)}   Nota)

although the result is correct, in the field dimension shows me no, do not know why this is happening, I appreciate any help you can give me.

I attached the model "Demostracion_Negocio.qvw"and some pictures, the pivot table are in the Third Sheet Called "Analisis de conjuntos", pivot table called "Diferencia"

Check the result in pivot table problem

PivotTable.png

And Check de Data Table

DataTable.png

1 Solution

Accepted Solutions
Highlighted
Specialist II
Specialist II

Re: Set Analisys exclusion intersection problem

Interesting case!

It has been hard but I got it!!

avg({1<Materia = {'Matematicas'}> * (< Estudiante = E({<Materia = {Matematicas}>})+ E({<Materia = {Español}>}) >) + 1<Materia = {'Español'}> * (< Estudiante = E({<Materia = {Matematicas}>})+ E({<Materia = {Español}>}) >)} Nota)

Regards

View solution in original post

2 Replies
Highlighted
Specialist II
Specialist II

Re: Set Analisys exclusion intersection problem

Interesting case!

It has been hard but I got it!!

avg({1<Materia = {'Matematicas'}> * (< Estudiante = E({<Materia = {Matematicas}>})+ E({<Materia = {Español}>}) >) + 1<Materia = {'Español'}> * (< Estudiante = E({<Materia = {Matematicas}>})+ E({<Materia = {Español}>}) >)} Nota)

Regards

View solution in original post

Highlighted
Not applicable

Re: Set Analisys exclusion intersection problem

Thanks Works Fine !!