Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to set up an OnActivate trigger to do Select in field.
When I do this using a literal value for the Search String component, this works.
When I do this using a variable that has been loaded, it does not appear to work. The variable represents the 'Prior Month Start Date', and the Field component of the Select in field is set to a date like 'sales_date'.
Any ideas or suggestions?
Thanks
Could you please post some more details on how the field values look like, how the variable looks like and how the search string is defined.
If possible, you can also just post a small sample QVW.
hi,
if ur date format : DD.MM.YYYY
You could possibly have a problem in the search string. It uses decimal comma, but the field has decimal points. You should use the same decimal separator in both places.
or
There was a link between both tables.. u can remove the link and try.
Hi,
Do this script changes
MaxDate:
Load
Date(max(PostingDate),'DD-MM-YYYY') as vMaxDate
From [..\Qvds\Sales.qvd] (qvd);
Go to Sheet -> Trigger -> On Activate Sheet-> Select in Field -> Select Month Field -> Sales_month
Enter =Date(max(vMaxDate),'MMM-YY') in search String automatically the month will be selected.
Hope this will help you.
Vikas
see if this can help -
The variables defined in the load script:
/
LET vPreviousMonthStart = monthstart(today(),-1);
LET vPreviousMonthEnd = monthend(vPreviousMonthStart);
What about a search string
=SALES_D_COSTED=vPreviousMonthStart
Also try
='$(vPreviousMonthStart)'
which should replicate your literal value (you can also check the result of the search expression in a text box first).
I did try this, unsuccessfully.
Thanks
Tried this, no success, sorry.