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

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

Mon, 29 Jun 2015 20:00:13 GMT

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.

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

MarcoWedel — Mon, 29 Jun 2015 20:15:42 GMT

=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)

hope this helps

regards

Marco

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

maxgro — Mon, 29 Jun 2015 20:18:12 GMT

maybe with a $

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

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

MarcoWedel — Mon, 29 Jun 2015 20:24:56 GMT

already noticed it was missing, thanks

regards

Marco

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

Tue, 30 Jun 2015 14:02:30 GMT

Thanks Marco. The first solution worked perfectly.