Not getting total

[KC3]

Hi Qlikians,

Implemented 1 dashboard for data for below measures are there.

1. Total Quantity (=sum(Quantity)) getting correct answer

2. Total Quantity for yesterday sale but I am not getting the answer 

Please help me to get the answer. I applied the below formula.

Sum({<Date={'$(=Date(Today()-1))'}>} Quantity)

Thanks in Advance

Khushboo

[JHuis]

is the field: 'date' in your datamodel? 

[KC3]

Yes Date is there in my data set.

PFB SS for script

[JHuis]

Are you making a selection on the field 'Date'? 

[vinieme12]

as below, returns date for selectedDate/max Date -1

=Sum({<Date={"$(=Date(Max(Date)-1))"}>} Quantity)

[menta]

What is your dimension for column? May be in conflict with Expression

[KC3]

@Vineeth Pujari - Not getting the answer after applying your formula.

@menta

PFB SS for the same.

As i am creating this dashboard for only my new launched products, I applied  the formula for getting New Launch data Aggr(Only({$<[Launch]={'New Launch'}>} [Launch]),[Launch],Sku)

Note- Earlier i was getting the data from with the formula of Sum({<Date={"$(=Date(Today()-01))"}>} Quantity) till Dec'22 , is there any chance as the calendar year has been changed that's why the data is not coming because earlier i was not getting the data from 1st to 10th day of every month.

Thanks

KC