Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
marthajesicap
Contributor
Contributor

Date Filter

Hi, 

so, i have a data with date. i want to show the date i filtered in text and image chart.

For example, i have a data from May 1st until May 31st.

I filtered May 22nd and i want to tell people that data that i filtered is May 22nd.

i currently write it manually in text and image chart because i dont know how to script it.

i attach a screenshot of the example.

 

Thanks for the help

1 Solution

Accepted Solutions
NitinK7
Specialist
Specialist

try below expression.

GetFieldSelections(date)

View solution in original post

6 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

HI,

You can use the below expression in the Text object.

 

Date(Max(Date),'MMM, DD YYYY')

 

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
marthajesicap
Contributor
Contributor
Author

thank you for replying.

i have try the expression, but it is only show the latest date not the currently date i choose in the filter.

as the picture i attached, the date in the text is the date that i choose from date filter.

 

Thank you.

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

In the expression I gave, change the "Date" field to the date field name in which you make the selection and it will work.

 

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
NitinK7
Specialist
Specialist

try below expression.

GetFieldSelections(date)

marthajesicap
Contributor
Contributor
Author

it works. Thank you !

marthajesicap
Contributor
Contributor
Author

thank you for replying 🙂