How to select all days less than today in default selection

[ferha_jafri]

Hello Everyone,

I need help in the application , i m using qlikview 9 in which when the application opens it should select all days less than today and i am not able to write an expression for that as when i am typing <=day(today()) it is not selecting all days less than 17. Please help it is very urgent.

Thanks in advance

Ferha Jafri

[datanibbler]

Hi Ferha,

you're on the right track, you need an advanced search expression which is, in fact, quite easy:

=> Right-click on the listbox

=> Select "advanced search"

=> type >>> = [date_field] < TODAY() <<<

[tresesco]

You have to use a trigger which would require concatenating dates in proper format ,like - (date1|date2|...). Now this date range would be created using an expression. It would be a faster answer if you could share a sample app.

[datanibbler]

Hi,

okay, I refine my answer: It won't work quite like that via a trigger, but there's no need to go to the length of concatenating:

=> in the trigger_dialog, enter

    - the fieldname as [your date_field]

    - the search_term as >>> = '= %Datum < TODAY()' <<<

=> That way, your advanced search_expression will be passed to the trigger. Voila.

[jagannalla · Accepted solution]

Hi,

Please check attached file.

Settings->Document Properties -> Triggers tab -> OnOpen -> Add Actions -> Add -> Selection (Select in field)

Here give your date column  in  Field box and exp ='<' & Today() in search box.

Make sure your date field should match with your system date format.

Thanks,

Jagan

[ferha_jafri]

Thank you so much Jagan for the correct ans , it is a great help...