topic Set Analysis - Comparing Two Fields in QlikView

Set Analysis - Comparing Two Fields

shane_spencer — Wed, 29 Nov 2017 16:29:11 GMT

I've got a Document with two tables. These both essentially compare Original Tax (AMT_TAX_TAXREP_R_src_1) against Final Tax (AMT_TAX_TAXREP_R_clo_1) - two fields in different but linked tables.

What I want to do is only show the rows where the Change TAX (i.e. the difference between these two fields) is Zero.

i.e. Those rows highlighted in Yellow:

I think the answer is in set analysis but I'm really struggling. Can anyone help?

Re: Set Analysis - Comparing Two Fields

YoussefBelloum — Wed, 29 Nov 2017 16:48:44 GMT

Hi,

to display only rows whch is different from 0 on the change tax column, you can do this on every column of the table:

if([Original TAX]-[Final TAX]<>0, round([Original TAX]-[Final TAX],0.01))

but here even with this you will not be able to display the lines you want because of the round function.

Re: Set Analysis - Comparing Two Fields

shane_spencer — Thu, 30 Nov 2017 08:27:19 GMT

Thanks! That works great, though it seems almost counter-intuitive to use the results of the Expressions like that to decide what to show in the expressions.