topic Re: Intersection Set Analisis in QlikView

Intersection Set Analisis

Tue, 15 Jan 2013 14:36:00 GMT

hi!,

I have a problem with set analisis,

I need to find the intersection of two field (type text) of two diferent tables, i tried with {< INTERVALO1 *= INTERVALO2 >}

Please Help me!,

Thanks

Re: Intersection Set Analisis

swuehl — Tue, 15 Jan 2013 14:50:25 GMT

This probably only works when you have an active selection in INTERVAL02, try

{< INTERVALO1 *= p(INTERVALO2) >}

instead.

If possible, post some sample lines of data (e.g. in a sample qvw file) togehter with your requested outcome.

Regards,

Stefan

Re: Intersection Set Analisis

Tue, 15 Jan 2013 15:07:38 GMT

The line is:

=SUM({< TPOXHORA *= HORA_MIN_FOR, [SERVICIO FORECASTEADO]={"HFC TECNICO","HFC COMERCIAL"} >} [HH REQ. ACD FORECAST])

but is bad.

The data is,

HORA_MIN_FOR TPOXHORA

00:00 00:00

00:30 01:00

01:00 02:00

01:30 03:00

02:00 04:00

02:30 05:00

03:00 06:00

03:30 07:00

04:00 08:00

04:30 09:00

Two fields are type text.

Re: Intersection Set Analisis

swuehl — Tue, 15 Jan 2013 15:46:58 GMT

So, I assume you have tried using the p() function. Any success?

Re: Intersection Set Analisis

Tue, 15 Jan 2013 17:35:44 GMT

No, i tried with p() but the result is 0

Re: Intersection Set Analisis

swuehl — Tue, 15 Jan 2013 18:05:19 GMT

Seems to work for me, please check attached sample (or adapt if it deviates from your model).

Re: Intersection Set Analisis

Tue, 15 Jan 2013 19:30:51 GMT

swuehl,

I tried with the sample qvw but for my exercise not result.

attached my qvw with data.

thanks!

Re: Intersection Set Analisis

swuehl — Tue, 15 Jan 2013 19:42:40 GMT

Ok, your tables are linked (I assumed non-linked fields) and there seems to be no possible selection that results in HORA_MIN_FOR and TPOXHORA having same values, so an itersection returns no records.

If you tell us what you want to achieve in general, maybe we can come up with a different solution.

Re: Intersection Set Analisis

Tue, 15 Jan 2013 19:59:05 GMT

I want SUM the field [HH REQ. ACD FORECAST] and show in a table the result but one column use HORA_MIN= 08:30 and the second column use HORA_MIN = 08:00 for that i think intersection between TPOXHORA and HORA_MIN_FOR so the column with HORA_MIN is ok,

Re: Intersection Set Analisis

swuehl — Tue, 15 Jan 2013 20:46:30 GMT

Sorry, I don't get what you mean.

I see that your definition in the two tables for HORA_MIN_FOR and TPOXHORA seems to be different (shifted about a constant value) when looking at the same HORA_MIN, but I would suggest to fix this in the data model, not in chart expressions.