Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Louveduval
Creator
Creator

Sum of the day

Hello , 
I try to have the sum of the quantity for one day . 
When I made that for year -1 it's work but not for the current month 

Sum({<

[Filtre CA vente] = {"Oui"},
[Type date]={'BL vente','Facture vente'},
Date = {"<=$(=Date(RangeMin(Max(Date),Today())))"},
AnnéeMois={"$(=MonthName(RangeMin(Today(),Max(Date))))"}
>}[Quantité vente])

It give me the total of the month  and not just for today 

Louveduval_0-1694500973462.png

Can you explain why it doesn' t work ?

Labels (3)
2 Replies
MayilVahanan

Hi

Try like below

Sum({<
[Filtre CA vente] = {"Oui"},[Type date]={'BL vente','Facture vente'},Date = {"$(=Date(Max(Date)))"}>}[Quantité vente])

it will display the latest date .

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Louveduval
Creator
Creator
Author

Hello I sorry 
But  I have date on the futur so it's doesn't work