Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Partner
Partner

defining a variable in variable overview

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.

1 Solution

Accepted Solutions

Re: defining a variable in variable overview

May be this

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

4 Replies
ahaahaaha
Honored Contributor

Re: defining a variable in variable overview

Hi,

Try

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


Regards,

Andrey

Re: defining a variable in variable overview

May be this

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

Partner
Partner

Re: defining a variable in variable overview

thanks andrey

Partner
Partner

Re: defining a variable in variable overview

thanks sunny.