I have just reported the following bug to Qlik and wanted to hear if anyone else is having the same problem:
Right now, if a user subscribes to an object that uses a date variable to define a date range, the object will not show the latest data when recieving the subscription email with a screenshot of the object. Even though, if the user follows the link to the app, the object is shown correctly when opening the app.
Through testing this issue extensively, I've isolated the problem to the pre-evaluation of a variable.
For instance, this expression will NOT show the updated value in the subscription object:
SUM({<
[OrderDate.Calendar.Date]={">=$(vMinDate)<=$(vMaxDate)"}
>}SalesAmount)
...when the variables are defined as the following:
vMinDate: =MonthStart(Today()-1)
vMaxDate: =Date(Today()-1)
However, this expression WILL show the updated value in the object:
SUM({<
[OrderDate.Calendar.Date]={">=$(=$(vMinDate))<=$(=$(vMaxDate))"}
>}SalesAmount)
...when the variables are defined as the following:
vMinDate: MonthStart(Today()-1)
vMaxDate: Date(Today()-1)
(please note the double evaluation of the variables in the expression and the absence of equal signs in the variable expressions)
So while this IS a workaround right now, getting subscriptions to work in our Qlik SaaS environment would require a re-definition of multiple variables and expressions in all the apps where subscriptions could be relevant. This is a big task when in fact the subscription feature is not working as expected or intended.
Anyone else seeing the same behaviour?
