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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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

Labels (1)
12 Replies
Anil_Babu_Samineni
MVP
MVP

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
MVP
MVP

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