topic Set variable to a default value in QlikView

Set variable to a default value

edemerdjieva — Thu, 18 Jan 2018 13:25:51 GMT

Hi guys,

I have a calendar object and use a variable (vDateSelected) to assign values to that object.

I would like to create a button which resets the value of the calendar to a default value. This means changing the current value of vDateSelected at the click of the reset button.

For this I create a button with "Define variable" action where "Variable" = vDateSelected and "Value" = "=Min({[CurrentMonth]} [Date])". The problem is that the value expression is not interpreted and I have "-" as a result.

What would be the solution of this case? Any help is appreciated .

Re: Set variable to a default value

rubenmarin — Thu, 18 Jan 2018 17:42:12 GMT

Hi Elina, what is 'CurrentMonth'? a variable with month number?

In example it can be something like:

=Min({<MonthNumField={$(CurrentMonth)}>} [Date])

It will filter a field with months in numbers called MonthNumField, where the month number is equal to the variable CurrentMonth, form that month thakes the min date

Re: Set variable to a default value

edemerdjieva — Fri, 19 Jan 2018 09:46:42 GMT

Hi Ruben,

'CurrentMonth' is one of the values in the "Time" dimension that I use (defined in the load script).

I made another test: I assigned the expression "=Min({<MonthNumField={$(CurrentMonth)}>} [Date])" to a variable in the script and then modified the button action as follows:

"Variable" = vDateSelected

"Value" = vNewDate

But the result is: calendar object is now empty. I have the impression that the expression in vNewDate is not interpreted. On the contrary, if I assign a fixed value to the variable vNewDate then it works (date changes in the calendar object after button click).

Why QlikView does not interpret the expression?

Re: Set variable to a default value

marcus_sommer — Fri, 19 Jan 2018 14:21:51 GMT

Try it with:

"=Date(Min({<MonthNumField={$(CurrentMonth)}>} [Date]))"

because functions like min/max return not a string-interpretation of a date else just the pure number like 43119 for 2018/01/19.

- Marcus