topic Re: Active and Cancelled in QlikView

Active and Cancelled

ravindraa — Thu, 15 May 2014 03:05:48 GMT

Hi all,

we have two databases 1 have contracts based on status wise (ACTIVE,CANCELLED,ENROLLED,NA) as well as 2 database also like that but both data base doesn't have same contracts ex:one data base have 69 contracts 2 data base have 35 contracts we need to differentiate that i mean the value is 35 . here we need to show 35 all contracts in one particular table.

so far i did to find up-to difference value i am struck to find the particular 35 contracts, if any one knows please give me suggesion.

i have attached the doc. please find those. i have

it is very urgent if any one knows please give me any suggestion.

Re: Active and Cancelled

Anonymous — Thu, 15 May 2014 03:54:29 GMT

PFA

In this way you can find what contracts are available in Talisma and what are in SAP file and what are available in both.

Moreover if it is not your req, then please ellaborate more.

Regards

Nitin

Re: Active and Cancelled

ravindraa — Thu, 15 May 2014 05:41:59 GMT

Hi Nitin Gupta,

Thanks for reply we want difference value list i mean as far the my dash board

talisma have 69

sap have 34

difference is 35

if we select 35 all 35 contracts should be display or which is different contract and those contract maintain separate table.

please give me any suggestion.

Re: Active and Cancelled

Anonymous — Thu, 15 May 2014 05:47:57 GMT

you ca use not exists function to extract the difference data and then you can easily store them into new table.

use where not exists (contracts)

Re: Active and Cancelled

ravindraa — Thu, 15 May 2014 07:46:38 GMT

Hi Nitin Gupta,

using that we are not getting value, if we use that condition we are getting '0' value .

please give me any suggestion.

Re: Re: Active and Cancelled

Thu, 15 May 2014 13:45:36 GMT

Hi PFA as per my understanding.