topic Field from bookmark removed if no data available in QlikView https://community.qlik.com/t5/QlikView/Field-from-bookmark-removed-if-no-data-available/m-p/349580#M129528 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>This is the same issue as in thread: <A _jive_internal="true" href="https://community.qlik.com/thread/16470">http://community.qlik.com/thread/16470</A> but the solution given is not working for me.</P><P></P><P>Problem:</P><P>Bookmark contains 2 fields:</P><P>Store = A</P><P>IsYesterday = 1</P><P></P><P>IsYesterday is a field in the calendar indicating the day of yesterday.</P><P>An automatically distributed report should give the sales results of yesterday per store.</P><P></P><P>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.</P><P></P><P>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' <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P></P><P>Hope someone has a good idea,</P><P></P><P>Johan.</P></BODY></HTML> Mon, 14 May 2012 08:59:21 GMT 2012-05-14T08:59:21Z Field from bookmark removed if no data available https://community.qlik.com/t5/QlikView/Field-from-bookmark-removed-if-no-data-available/m-p/349580#M129528 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>This is the same issue as in thread: <A _jive_internal="true" href="https://community.qlik.com/thread/16470">http://community.qlik.com/thread/16470</A> but the solution given is not working for me.</P><P></P><P>Problem:</P><P>Bookmark contains 2 fields:</P><P>Store = A</P><P>IsYesterday = 1</P><P></P><P>IsYesterday is a field in the calendar indicating the day of yesterday.</P><P>An automatically distributed report should give the sales results of yesterday per store.</P><P></P><P>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.</P><P></P><P>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' <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P></P><P>Hope someone has a good idea,</P><P></P><P>Johan.</P></BODY></HTML> Mon, 14 May 2012 08:59:21 GMT https://community.qlik.com/t5/QlikView/Field-from-bookmark-removed-if-no-data-available/m-p/349580#M129528 2012-05-14T08:59:21Z