Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
josephinetedesc
Creator III
Creator III

Help with a date calculation

Hi all

I would like some help with this please:

I am in Chart properties - It is a line chart - works beautifully when I have:the dimension

=date(AppointmentDate, 'www dd/MM/yyyy')

But

as part of a dashboard I would like to amek the same chart just show a week of data, starting 7 days before today.

The expression below in the Enable conditional box does not work.

date(AppointmentDate) >= date(today()-3)

Thank you

Jo Tedesco

12 Replies
Anil_Babu_Samineni

NP, Let it be. But, future

1) Your response got it as mark correct

2) You have to UN-Mark from correct answer first(Ref image attaached) - It's under your correct response

Capture.PNG

3) Then, Mark it as proper flag ..

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
josephinetedesc
Creator III
Creator III
Author

Can I do this? Because I marked it as correct – I don’t think I can change it … I wanted to mark your answer as correct – instead I did it to my reply!

Jo

Anil_Babu_Samineni

You can, Because you are in your control (Credentials is yours)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful