https://community.qlik.com/t5/QlikView/Stock-versus-Sales/m-p/496907#M185769 <HTML><HEAD></HEAD><BODY><P>The Answer is set analysis !</P></BODY></HTML> Fri, 21 Jun 2013 16:04:36 GMT timsaddler 2013-06-21T16:04:36Z https://community.qlik.com/t5/QlikView/Stock-versus-Sales/m-p/496904#M185766 <HTML><HEAD></HEAD><BODY><P>Hello</P><P>I am working on an app which contains sales data by date and current stock figure.</P><P>If i select a time frame in which there were no sales , then the stock "disappears".</P><P>The enclosed screenshots should show what i mean.</P><P></P><P><IMG __jive_id="43085" class="jive-image-thumbnail jive-image" onclick="" alt="45024a.jpg" src="https://community.qlik.com/legacyfs/online/43085_45024a.jpg" width="450" /></P><P></P><P>I<IMG __jive_id="43086" class="jive-image-thumbnail jive-image" onclick="" alt="45024b.jpg" src="https://community.qlik.com/legacyfs/online/43086_45024b.jpg" width="450" /></P><P>I have tried the "Show all values " dimension option , but it doesn't fix the issue.</P><P>Does anyone have any other suggestions?</P><P>thx</P></BODY></HTML> Fri, 21 Jun 2013 13:21:22 GMT https://community.qlik.com/t5/QlikView/Stock-versus-Sales/m-p/496904#M185766 timsaddler 2013-06-21T13:21:22Z https://community.qlik.com/t5/QlikView/Stock-versus-Sales/m-p/496905#M185767 <HTML><HEAD></HEAD><BODY><P>It depends on how data are linked; probably you have a table for sales and a table for stock, joined by material and date ... </P><P></P><P>If this is&nbsp; the scenario then you have to avoid the join and let data associate freely ... if not so ... let me know</P></BODY></HTML> Fri, 21 Jun 2013 13:26:55 GMT https://community.qlik.com/t5/QlikView/Stock-versus-Sales/m-p/496905#M185767 alexandros17 2013-06-21T13:26:55Z https://community.qlik.com/t5/QlikView/Stock-versus-Sales/m-p/496906#M185768 <HTML><HEAD></HEAD><BODY><P>The Answer is set analysis !</P></BODY></HTML> Fri, 21 Jun 2013 16:04:31 GMT https://community.qlik.com/t5/QlikView/Stock-versus-Sales/m-p/496906#M185768 timsaddler 2013-06-21T16:04:31Z https://community.qlik.com/t5/QlikView/Stock-versus-Sales/m-p/496907#M185769 <HTML><HEAD></HEAD><BODY><P>The Answer is set analysis !</P></BODY></HTML> Fri, 21 Jun 2013 16:04:36 GMT https://community.qlik.com/t5/QlikView/Stock-versus-Sales/m-p/496907#M185769 timsaddler 2013-06-21T16:04:36Z https://community.qlik.com/t5/QlikView/Stock-versus-Sales/m-p/496908#M185770 <HTML><HEAD></HEAD><BODY><P>The answer is set analysis - had a momentary lapse</P></BODY></HTML> Fri, 21 Jun 2013 16:05:16 GMT https://community.qlik.com/t5/QlikView/Stock-versus-Sales/m-p/496908#M185770 timsaddler 2013-06-21T16:05:16Z