topic Re: Use button action to set Field value to an expression in QlikView

Use button action to set Field value to an expression

hugmarcel — Tue, 26 Jan 2016 15:49:27 GMT

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

Re: Use button action to set Field value to an expression

sunny_talwar — Tue, 26 Jan 2016 15:52:06 GMT

May be instead of using button, use 'On Selection' trigger. Every time you make a selection, the trigger will set a new Max(Sale_Date)

Re: Use button action to set Field value to an expression

hugmarcel — Tue, 26 Jan 2016 15:58:28 GMT

Thank you. Unfortunately, it does not work for me, as making selections to a specific field shall not trigger actions in all situations.

Re: Use button action to set Field value to an expression

settu_periasamy — Tue, 26 Jan 2016 16:19:11 GMT

As already suggested by sunindia‌, in 'On selection' trigger, try to do the two event.. first clear your existing Field1, second select in Field is your expression

Re: Use button action to set Field value to an expression

marcus_sommer — Tue, 26 Jan 2016 16:27:00 GMT

This worked for me:

='=date(max(%Datum))'

If you need to define a other date-format than the default-format it will be more tricky to get the syntax right because of the single-quotes within the date-function.

- Marcus

Re: Use button action to set Field value to an expression

swuehl — Tue, 26 Jan 2016 17:02:05 GMT

Try something like

='=Sale_Date=Max(TOTAL Sale_Date)'

Re: Use button action to set Field value to an expression

hugmarcel — Wed, 27 Jan 2016 08:09:07 GMT

thank you for the answers. Unfortunately, they do not really work.

With button action, I set Field1 to expression: ='=Sale_Date=Date(Max(TOTAL Sale_Date),''DD.MM.YYYY'')'

1.) It works when I click the button. Field1 gets value of max total sale.

2.) It does not work when I change the selection so that the Max(total Sale_Date) changes.

Field1 keeps the same value as after I have clicked the button (step 1.).

Any other idea?

Marcel

Re: Use button action to set Field value to an expression

swuehl — Wed, 27 Jan 2016 10:08:45 GMT

Could you describe your data model a bit more detailed? You are not making a selection in Sale_Date, but in another Field1? How are these related in your data model?

Could you post a small sample QVW?

Re: Use button action to set Field value to an expression

hugmarcel — Wed, 27 Jan 2016 10:28:31 GMT

thank you, see QVW attached.

1.) Click the blue button.
2.) -> TransIDTest will have value 988 -> OK
3.) Select value 3 of "TransLineID" in "Transactions" tablebox
4.) -> TransIDTest will STILL have value 988 -> NOT OK

Marcel

Re: Use button action to set Field value to an expression

marcus_sommer — Wed, 27 Jan 2016 11:22:18 GMT

I think the reason will be that TransIDTest is in a separat table and connected per field Num. If you creates TransIDTest within the table Transactions it will be differ - or is there a special reason why you used here an extra table, if yes it won't be clear in this example.

- Marcus

Re: Use button action to set Field value to an expression

hugmarcel — Wed, 27 Jan 2016 11:45:37 GMT

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

Re: Use button action to set Field value to an expression

marcus_sommer — Wed, 27 Jan 2016 12:06:05 GMT

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

Re: Use button action to set Field value to an expression

swuehl — Wed, 27 Jan 2016 12:15:04 GMT

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.

Re: Use button action to set Field value to an expression

hugmarcel — Wed, 27 Jan 2016 12:45:57 GMT

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