Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
Showing results for 
Search instead for 
Did you mean: 

Calculated Dimesnion using now function


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.

Labels (1)
0 Replies