Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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() <<<
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.
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.
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
Thank you so much Jagan for the correct ans , it is a great help...