Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

I want to use data rather than ReloadTime() - possible?

So here is my case.

Today I use ReloadTime for some charts to filter out things for "today" only  - works fine as long as there I any data available for the same date as the day of data-reload, however under some conditions - the data for "today" might not be available yet....and

all those charts get's "nulled" basically.

Is there a way to rather use something like;  - "the last date that was available in column "loadDate""  ?

not sure my question is understandable - lets see what you think  :-)

1 Solution

Accepted Solutions
balrajahlawat
Esteemed Contributor

Re: I want to use data rather than ReloadTime() - possible?

loadDate is field in your data?

If yes, then use this?

=max(loadDate)

3 Replies
balrajahlawat
Esteemed Contributor

Re: I want to use data rather than ReloadTime() - possible?

loadDate is field in your data?

If yes, then use this?

=max(loadDate)

thakkarrahul01
Contributor

Re: I want to use data rather than ReloadTime() - possible?

If you are sure date field you are using won't have future dates then you can go ahead with max(dateField) in set analysis.

I hope this helps. Please elaborate with data in case I have misunderstood your scenario.

Kind Regards,

Rahul Thakkar


Not applicable

Re: I want to use data rather than ReloadTime() - possible?

Brilliant - thanks.