Count(distinct {<month=,sales={"<>0"}>}date)

[shiva4s89]

When I am calculating sales/day above expression to calculate "Number of operating days stores" is giving the wrong count of the day, Kindly help to resolve this issue.

Regards

Shivananda S

[sunny_talwar]

Are you getting the output you showed or is this something you want to get?

[shiva4s89]

Hi Sunny,

thanks for replying, I am getting output like this.

first row count of operating day for previous year coming as zero for negative sale transactions.

expression use:

Count(DISTINCT{<Date=  {">=$(=Min([Year Ago Dt]))   <=$(=$(vMaxSelAgoDate))"}  ,[Net Sales]={"<>0"}  ,Year=,Week=,Month=>}Date)

[sunny_talwar]

Would you be able to post a QlikView sample to check this out?

[JGMDataAnalysis]

Try with this...

Count({<[month] =, [sales] = {"=[sales] <> 0"}>} Distinct [date])