Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Stale After and Where Clause

Hi All,

Reaching out to your help.

I am trying to use the stale after option available for buffers. A buffered QVD file is getting created when I am not using a where clause for an Excel based input file. However, if I want to reduce the data using a where clause, QVD is not getting created. However, if I use the same with a backend SQL Statement it works fine as expected. I tried searching QlikView help and community to understand the reason behind this, but could not find any info relevant to this. Can anybody help me understand this? Thanks.

Thanks & Regards,

1 Reply
arniewolff
New Contributor III

Re: Stale After and Where Clause

Ambika,

I'm seeing the same thing using a non-optimized load from a QVD. If I add a Where clause, a buffer file does not get created (whether or not I use Stale After in the Buffer line).

Were you able to find an answer?

Arnie