Hi,
On Qlik April 2020 I am using the below as calculated Dimension to fetch date within 12 hours
=if([60 Min Granularity]>=Floor(now()-6/24,1/24) and [60 Min Granularity]< ceil(now()+ 5/24,1/24),([60 Min Granularity]))
This is working , but next day it won't be working. If I make any change to the formula like adding some unwanted brackets, it will work again, but for a day .Seems to me like some caching issues.
I have tried with different timer-mode also like now(1) and now(2).
Can anyone please check if I am doing the right thing.