topic Variable Input - Default Value? in App Development

Variable Input - Default Value?

SparkyMarky — Sat, 16 Nov 2024 18:37:02 GMT

Hi,

A request came from a client who wants to know if I can set default values for two Dashboard Bundle Variable Input objects. The dynamic values displayed are a range of months. For one variable input, I want to default it to the prior month, and for the other variable input, I want to default it to the current month.

Thank you

Re: Variable Input - Default Value?

Lisa_P — Tue, 19 May 2020 23:04:38 GMT

This should be possible by defining your Variable from the window in the Asset panel using an expression beginning with = to ensure that this is defined to store this result.

Re: Variable Input - Default Value?

BalaBhaskar_Qlik — Wed, 20 May 2020 10:17:15 GMT

In the variables, try like this:

For current month : Max(Month) or Maxstring(Month).

Previous month: Addmonths(Max(Month),-1) or Max(Month,2).

Re: Variable Input - Default Value?

SparkyMarky — Thu, 28 May 2020 20:28:28 GMT

Hi again,

Thank you for your quick responses. I just got back to this project so sorry for a delayed response.

I ended up setting the variables in the load script. I found the max and 2nd max dates in the data and then did a LET = peek() of each and assigned these to the variables.

After the load, the variable objects were set correctly.

Regards,

Mark