Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
KC3
Creator
Creator

Not getting total

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)

KC3_0-1673597835911.png

 

Thanks in Advance

Khushboo

 

6 Replies
JHuis
Creator III
Creator III

is the field: 'date' in your datamodel? 

KC3
Creator
Creator
Author

Yes Date is there in my data set.

PFB SS for script

KC3_0-1673599042158.png

 

JHuis
Creator III
Creator III

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

vinieme12
Champion III
Champion III

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

 

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
menta
Partner - Creator II
Partner - Creator II

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

KC3
Creator
Creator
Author

@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)

KC3_0-1673610819666.png

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