Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
=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
=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
maybe with a $
only({<Baseline_Start={"$(=Today())"}>} Task_Name)
already noticed it was missing, thanks
regards
Marco
Thanks Marco. The first solution worked perfectly.