Expression for kpi while dealing with 2 different tables having same field names

[Vikranth]

How to deal with 2 tables having same field names but different content in it. 

Example:

1st table has field name as status - it contain data as migrated, rejected

2nd table has same field name status- it contain data as queued.

How we can write the expression for data which contains only queued in kpi chart?

[rwunderlich]

=Count({<Status={'queued}>} Status)

-Rob

[Qrishna]

Hi - Rename the other Field to 'status_Whatever'.Make sure you dont have two fields with same names in two table except the key field. else you have synthetic keys and then use expression suggested by Rob in your KPI, if that is the solution you looking for.

Eg:

Tab1:

load Status

from xyz.qvd

Tab2:

load Status as Status_Whatevr

from abc.qvd