Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
is the field: 'date' in your datamodel?
Yes Date is there in my data set.
PFB SS for script
Are you making a selection on the field 'Date'?
as below, returns date for selectedDate/max Date -1
=Sum({<Date={"$(=Date(Max(Date)-1))"}>} Quantity)
What is your dimension for column? May be in conflict with Expression
@Vineeth Pujari - Not getting the answer after applying your formula.
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