Fetching data from two seperate fields

[#1]

Hi,

I have 2 tables WarrantyClaimMaster and TReportMaster. WarrantyClaimMaster has a field TractorSrNo which is aliased as TrSrNo and TReportMaster has a field TractorSrNo. Now i want to display count of TractorSrNo from table TReportMaster in my first expression and how many of those count, matches with TrSrNo of WarrantyClaimMaster table.

The problem here is , my first expression should vary based on the calender, but the second expression should give all the matching count from TrSrNo irrespective of year and month.

Also WarrantyClaimMaster table and TReportMaster table are concatenated to make common date field. Hence TractorSrNo and TrSrNo in the same table after reloading.

Thanks in advance

Sandhya Gowda

[alkesh_sharma]

Expression1

Count(TractorSrNo)

Expression2

Count({<Year = , Month = >}TrSrNo)

Hope this helps

[simondachstr]

1. count(distinct TractorSrNo)

2. count({1<TractorSrNo = P({$<Year=,Month=>})>} TractorSrNo

[#4]

HI Alkesh,

Thanks for your quick reply. In expression 2, i want the matching count of TractorSrNo and TrSrNo. i.e, say there are 100 count of TractorSrNo for month of June, then what is the matching count of TrSrNo(common data between TractorSrNo and TrSrNo) irrespective of year,quarter,month.

[#5]

Hi Sandhya,

it would be good if you can knock up an example app, would make this easier to solve

[#6]

Hi Joe,

I have attached example app to my post. Please look into it and provide solution.

Thanks

Sandhya Gowda

[#7]

HI,

Can someone help me close this issue.

Thanks

Sandhya Gowda

[tresesco]

Your sample qvw seems to be blank. Re-upload with a small set of data and try to explain expected output against at least two different selections with logic explanation.