<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: Loading XBRL data into QlikSense / QlikView in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/Loading-XBRL-data-into-QlikSense-QlikView/m-p/1207644#M1236994</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hello,&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;Please see below:&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="margin-left: .5in;"&gt;&lt;SPAN lang="EN-AU" style="color: #1f497d;"&gt;Suggestion 1: Indeed, I’ve looked into how feasible XBRL ingestion and production are from Qlik products, and it’s extremely difficult. XBRL documents require a LOT of metadata to be available for tagging the financial data correctly. Every country has its own standard for XBRL schemas, and they change periodically. After discussions with &lt;A href="https://www.corefiling.com/"&gt;https://www.corefiling.com/&lt;/A&gt; in 2014 I concluded that Excel integration is key, and &lt;A href="http://www.qvexcel.com/"&gt;http://www.qvexcel.com/&lt;/A&gt; might be useful for extracting Qlik data and preparing it within Excel for production of XBRL using a specialist tool.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="margin-left: .5in;"&gt;&lt;SPAN lang="EN-AU" style="color: #1f497d;"&gt;You can see example XBRL taxonomy and filings for US Listed Companies at &lt;A href="http://xbrl.sec.gov/"&gt;http://xbrl.sec.gov/&lt;/A&gt;, &lt;/SPAN&gt;&lt;/P&gt;&lt;P style="margin-left: .5in;"&gt;&lt;SPAN lang="EN-AU" style="color: #1f497d;"&gt;for example Qlik’s 2015 results at &lt;A href="http://www.sec.gov/Archives/edgar/data/1305294/000119312516481915/0001193125-16-481915-index.htm"&gt;http://www.sec.gov/Archives/edgar/data/1305294/000119312516481915/0001193125-16-481915-index.htm&lt;/A&gt; &lt;/SPAN&gt;&lt;/P&gt;&lt;P style="margin-left: .5in;"&gt;&lt;SPAN lang="EN-AU" style="color: #1f497d;"&gt;and particularly &lt;A href="http://www.sec.gov/Archives/edgar/data/1305294/000119312516481915/qlik-20151231.xml"&gt;http://www.sec.gov/Archives/edgar/data/1305294/000119312516481915/qlik-20151231.xml&lt;/A&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="margin-left: .5in;"&gt;Suggestion 2: Why not use one of the migration tools, e.g. open source tools explained here :&lt;/P&gt;&lt;P style="margin-left: .5in;"&gt;&lt;A href="https://www.xbrl.org/view/tools-and-services/"&gt;https://www.xbrl.org/view/tools-and-services/?&lt;/A&gt;&lt;/P&gt;&lt;P style="margin-left: .5in;"&gt;Export first to excel then create XBRL format&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="text-indent: 0.5in;"&gt;&lt;STRONG&gt;Also see this conversation I found:&lt;/STRONG&gt;&lt;/P&gt;&lt;P style="text-indent: 0.5in; padding-left: 60px;"&gt;I’ve had a closer look at QvExcel, and concluded that this is the only practical tool for populating the CoreFiling &lt;A href="http://www.corefiling.com/products/seahorse/"&gt;http://www.corefiling.com/products/seahorse/&lt;/A&gt; spreadsheets with QlikView data for subsequent export to XBRL. The cells of their spreadsheet templates can be populated with expressions such as&lt;/P&gt;&lt;P style="text-indent: .5in;"&gt;&lt;/P&gt;&lt;P style="text-indent: .5in;"&gt;=QVExcel.qve(&amp;nbsp; "sum({$&amp;lt;[Nominal Code]={'&amp;gt;4999&amp;lt;6099'}&amp;gt;}[Actual Month])"&amp;nbsp; )&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="padding-left: 60px;"&gt;which actually means Give me the sum of Monthly Actuals for all Nominal Codes between 4999 and 6099. There are several ways of specifying those ranges of Account Codes from the Chart of Accounts, and these are shown in examples downloadable from &lt;A href="http://www.qvexcel.com/features"&gt;http://www.qvexcel.com/features&lt;/A&gt;. Excel would also be familiar to and probably preferred by any Accountant trying to construct their XBRL external reports, so reduces resistance to introducing new technology.&lt;/P&gt;&lt;P style="padding-left: 60px;"&gt;&lt;/P&gt;&lt;P style="padding-left: 60px;"&gt;&lt;IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/141773_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Mon, 24 Oct 2016 18:37:27 GMT</pubDate>
    <dc:creator>Caroline_Sheldon</dc:creator>
    <dc:date>2016-10-24T18:37:27Z</dc:date>
    <item>
      <title>Loading XBRL data into QlikSense / QlikView</title>
      <link>https://community.qlik.com/t5/QlikView/Loading-XBRL-data-into-QlikSense-QlikView/m-p/1207643#M1236991</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Dear all,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I was reading in some old threads that QlikView is able to read XBRL data through connectors, however no details were ever given. I was not able to find a solution through googling either...so I am kind of stuck and hopeless that XBRL is actually supported on QlikView. &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Can you point me to a supplier or solution?&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 26 Jan 2026 16:26:21 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Loading-XBRL-data-into-QlikSense-QlikView/m-p/1207643#M1236991</guid>
      <dc:creator />
      <dc:date>2026-01-26T16:26:21Z</dc:date>
    </item>
    <item>
      <title>Re: Loading XBRL data into QlikSense / QlikView</title>
      <link>https://community.qlik.com/t5/QlikView/Loading-XBRL-data-into-QlikSense-QlikView/m-p/1207644#M1236994</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hello,&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;Please see below:&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="margin-left: .5in;"&gt;&lt;SPAN lang="EN-AU" style="color: #1f497d;"&gt;Suggestion 1: Indeed, I’ve looked into how feasible XBRL ingestion and production are from Qlik products, and it’s extremely difficult. XBRL documents require a LOT of metadata to be available for tagging the financial data correctly. Every country has its own standard for XBRL schemas, and they change periodically. After discussions with &lt;A href="https://www.corefiling.com/"&gt;https://www.corefiling.com/&lt;/A&gt; in 2014 I concluded that Excel integration is key, and &lt;A href="http://www.qvexcel.com/"&gt;http://www.qvexcel.com/&lt;/A&gt; might be useful for extracting Qlik data and preparing it within Excel for production of XBRL using a specialist tool.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="margin-left: .5in;"&gt;&lt;SPAN lang="EN-AU" style="color: #1f497d;"&gt;You can see example XBRL taxonomy and filings for US Listed Companies at &lt;A href="http://xbrl.sec.gov/"&gt;http://xbrl.sec.gov/&lt;/A&gt;, &lt;/SPAN&gt;&lt;/P&gt;&lt;P style="margin-left: .5in;"&gt;&lt;SPAN lang="EN-AU" style="color: #1f497d;"&gt;for example Qlik’s 2015 results at &lt;A href="http://www.sec.gov/Archives/edgar/data/1305294/000119312516481915/0001193125-16-481915-index.htm"&gt;http://www.sec.gov/Archives/edgar/data/1305294/000119312516481915/0001193125-16-481915-index.htm&lt;/A&gt; &lt;/SPAN&gt;&lt;/P&gt;&lt;P style="margin-left: .5in;"&gt;&lt;SPAN lang="EN-AU" style="color: #1f497d;"&gt;and particularly &lt;A href="http://www.sec.gov/Archives/edgar/data/1305294/000119312516481915/qlik-20151231.xml"&gt;http://www.sec.gov/Archives/edgar/data/1305294/000119312516481915/qlik-20151231.xml&lt;/A&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="margin-left: .5in;"&gt;Suggestion 2: Why not use one of the migration tools, e.g. open source tools explained here :&lt;/P&gt;&lt;P style="margin-left: .5in;"&gt;&lt;A href="https://www.xbrl.org/view/tools-and-services/"&gt;https://www.xbrl.org/view/tools-and-services/?&lt;/A&gt;&lt;/P&gt;&lt;P style="margin-left: .5in;"&gt;Export first to excel then create XBRL format&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="text-indent: 0.5in;"&gt;&lt;STRONG&gt;Also see this conversation I found:&lt;/STRONG&gt;&lt;/P&gt;&lt;P style="text-indent: 0.5in; padding-left: 60px;"&gt;I’ve had a closer look at QvExcel, and concluded that this is the only practical tool for populating the CoreFiling &lt;A href="http://www.corefiling.com/products/seahorse/"&gt;http://www.corefiling.com/products/seahorse/&lt;/A&gt; spreadsheets with QlikView data for subsequent export to XBRL. The cells of their spreadsheet templates can be populated with expressions such as&lt;/P&gt;&lt;P style="text-indent: .5in;"&gt;&lt;/P&gt;&lt;P style="text-indent: .5in;"&gt;=QVExcel.qve(&amp;nbsp; "sum({$&amp;lt;[Nominal Code]={'&amp;gt;4999&amp;lt;6099'}&amp;gt;}[Actual Month])"&amp;nbsp; )&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="padding-left: 60px;"&gt;which actually means Give me the sum of Monthly Actuals for all Nominal Codes between 4999 and 6099. There are several ways of specifying those ranges of Account Codes from the Chart of Accounts, and these are shown in examples downloadable from &lt;A href="http://www.qvexcel.com/features"&gt;http://www.qvexcel.com/features&lt;/A&gt;. Excel would also be familiar to and probably preferred by any Accountant trying to construct their XBRL external reports, so reduces resistance to introducing new technology.&lt;/P&gt;&lt;P style="padding-left: 60px;"&gt;&lt;/P&gt;&lt;P style="padding-left: 60px;"&gt;&lt;IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/141773_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 24 Oct 2016 18:37:27 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Loading-XBRL-data-into-QlikSense-QlikView/m-p/1207644#M1236994</guid>
      <dc:creator>Caroline_Sheldon</dc:creator>
      <dc:date>2016-10-24T18:37:27Z</dc:date>
    </item>
    <item>
      <title>Re: Loading XBRL data into QlikSense / QlikView</title>
      <link>https://community.qlik.com/t5/QlikView/Loading-XBRL-data-into-QlikSense-QlikView/m-p/1207645#M1236997</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Il me semble que la question initiale était pour l'inverse : Exploiter un XBRL dans QlikView&amp;nbsp; &lt;/P&gt;&lt;P&gt;Je recherche cette problématique&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 12 Jan 2018 15:21:55 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Loading-XBRL-data-into-QlikSense-QlikView/m-p/1207645#M1236997</guid>
      <dc:creator>jleraille</dc:creator>
      <dc:date>2018-01-12T15:21:55Z</dc:date>
    </item>
  </channel>
</rss>

