topic Re: defining a variable in variable overview in QlikView

defining a variable in variable overview

wade12 — Sat, 12 Aug 2017 10:11:39 GMT

good morning qlik-heads,

i am attempting to change a variable definition from 42887

to Floor(Num(MonthStart(Today(), -2)))

in the variable overview (i.e. from hard-coded to dynamic)

but QV does not seem to accept it ... it clears all cells in chart table.

any/all advices welcomed.

thank you in advance for you assistance,

& have a nice weekend.

ahaahaaha — Sat, 12 Aug 2017 11:53:48 GMT

Hi,

Try

=Date(Floor(Num(MonthStart(Today(), -2))))

Regards,

Andrey

sunny_talwar — Sat, 12 Aug 2017 12:15:52 GMT

May be this

=Num(MonthStart(Today(), -2))

wade12 — Sat, 12 Aug 2017 13:02:44 GMT

thanks andrey

wade12 — Sat, 12 Aug 2017 13:03:00 GMT

thanks sunny.

somacdc — Wed, 06 Nov 2019 11:10:29 GMT

How can set the value of a variable in variable overview.

When i set the value of a variable in variable overview. The value has been removed after reopening the dashboard.