topic Re: How to do the chart ? in QlikView https://community.qlik.com/t5/QlikView/How-to-do-the-chart/m-p/1220279#M871841 <HTML><HEAD></HEAD><BODY><P>Do you want something like this??</P><P><IMG alt="Untitled.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/144720_Untitled.png" style="height: 89px; width: 620px;" /></P><P></P><P>PFA sample file</P></BODY></HTML> Thu, 24 Nov 2016 08:23:31 GMT saimahasan 2016-11-24T08:23:31Z How to do the chart ? https://community.qlik.com/t5/QlikView/How-to-do-the-chart/m-p/1220275#M871837 <HTML><HEAD></HEAD><BODY><P>Hi All ,</P><P></P><P>I got two different reports on my qlikview model .</P><P>How can I merge them into one ?</P><P></P><P><IMG __jive_id="144715" alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/144715_Capture.PNG" style="height: 192px; width: 620px;" /></P><P></P><P>So , the two reports needs to be one .</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/144723_Capture.PNG" style="height: 257px; width: 620px;" /></P><P></P><P>Sample attached.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-do-the-chart/m-p/1220275#M871837 suvechha_b 2020-11-25T16:16:04Z Re: How to do the chart ? https://community.qlik.com/t5/QlikView/How-to-do-the-chart/m-p/1220276#M871838 <HTML><HEAD></HEAD><BODY><P>You can merge two expressions with the common chart with expression used in the common chart.</P><P></P><P>Regards</P><P>Anand</P></BODY></HTML> Thu, 24 Nov 2016 07:20:54 GMT https://community.qlik.com/t5/QlikView/How-to-do-the-chart/m-p/1220276#M871838 its_anandrjs 2016-11-24T07:20:54Z Re: How to do the chart ? https://community.qlik.com/t5/QlikView/How-to-do-the-chart/m-p/1220277#M871839 <HTML><HEAD></HEAD><BODY><P>Do you mean this ....</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/144719_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Thu, 24 Nov 2016 07:32:30 GMT https://community.qlik.com/t5/QlikView/How-to-do-the-chart/m-p/1220277#M871839 Anil_Babu_Samineni 2016-11-24T07:32:30Z Re: How to do the chart ? https://community.qlik.com/t5/QlikView/How-to-do-the-chart/m-p/1220278#M871840 <HTML><HEAD></HEAD><BODY><P>No , this is the sum.</P><P></P><P>It should look like this .</P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/144722_Capture.PNG" style="height: 257px; width: 620px;" /></P></BODY></HTML> Thu, 24 Nov 2016 07:58:03 GMT https://community.qlik.com/t5/QlikView/How-to-do-the-chart/m-p/1220278#M871840 suvechha_b 2016-11-24T07:58:03Z Re: How to do the chart ? https://community.qlik.com/t5/QlikView/How-to-do-the-chart/m-p/1220279#M871841 <HTML><HEAD></HEAD><BODY><P>Do you want something like this??</P><P><IMG alt="Untitled.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/144720_Untitled.png" style="height: 89px; width: 620px;" /></P><P></P><P>PFA sample file</P></BODY></HTML> Thu, 24 Nov 2016 08:23:31 GMT https://community.qlik.com/t5/QlikView/How-to-do-the-chart/m-p/1220279#M871841 saimahasan 2016-11-24T08:23:31Z Re: How to do the chart ? https://community.qlik.com/t5/QlikView/How-to-do-the-chart/m-p/1220280#M871842 <HTML><HEAD></HEAD><BODY><P>Using a preset calendar you can achieve a table as below.</P><P><A href="https://community.qlik.com/docs/DOC-16968">Period Presets: Compare Periods on the fly</A></P><P><IMG alt="preset_cal.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/144725_preset_cal.PNG" style="height: auto;" /></P></BODY></HTML> Thu, 24 Nov 2016 08:29:20 GMT https://community.qlik.com/t5/QlikView/How-to-do-the-chart/m-p/1220280#M871842 vinieme12 2016-11-24T08:29:20Z Re: How to do the chart ? https://community.qlik.com/t5/QlikView/How-to-do-the-chart/m-p/1220281#M871843 <HTML><HEAD></HEAD><BODY><P>Is it possible to put the YTD below the Month. like this.</P><P>I doesn't want at side. I want it below.</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/144728_Capture.PNG" style="height: 257px; width: 620px;" /></P></BODY></HTML> Thu, 24 Nov 2016 08:31:57 GMT https://community.qlik.com/t5/QlikView/How-to-do-the-chart/m-p/1220281#M871843 suvechha_b 2016-11-24T08:31:57Z Re: How to do the chart ? https://community.qlik.com/t5/QlikView/How-to-do-the-chart/m-p/1220282#M871844 <HTML><HEAD></HEAD><BODY><P>Nope , not possible afaik</P><P>The<A _jive_internal="true" data-containerid="2049" data-containertype="14" data-objectid="16968" data-objecttype="102" href="https://community.qlik.com/docs/DOC-16968"><SPAN style="color: #0066cc; text-decoration: underline;">Period Calendar</SPAN></A> will be a more dynamic solution</P></BODY></HTML> Thu, 24 Nov 2016 08:33:25 GMT https://community.qlik.com/t5/QlikView/How-to-do-the-chart/m-p/1220282#M871844 vinieme12 2016-11-24T08:33:25Z Re: How to do the chart ? https://community.qlik.com/t5/QlikView/How-to-do-the-chart/m-p/1220283#M871845 <HTML><HEAD></HEAD><BODY><P>one way to achive this is , Create two separate <SPAN style="font-size: 13.3333px;">charts&nbsp; </SPAN>and remove header caption&nbsp; and adjust those one by one .</P><P></P><P>I hope this may helps you</P><P></P><P></P><P>-Nagarjun</P></BODY></HTML> Thu, 24 Nov 2016 08:44:07 GMT https://community.qlik.com/t5/QlikView/How-to-do-the-chart/m-p/1220283#M871845 nagarjuna_kotha 2016-11-24T08:44:07Z Re: How to do the chart ? https://community.qlik.com/t5/QlikView/How-to-do-the-chart/m-p/1220284#M871846 <HTML><HEAD></HEAD><BODY><P>Do you like this</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/144732_Capture.PNG" style="height: 322px; width: 620px;" /></P></BODY></HTML> Thu, 24 Nov 2016 09:08:08 GMT https://community.qlik.com/t5/QlikView/How-to-do-the-chart/m-p/1220284#M871846 Anil_Babu_Samineni 2016-11-24T09:08:08Z Re: How to do the chart ? https://community.qlik.com/t5/QlikView/How-to-do-the-chart/m-p/1220285#M871847 <HTML><HEAD></HEAD><BODY><P>It is correct but</P><P>I can't even copy the object. and I need to export the report to excel.</P></BODY></HTML> Thu, 24 Nov 2016 09:14:38 GMT https://community.qlik.com/t5/QlikView/How-to-do-the-chart/m-p/1220285#M871847 suvechha_b 2016-11-24T09:14:38Z Re: How to do the chart ? https://community.qlik.com/t5/QlikView/How-to-do-the-chart/m-p/1220286#M871848 <HTML><HEAD></HEAD><BODY><P>these are two tables stacked on top of each other! Got to Settings&gt;Sheet properties &gt;security</P></BODY></HTML> Thu, 24 Nov 2016 09:19:08 GMT https://community.qlik.com/t5/QlikView/How-to-do-the-chart/m-p/1220286#M871848 vinieme12 2016-11-24T09:19:08Z Re: How to do the chart ? https://community.qlik.com/t5/QlikView/How-to-do-the-chart/m-p/1220287#M871849 <HTML><HEAD></HEAD><BODY><P>What macro you've tried to send those reports into Excel. If you share that, we may might can help you. But, There is no direct way. Let's see how work around.</P><P></P><P>Can we have macro for that / Simple right click (Send to Excel)? Can you confirm me on this</P></BODY></HTML> Thu, 24 Nov 2016 09:19:40 GMT https://community.qlik.com/t5/QlikView/How-to-do-the-chart/m-p/1220287#M871849 Anil_Babu_Samineni 2016-11-24T09:19:40Z Re: How to do the chart ? https://community.qlik.com/t5/QlikView/How-to-do-the-chart/m-p/1220288#M871850 <HTML><HEAD></HEAD><BODY><P>Thanks for you help.</P><P></P><P>But my requirement was not fulfilling. As we need to export the report in excel in one document. But here it can be export but with two different excel.</P></BODY></HTML> Thu, 24 Nov 2016 09:31:14 GMT https://community.qlik.com/t5/QlikView/How-to-do-the-chart/m-p/1220288#M871850 suvechha_b 2016-11-24T09:31:14Z Re: How to do the chart ? https://community.qlik.com/t5/QlikView/How-to-do-the-chart/m-p/1220289#M871851 <HTML><HEAD></HEAD><BODY><P>That is the reason. I want to know does user / Client accept to allow the Macros. If so, I can try for that as well once i get free.</P><P></P><P>So, here i have 2 objects in that i can make single object in Excel by using hit the button after writing Macros. If User / Client allowed i may might try with the easy way. good to hear moving forward <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 24 Nov 2016 09:37:06 GMT https://community.qlik.com/t5/QlikView/How-to-do-the-chart/m-p/1220289#M871851 Anil_Babu_Samineni 2016-11-24T09:37:06Z