topic Re: Excel with many fields to crosstable in App Development https://community.qlik.com/t5/App-Development/Excel-with-many-fields-to-crosstable/m-p/1793256#M62101 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/79918">@Alarkis</a>can you share the expected output from this file ?</P> Mon, 22 Mar 2021 08:56:42 GMT Taoufiq_Zarra 2021-03-22T08:56:42Z Excel with many fields to crosstable https://community.qlik.com/t5/App-Development/Excel-with-many-fields-to-crosstable/m-p/1793200#M62097 <P>I have an excel with many fields it has couple of descriptive fields and 2 value fields ( YearQuarter Target and Qaurter values) is it possible to create a crosstable without modifying the excel?</P><P>What it look when in script:</P><P>CrossKPIs:<BR />//CrossTable(YEAR,QUARTER)<BR />LOAD<BR />ACTION,<BR />NAME,<BR />DESCRIPTION,<BR />Calculation,<BR />Format,<BR />Target 2020,<BR />Q1,<BR />Q2,<BR />Q3,<BR />Q4,<BR />Target 2021,<BR />Q11,<BR />Q21,<BR />Q31,<BR />Q41,<BR />Time_Frame</P><P>Attached example.</P> Sat, 16 Nov 2024 17:22:12 GMT https://community.qlik.com/t5/App-Development/Excel-with-many-fields-to-crosstable/m-p/1793200#M62097 Alarkis 2024-11-16T17:22:12Z Re: Excel with many fields to crosstable https://community.qlik.com/t5/App-Development/Excel-with-many-fields-to-crosstable/m-p/1793256#M62101 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/79918">@Alarkis</a>can you share the expected output from this file ?</P> Mon, 22 Mar 2021 08:56:42 GMT https://community.qlik.com/t5/App-Development/Excel-with-many-fields-to-crosstable/m-p/1793256#M62101 Taoufiq_Zarra 2021-03-22T08:56:42Z