Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a button with an action to set field theField1.
Field1 shall be set to value "=DATE(MAX(Sale_Date),'DD.MM.YYYY')".
The button works, however, in selection box i get specific value "03.02.2015", but I want to have the expression in the selection box.
So If i change another field in the app, Field1 shall be set to the max(sale_date) according to the new filter selection.
Thx - Marcel
Hi
I used QlikView CTRL -> QQ to create the example.
I want to use the "set field to expression by button action" as a feature that works in a general context. Not dependant on the data model. Thus, I like to have this working also with TransIDTest in a seperate table.
Marcel
I think the separate table isn't thes problem it's rather the key and the table should look like:
TransactionsExtra:
Load
TransID,
TransID AS TransIDTest
Resident Transactions;
- Marcus
I am not sure what the use case of your requested functionality should be.
But it seems that the search expression in the selection box is not re-evaluated on every change in your selection state.
Maybe you can work around this with triggers, as already suggested above by Sunny.
See attached for a demo.
Hi
thank you. I agree, the re-evaluation does not seem to work, and thus the expression in the selection status.
I am now using Set Analysis expressions to set the max in my formulas directly. I do not like this as performace is worse than using a filter in data model.
Thank you again for your help!
Marcel