Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
wade12
Partner - Creator II
Partner - Creator II

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
sunny_talwar

May be this

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

View solution in original post

5 Replies
ahaahaaha
Partner - Master
Partner - Master

Hi,

Try

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


Regards,

Andrey

sunny_talwar

May be this

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

wade12
Partner - Creator II
Partner - Creator II
Author

thanks andrey

wade12
Partner - Creator II
Partner - Creator II
Author

thanks sunny.

somacdc
Contributor III
Contributor III

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.

 
 
 
 
 

VO.PNG