REG-VALUE MIS MATCHING

Tue, 12 May 2015 10:00:27 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 and we have difference only we have given CBU AND BU THESE ARE THE BRANDS

Re: REG-VALUE MIS MATCHING

jagan — Tue, 12 May 2015 10:09:44 GMT

Hi,

Check there is any sheet triggers which are making any selections?

Is Current Selection box values are matching in both the Sheets?

If the expressions and dimensions are same then both the charts should match.

Regards,

Jagan.

Re: REG-VALUE MIS MATCHING

Tue, 12 May 2015 10:41:42 GMT

IN THE SHEET PROPERTIES------->Triggers----> WE HAVE ONE TAB REPORT object id AND ANOTHER WE DONT HAVE

Re: REG-VALUE MIS MATCHING

jagan — Thu, 14 May 2015 04:06:32 GMT

Hi,

If you attach the file or screenshot then it will be easier to give solution.

Regards,

Jagan.

topic REG-VALUE MIS MATCHING in QlikView

REG-VALUE MIS MATCHING

Re: REG-VALUE MIS MATCHING

Re: REG-VALUE MIS MATCHING

Re: REG-VALUE MIS MATCHING