Content in Tableau Community Forums /profile-content.jspa?filterID=contentstatus[published]&targetUser=46721 Recent content in Tableau Community Forums en Thu, 18 Dec 2014 13:27:19 GMT Jive Engage 8.0.5.0 (http://jivesoftware.com/products/) 2014-12-18T13:27:19Z en Help required in MTD YTD QTD https://community.tableau.com/thread/152142 <!-- [DocumentBodyStart:7cc0beaf-e469-4cda-a344-abfa7ee65ea6] --><div class="jive-rendered-content"><p>Hi All</p><p>I tried to perform YTD MTD QTD by applying same steps that are mention in Knowledge Base but unfortunately it didn't get the result. Please see the attachment. Help me out </p></div><!-- [DocumentBodyEnd:7cc0beaf-e469-4cda-a344-abfa7ee65ea6] --> calculation Thu, 18 Dec 2014 13:27:19 GMT tableaucommunity@tableau.com https://community.tableau.com/thread/152142 2014-12-18T13:27:19Z 4 years 6 months ago 15 0 Want to Convert Qlikview Script into Tableau https://community.tableau.com/thread/152638 <!-- [DocumentBodyStart:4a14e35a-b845-445c-8f04-245c79ad115a] --><div class="jive-rendered-content"><p>Below is the qlikview script need help to convert into Tableau</p><p>Sum(if(Match([Country],'Italy','Canada','USA','UK')&gt;0,[Quantity],0)) </p></div><!-- [DocumentBodyEnd:4a14e35a-b845-445c-8f04-245c79ad115a] --> calculation Mon, 01 Dec 2014 15:48:23 GMT tableaucommunity@tableau.com https://community.tableau.com/thread/152638 2014-12-01T15:48:23Z 4 years 7 months ago 8 0 i have a data in cross table format and have to convert it into raw format https://community.tableau.com/thread/150930 <!-- [DocumentBodyStart:129b9bd1-d5a8-46d7-aa1b-5edcb96d8b38] --><div class="jive-rendered-content"><p>i have a data in cross table format and have to convert it into raw format</p><p style="min-height: 8pt; padding: 0px;">&#160;</p><table border="0" cellpadding="0" cellspacing="0" style="width: 343px;"><tbody><tr><td class="xl63" height="20" style="border:0px solid black;" width="88">Country </td><td class="xl63" style="border:0px solid black;" width="85">Jan</td><td class="xl63" style="border:0px solid black;" width="85">Feb</td><td class="xl63" style="border:0px solid black;" width="85">Mar</td></tr><tr><td height="20" style="border:0px solid black;">USA</td><td align="right" style="border:0px solid black;">1000</td><td align="right" style="border:0px solid black;">2000</td><td align="right" style="border:0px solid black;">3000</td></tr><tr><td height="20" style="border:0px solid black;">India</td><td align="right" style="border:0px solid black;">10000</td><td align="right" style="border:0px solid black;">20000</td><td align="right" style="border:0px solid black;">30000</td></tr><tr><td height="20" style="border:0px solid black;">China</td><td align="right" style="border:0px solid black;">100000</td><td align="right" style="border:0px solid black;">200000</td><td align="right" style="border:0px solid black;">300000</td></tr></tbody></table><p style="min-height: 8pt; padding: 0px;">&#160;</p><p>Needed Format:</p><p style="min-height: 8pt; padding: 0px;">&#160;</p><p>&#160;&#160; </p><table border="0" cellpadding="0" cellspacing="0" style="width: 261px;"><tbody><tr><td class="xl65" height="20" style="border:0px solid black;" width="88">Country </td><td class="xl65" style="border:0px solid black;" width="88">Month</td><td class="xl65" style="border:0px solid black;" width="85">Value</td></tr><tr><td height="20" style="border:0px solid black;">USA</td><td class="xl65" style="border:0px solid black;">Jan</td><td align="right" style="border:0px solid black;">1000</td></tr><tr><td height="20" style="border:0px solid black;">USA</td><td class="xl65" style="border:0px solid black;">Jan</td><td align="right" style="border:0px solid black;">2000</td></tr><tr><td height="20" style="border:0px solid black;">USA</td><td class="xl65" style="border:0px solid black;">Jan</td><td align="right" style="border:0px solid black;">3000</td></tr><tr><td height="20" style="border:0px solid black;">India</td><td class="xl65" style="border:0px solid black;">Feb</td><td align="right" style="border:0px solid black;">10000</td></tr><tr><td height="20" style="border:0px solid black;">India</td><td class="xl65" style="border:0px solid black;">Feb</td><td align="right" style="border:0px solid black;">20000</td></tr><tr><td height="20" style="border:0px solid black;">India</td><td class="xl65" style="border:0px solid black;">Feb</td><td align="right" style="border:0px solid black;">30000</td></tr><tr><td height="20" style="border:0px solid black;">China</td><td class="xl65" style="border:0px solid black;">Mar</td><td align="right" style="border:0px solid black;">100000</td></tr><tr><td height="20" style="border:0px solid black;">China</td><td class="xl65" style="border:0px solid black;">Mar</td><td align="right" style="border:0px solid black;">200000</td></tr><tr><td height="20" style="border:0px solid black;">China</td><td class="xl65" style="border:0px solid black;">Mar</td><td align="right" style="border:0px solid black;">300000</td></tr></tbody></table><p style="min-height: 8pt; padding: 0px;">&#160;</p><p>Please provide me the solution how to do it in tableau</p></div><!-- [DocumentBodyEnd:129b9bd1-d5a8-46d7-aa1b-5edcb96d8b38] --> Thu, 30 Oct 2014 14:06:35 GMT tableaucommunity@tableau.com https://community.tableau.com/thread/150930 2014-10-30T14:06:35Z 4 years 8 months ago 4 0 i have a data in cross table format and have to convert it into raw format? https://community.tableau.com/thread/150932 <!-- [DocumentBodyStart:ad85941e-a1c2-4989-ae54-deeada1e2292] --><div class="jive-rendered-content"><p>i have a data in cross table format and have to convert it into raw format</p><p style="min-height: 8pt; padding: 0px;">&#160;</p><table border="0" cellpadding="0" cellspacing="0" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}"><tbody><tr><td class="xl63" height="20" style="border:0px solid black;border: 0px solid black;" width="88">Country </td><td class="xl63" style="border:0px solid black;border: 0px solid black;" width="85">Jan</td><td class="xl63" style="border:0px solid black;border: 0px solid black;" width="85">Feb</td><td class="xl63" style="border:0px solid black;border: 0px solid black;" width="85">Mar</td></tr><tr><td height="20" style="border:0px solid black;border: 0px solid black;">USA</td><td align="right" style="border:0px solid black;border: 0px solid black;">1000</td><td align="right" style="border:0px solid black;border: 0px solid black;">2000</td><td align="right" style="border:0px solid black;border: 0px solid black;">3000</td></tr><tr><td height="20" style="border:0px solid black;border: 0px solid black;">India</td><td align="right" style="border:0px solid black;border: 0px solid black;">10000</td><td align="right" style="border:0px solid black;border: 0px solid black;">20000</td><td align="right" style="border:0px solid black;border: 0px solid black;">30000</td></tr><tr><td height="20" style="border:0px solid black;border: 0px solid black;">China</td><td align="right" style="border:0px solid black;border: 0px solid black;">100000</td><td align="right" style="border:0px solid black;border: 0px solid black;">200000</td><td align="right" style="border:0px solid black;border: 0px solid black;">300000</td></tr></tbody></table><p style="min-height: 8pt; padding: 0px;">&#160;</p><p>Needed Format:</p><p style="min-height: 8pt; padding: 0px;">&#160;</p><p>&#160;&#160; </p><table border="0" cellpadding="0" cellspacing="0"><tbody><tr><td class="xl65" height="20" style="border:0px solid black;border: 0px solid black;" width="88">Country </td><td class="xl65" style="border:0px solid black;border: 0px solid black;" width="88">Month</td><td class="xl65" style="border:0px solid black;border: 0px solid black;" width="85">Value</td></tr><tr><td height="20" style="border:0px solid black;border: 0px solid black;">USA</td><td class="xl65" style="border:0px solid black;border: 0px solid black;">Jan</td><td align="right" style="border:0px solid black;border: 0px solid black;">1000</td></tr><tr><td height="20" style="border:0px solid black;border: 0px solid black;">USA</td><td class="xl65" style="border:0px solid black;border: 0px solid black;">Jan</td><td align="right" style="border:0px solid black;border: 0px solid black;">2000</td></tr><tr><td height="20" style="border:0px solid black;border: 0px solid black;">USA</td><td class="xl65" style="border:0px solid black;border: 0px solid black;">Jan</td><td align="right" style="border:0px solid black;border: 0px solid black;">3000</td></tr><tr><td height="20" style="border:0px solid black;border: 0px solid black;">India</td><td class="xl65" style="border:0px solid black;border: 0px solid black;">Feb</td><td align="right" style="border:0px solid black;border: 0px solid black;">10000</td></tr><tr><td height="20" style="border:0px solid black;border: 0px solid black;">India</td><td class="xl65" style="border:0px solid black;border: 0px solid black;">Feb</td><td align="right" style="border:0px solid black;border: 0px solid black;">20000</td></tr><tr><td height="20" style="border:0px solid black;border: 0px solid black;">India</td><td class="xl65" style="border:0px solid black;border: 0px solid black;">Feb</td><td align="right" style="border:0px solid black;border: 0px solid black;">30000</td></tr><tr><td height="20" style="border:0px solid black;border: 0px solid black;">China</td><td class="xl65" style="border:0px solid black;border: 0px solid black;">Mar</td><td align="right" style="border:0px solid black;border: 0px solid black;">100000</td></tr><tr><td height="20" style="border:0px solid black;border: 0px solid black;">China</td><td class="xl65" style="border:0px solid black;border: 0px solid black;">Mar</td><td align="right" style="border:0px solid black;border: 0px solid black;">200000</td></tr><tr><td height="20" style="border:0px solid black;border: 0px solid black;">China</td><td class="xl65" style="border:0px solid black;border: 0px solid black;">Mar</td><td align="right" style="border:0px solid black;border: 0px solid black;">300000</td></tr></tbody></table><p style="min-height: 8pt; padding: 0px;">&#160;</p><p>Please provide me the solution how to do it in tableau</p></div><!-- [DocumentBodyEnd:ad85941e-a1c2-4989-ae54-deeada1e2292] --> tableau data extract Thu, 30 Oct 2014 13:16:53 GMT tableaucommunity@tableau.com https://community.tableau.com/thread/150932 2014-10-30T13:16:53Z 4 years 8 months ago 1 0