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.
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).
