Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
WE ARE LISTENING! New Navigation for Qlik Community, Sept. 26: TELL ME MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
saminouari
Contributor III
Contributor III

Get the last value of a selected month

Hi,

When I select for example the month of january 2019, I want to get only the last value of that month, in the example below, it should show me 31-01-2020 and the value 30.

I tried with Max(VisitDate) but it didn't work.

lastvalue.PNG

Labels (1)
2 Replies
Taoufiq_Zarra

you can use

=Date(Monthend(VisitDate))
Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
saminouari
Contributor III
Contributor III
Author

Your formula didn't work. I used instead 

max(aggr(count({< PDV_ModelName={'Available on EXIT'},PDV_Boolean={1},StoreDisabled={0}>} ProductId&StoreId),StoreId, VisitDate))

It gives me the correct last value of each store if I select for example the month of january 2019, but the total is incorrect.

lastvalue.png