Alternative State Problem

senpradip007 — Fri, 22 Mar 2013 11:49:53 GMT

Hi Experts,

Today I've faced a problem on ALTERNATIVE STATE. I've dimensions viz Region, SaleOffice, SalesGroup, Distributor, Market, RetailerCategory, RetailerClass, SalesMan.

I've used the following expression

Count({[Group1]<Year={$(=Max(Year))},DATE={'>=$(vStartDate)<=$(vEndDate)'},Month=,Quarter=,HalfYearFin=,Day=,[Region]=$::[Region],

[Sales Group]=$::[Sales Group],[Sales Office]=$::[Sales Office],[Customer]=$::[Customer],[Customer Town]=$::[Customer Town]

,SalesManDFSName=$::SalesManDFSName,RouteMKTName=$::RouteMKTName,RetailerName=$::RetailerName

>} SaleValue)

Outcome of the above expression is 16000.

But when I use Count({<Year={$(=Max(Year))},DATE={'>=$(vStartDate)<=$(vEndDate)'},Month=,Quarter=,HalfYearFin=,Day= >} SaleValue) , it results 21000.

Is there any mistake? Please help me to get rid of this problem.

Thanks in advanced.

topic Alternative State Problem in QlikView

Alternative State Problem