Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Are you getting the output you showed or is this something you want to get?
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)
Would you be able to post a QlikView sample to check this out?
Try with this...
Count({<[month] =, [sales] = {"=[sales] <> 0"}>} Distinct [date])