Hi,
This is the same issue as in thread: http://community.qlik.com/thread/16470 but the solution given is not working for me.
Problem:
Bookmark contains 2 fields:
Store = A
IsYesterday = 1
IsYesterday is a field in the calendar indicating the day of yesterday.
An automatically distributed report should give the sales results of yesterday per store.
Now on Monday this problem occurs: if the store was not open on Sunday, then there are no entries for yesterday. Qlikview then simply removes the IsYesterday field from the bookmark and displays all sales results for the store. This is weird! There should be an empty list.
I cannot put a set analysis in my table since the report loops over multiple stores, I'm not gonna make 20 versions of the same table to bypass this 'feature' 🙂
Hope someone has a good idea,
Johan.
