topic Re: Compare two fields in QlikView

Compare two fields

Fri, 03 Jul 2015 17:14:04 GMT

Hello,

I have 2 fields

ID_ORDEN_IND and
ID_ORDEN_TEM

Both contain a sequence of numbers , for example : 445566

I would like to know how many ID are repeated each other ... something like the following:

If ID_ORDEN_IND = ID_ORDEN_TEM , COUNT ( ESTADOID )

But not how to translate it into an expression paragraph get the calculation.

I hope you can help me, thanks in advance.

Re: Compare two fields

swuehl — Fri, 03 Jul 2015 17:27:12 GMT

Where does field ESTADOID come from?

You can do the analysis like this:

LOAD ID_ORDEN_IND as TestID,

'IND' as Source

FROM YourIndIDSource;

LOAD ID_ORDEN_TEM as TestID,

'TEM' as Source

FROM YourTemIDSource;

Now you can create a chart with TestID as dimension and

=Count(Distinct Source)

as expression. Sort by expression descending shows all duplicate IDs on top.

You create an overall count like

=Count({<TestID = {"=Count(Distinct Source)=2"}>} Distinct TestID)

Re: Compare two fields

Anonymous — Fri, 03 Jul 2015 17:32:47 GMT

Hi,

I dont know wht is ESTAOID but maybe this can help you:

sum(if(ID_ORDEN_IND=ID_ORDEN_TEM,1,0))

Regards.

Re: Compare two fields

gilbertomedeiro — Fri, 03 Jul 2015 20:14:25 GMT

Hello Guerreiro,

It is your expression, right?

If ID_ORDEN_IND = ID_ORDEN_TEM , COUNT ( ESTADOID )

So, I try rewrite it:

COUNT(DISTINCT IF(ID_ORDEN_IND = ID_ORDEN_TEM, ESTADOID))

By the way, in my opinion, Giuseppe is right too.

Regards.