topic Re: Only Display Items That Do Not Match in QlikView

Only Display Items That Do Not Match

Anonymous — Wed, 01 Jul 2015 15:25:01 GMT

I am trying to populate a table with ONLY items where certain values do not match one another.

For example, in the calculation condition of my table box I currently have written:

ALLOCATION_CODE1 <> HOME_CODE1 or ALLOCATION_CODE2 <>HOME_CODE2 or ALLOCATION_CODE3 <> HOME_CODE3

So in theory, I am only trying to display items where the allocation code 1, 2 or 3 does NOT match the home code 1, 2 or 3. The syntax above is not working and I am still getting items where the codes match.

Any help would be appreciated.

Re: Only Display Items That Do Not Match

sunny_talwar — Wed, 01 Jul 2015 15:28:02 GMT

Calculation condition of your table box object is not the best place to do it. The reason is because the calculation condition will either be true or false for the whole table. If its true, it will display everything, if false will not display anything. You might have to switch to a straight table for this and may be use a expression for your condition.

Best,

Sunny

Re: Only Display Items That Do Not Match

Anonymous — Wed, 08 Jul 2015 14:10:06 GMT

Still struggling with this. I have decided to try and do the match comparison in the data model script instead of in the application but I am still coming up short

Basically, I have the following table structure:

Table 1

Key

Employee

Report

Field 1

Field 2

Field 3

HOMECODE1

HOMECODE2

HOMECODE3

HOMECODE4

Table 2

Key

ALLOCATIONCODE1

ALLOCATIONCODE2

ALLOCATIONCODE3

ALLOCATIONCODE4

Are there any recommendations of how I can either combine these tables to easily do the comparison? Again, I am trying to figure out a way to display ONLY fields where the HOMECODEs DO NOT match ALLOCATIONCODEs

Re: Only Display Items That Do Not Match

antoniotiman — Wed, 08 Jul 2015 14:40:27 GMT

Hi David,

Attachment 1 Load and Join and add Flag in Script

Attachment 2 Load Tables and Calculated Dimension in Chart

Regards,

Antonio

Re: Only Display Items That Do Not Match

Anonymous — Thu, 09 Jul 2015 15:11:50 GMT

This worked Antonio. You are the man. Thank you.