topic Re: Fetching data from two seperate fields in QlikView

Fetching data from two seperate fields

Wed, 03 Dec 2014 11:43:21 GMT

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

Re: Fetching data from two seperate fields

alkesh_sharma — Wed, 03 Dec 2014 11:51:28 GMT

Expression1

Count(TractorSrNo)

Expression2

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

Hope this helps

Re: Fetching data from two seperate fields

simondachstr — Wed, 03 Dec 2014 12:00:09 GMT

1. count(distinct TractorSrNo)

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

Re: Fetching data from two seperate fields

Wed, 03 Dec 2014 12:00:51 GMT

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.

Re: Fetching data from two seperate fields

Wed, 03 Dec 2014 12:10:39 GMT

Hi Sandhya,

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

Re: Fetching data from two seperate fields

Wed, 03 Dec 2014 13:37:49 GMT

Hi Joe,

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

Thanks

Sandhya Gowda

Re: Fetching data from two seperate fields

Mon, 08 Dec 2014 05:39:07 GMT

HI,

Can someone help me close this issue.

Thanks

Sandhya Gowda

Re: Fetching data from two seperate fields

tresB — Mon, 08 Dec 2014 05:44:54 GMT

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.