Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Fetching data from two seperate fields

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

7 Replies
alkesh_sharma
Contributor III

Re: Fetching data from two seperate fields

Expression1

Count(TractorSrNo)

Expression2

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

Hope this helps

Luminary
Luminary

Re: Fetching data from two seperate fields

1. count(distinct TractorSrNo)

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

Not applicable

Re: Fetching data from two seperate fields

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.

Not applicable

Re: Fetching data from two seperate fields

Hi Sandhya,

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

Not applicable

Re: Fetching data from two seperate fields


Hi Joe,

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

Thanks

Sandhya Gowda

Not applicable

Re: Fetching data from two seperate fields

HI,

Can someone help me close this issue.

Thanks

Sandhya Gowda

MVP
MVP

Re: Fetching data from two seperate fields

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.