Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
Not applicable

Display Text in Text Object depending on today() function?

I have an excel table loaded into qlikview with two columns, one contain a task description and the other dates. What expression would I need to display the task description in the text object if the date listed in the table matches the current date?

The closest if have gotten to this working is with this expression:

=only({<Baseline_Start={'MM/DD/YYYY')}> }Task_Name)

but I would like for it to use the today() function for the date instead of manually entering the date string so it will update on its own.

Any suggestions? Thanks.

1 Solution

Accepted Solutions

Re: Display Text in Text Object depending on today() function?

=only({<Baseline_Start={"$(=Today())"}>} Task_Name)


or maybe you have to adjust the format to your settings like


=only({<Baseline_Start={"$(=Date(Today(),'MM/DD/YYYY'))"}>} Task_Name)


QlikCommunity_Thread_170479_Pic1.JPG


hope this helps


regards


Marco

View solution in original post

4 Replies

Re: Display Text in Text Object depending on today() function?

=only({<Baseline_Start={"$(=Today())"}>} Task_Name)


or maybe you have to adjust the format to your settings like


=only({<Baseline_Start={"$(=Date(Today(),'MM/DD/YYYY'))"}>} Task_Name)


QlikCommunity_Thread_170479_Pic1.JPG


hope this helps


regards


Marco

View solution in original post

MVP
MVP

Re: Display Text in Text Object depending on today() function?

maybe with a $

only({<Baseline_Start={"$(=Today())"}>} Task_Name)

Re: Display Text in Text Object depending on today() function?

already noticed it was missing, thanks

regards

Marco

Not applicable

Re: Display Text in Text Object depending on today() function?

Thanks Marco.  The first solution worked perfectly.