topic Re: Showing selective data in QlikView https://community.qlik.com/t5/QlikView/Showing-selective-data/m-p/382980#M142935 <HTML><HEAD></HEAD><BODY><P>instead of table box use chart - straight table.</P><P></P><P>Regards,</P><P>tresesco</P></BODY></HTML> Fri, 31 Aug 2012 12:32:35 GMT tresB 2012-08-31T12:32:35Z Showing selective data https://community.qlik.com/t5/QlikView/Showing-selective-data/m-p/382974#M142929 <HTML><HEAD></HEAD><BODY><P>I have 3 QVD's all with a "Day" "Month" "Year" key linking them.</P><P></P><P>One of the QVD's only gets updated every 2 days, so it's constantly 2 days behind in data.</P><P></P><P>I have 3 Chart Pivot Tables to display the data from the 3 QVD's. I was wondering, is there any way to surpress the one that doesn't get updated daily so that the last 2 days (which shows 0 for no data) only shows the data captured?</P><P></P><P>I'm thinking maybe to break the link (as I'm not doing any listbox filters or giving them the ability TO filter per day)</P></BODY></HTML> Fri, 31 Aug 2012 10:33:46 GMT https://community.qlik.com/t5/QlikView/Showing-selective-data/m-p/382974#M142929 2012-08-31T10:33:46Z Re: Showing selective data https://community.qlik.com/t5/QlikView/Showing-selective-data/m-p/382975#M142930 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>you can do whatever you want based on the condition of qvd creation time.</P><P></P><P class="Code"><STRONG>QvdCreateTime</STRONG>('MyFile.qvd')</P><P class="Code">QvdCreateTime('C:\MyDir\MyFile.qvd')</P><P class="Code"></P><P class="Code">I guess this would help you.</P><P class="Code"></P><P class="Code">Regards,</P><P class="Code">tresesco</P></BODY></HTML> Fri, 31 Aug 2012 11:02:53 GMT https://community.qlik.com/t5/QlikView/Showing-selective-data/m-p/382975#M142930 tresB 2012-08-31T11:02:53Z Re: Showing selective data https://community.qlik.com/t5/QlikView/Showing-selective-data/m-p/382976#M142931 <HTML><HEAD></HEAD><BODY><P>Thanks, I'll keep that in mind, the problem though is the QVD is generated every day whereas the XLS source isn't updated everyday, and if they do update the XLS source, its for the past 2 days.</P><P></P><P>So 31st they'll capture 28th data, 1st of Sept they'll capture 29th data etc...</P></BODY></HTML> Fri, 31 Aug 2012 11:10:11 GMT https://community.qlik.com/t5/QlikView/Showing-selective-data/m-p/382976#M142931 2012-08-31T11:10:11Z Re: Showing selective data https://community.qlik.com/t5/QlikView/Showing-selective-data/m-p/382977#M142932 <HTML><HEAD></HEAD><BODY><P>Instead of limiting the number of days that pull through from the data, is it possible to manipulate the display to only show the last 7 days but still account for the entire month? (otherwise my sums and averages only show for the last 7 days)</P></BODY></HTML> Fri, 31 Aug 2012 11:46:14 GMT https://community.qlik.com/t5/QlikView/Showing-selective-data/m-p/382977#M142932 2012-08-31T11:46:14Z Re: Showing selective data https://community.qlik.com/t5/QlikView/Showing-selective-data/m-p/382978#M142933 <HTML><HEAD></HEAD><BODY><P>That you can always achieve by choosing available option in presentation tab of chart property.</P><P></P><P>Regards,</P><P>tresesco</P></BODY></HTML> Fri, 31 Aug 2012 12:20:52 GMT https://community.qlik.com/t5/QlikView/Showing-selective-data/m-p/382978#M142933 tresB 2012-08-31T12:20:52Z Re: Showing selective data https://community.qlik.com/t5/QlikView/Showing-selective-data/m-p/382979#M142934 <HTML><HEAD></HEAD><BODY><P>Any insights as to how? Because all that I can see is I can make the text show left/right/center. Choose to wrap text, where my labels are and a bunch of allow/disallow stuff. Nowhere where I can add "show only 7 days from the month's worth of data you have"</P></BODY></HTML> Fri, 31 Aug 2012 12:24:34 GMT https://community.qlik.com/t5/QlikView/Showing-selective-data/m-p/382979#M142934 2012-08-31T12:24:34Z Re: Showing selective data https://community.qlik.com/t5/QlikView/Showing-selective-data/m-p/382980#M142935 <HTML><HEAD></HEAD><BODY><P>instead of table box use chart - straight table.</P><P></P><P>Regards,</P><P>tresesco</P></BODY></HTML> Fri, 31 Aug 2012 12:32:35 GMT https://community.qlik.com/t5/QlikView/Showing-selective-data/m-p/382980#M142935 tresB 2012-08-31T12:32:35Z Re: Showing selective data https://community.qlik.com/t5/QlikView/Showing-selective-data/m-p/382981#M142936 <HTML><HEAD></HEAD><BODY><P>If I do that I lose my pivots. Might as well then just use SSRS with some fancy SQL at the backend</P></BODY></HTML> Fri, 31 Aug 2012 12:34:51 GMT https://community.qlik.com/t5/QlikView/Showing-selective-data/m-p/382981#M142936 2012-08-31T12:34:51Z