reg-values not matching

Tue, 12 May 2015 09:55:04 GMT

Hi Team,

we have straight table and the dimension and expression for the two tabs are same ,but the values like sales vs Target are not matching.

we have four tabs and in that the first tab and fourth tab we have sales vs Target and same dimension,but the values are not matching .iam writing the expresion aslo here

first tab

sales:

=if(vCalType='value','SalesV','SalesU')

=if(GetPossibleCount(PackageID)>1 and vCalType='unit',null(),sum({<CBU={"=len(CBU)>0"}>} SalesUnit*if(vCalType='value',if(Year>=2015,[CIM Price],[Actual Price]),1)))

Target:

=if(vCalType='value','TargetV','TargetU')

=if(GetPossibleCount(PackageID)>1 and vCalType='unit',null(),sum({<CBU={"=len(CBU)>0"}>} TargetUnit*if(vCalType='value',if(Year>=2015,[CIM Price],[Actual Price]),1)))

second tab

sales

=if(vCalType='value','SalesV','SalesU')

=if(GetPossibleCount(PackageID)>1 and vCalType='unit',null(),sum({<BU={"=len(BU)>0"}>} SalesUnit*if(vCalType='value',if(Year>=2015,[CIM Price],[Actual Price]),1)))

target

=if(vCalType='value','TargetV','TargetU')

if(GetPossibleCount(PackageID)>1 and vCalType='unit',null(),sum({<BU={"=len(BU)>0"}>} TargetUnit*if(vCalType='value',if(Year>=2015,[CIM Price],[Actual Price]),1)))

can any one help me out from this

Re: reg-values not matching

rubenmarin — Tue, 12 May 2015 10:26:07 GMT

Hi, the only difference I see is the first tab using the fields CBU and the second using BU, you'll need to check the differences between these data, maybe some of the recods have his CBU/BU field as null or with different values.

Re: reg-values not matching

Tue, 12 May 2015 10:35:02 GMT

IN THE FIRST TAB WE HAVE TAKEN AS CBU and in the second tab we have taken as BU

topic reg-values not matching in QlikView

reg-values not matching

Re: reg-values not matching

Re: reg-values not matching