topic show data suppressed by selection in QlikView https://community.qlik.com/t5/QlikView/show-data-suppressed-by-selection/m-p/671031#M243785 <HTML><HEAD></HEAD><BODY><P>Hi Folks!</P><P>There are two different tables, Table: Target and Table: Achieved</P><P>There are two different Dates, one in each Table: Target_Date and Achieved_Date</P><P>The two tables are connected via: Customer</P><P></P><P>There is one diagram which Shows us the Achieved against the Target (i.e. Sales)</P><P></P><P>I have to select both Dates (Period Month, i.e. August) as I have no Master Calendar.</P><P></P><P>Doing this, everything selected Shows up, but.....</P><P>Targets without Achievements in the selected period do not Show up because the selected<BR />Achieved_Date does not give any results (no Achievements in this period), leading in suppressing the</P><P>data of the Target Table, although selected via the Achieved_Date.</P><P></P><P>So: What is the way to go that the Targets Show up although they have no Achievements so far in the<BR />selected Period?</P><P></P><P>Seems to be difficult to explain, however, I just tried to do my best,</P><P>and thank you in advance for for efforts.</P><P>If questions left, please contact me,</P><P><BR />Wolfgang</P></BODY></HTML> Thu, 28 Aug 2014 14:04:20 GMT Anonymous 2014-08-28T14:04:20Z show data suppressed by selection https://community.qlik.com/t5/QlikView/show-data-suppressed-by-selection/m-p/671031#M243785 <HTML><HEAD></HEAD><BODY><P>Hi Folks!</P><P>There are two different tables, Table: Target and Table: Achieved</P><P>There are two different Dates, one in each Table: Target_Date and Achieved_Date</P><P>The two tables are connected via: Customer</P><P></P><P>There is one diagram which Shows us the Achieved against the Target (i.e. Sales)</P><P></P><P>I have to select both Dates (Period Month, i.e. August) as I have no Master Calendar.</P><P></P><P>Doing this, everything selected Shows up, but.....</P><P>Targets without Achievements in the selected period do not Show up because the selected<BR />Achieved_Date does not give any results (no Achievements in this period), leading in suppressing the</P><P>data of the Target Table, although selected via the Achieved_Date.</P><P></P><P>So: What is the way to go that the Targets Show up although they have no Achievements so far in the<BR />selected Period?</P><P></P><P>Seems to be difficult to explain, however, I just tried to do my best,</P><P>and thank you in advance for for efforts.</P><P>If questions left, please contact me,</P><P><BR />Wolfgang</P></BODY></HTML> Thu, 28 Aug 2014 14:04:20 GMT https://community.qlik.com/t5/QlikView/show-data-suppressed-by-selection/m-p/671031#M243785 Anonymous 2014-08-28T14:04:20Z Re: show data suppressed by selection https://community.qlik.com/t5/QlikView/show-data-suppressed-by-selection/m-p/671032#M243786 <HTML><HEAD></HEAD><BODY><P>Can you provide some dummy data?</P></BODY></HTML> Thu, 28 Aug 2014 14:05:24 GMT https://community.qlik.com/t5/QlikView/show-data-suppressed-by-selection/m-p/671032#M243786 MK_QSL 2014-08-28T14:05:24Z