topic Export to excel whith formulas in App Development

topic Export to excel whith formulas in App Development https://community.qlik.com/t5/App-Development/Export-to-excel-whith-formulas/m-p/1692288#M52886 <P>Hi everyone,</P><P>I would like to export to excel from QlikSence to a specific format.</P><P>In my app, i've a cross-table like this</P><TABLE border="1" width="100%"><TBODY><TR><TD width="25%"> </TD><TD width="25%">Working directory 1</TD><TD width="25%">totals</TD><TD width="25%">Working directory 2</TD></TR><TR><TD width="25%">totals</TD><TD width="25%">12</TD><TD width="25%">12</TD><TD width="25%">X</TD></TR><TR><TD width="25%">ID1</TD><TD width="25%">6</TD><TD width="25%"> </TD><TD width="25%">X</TD></TR><TR><TD width="25%">ID2</TD><TD width="25%">6</TD><TD width="25%"> </TD><TD width="25%">X</TD></TR><TR><TD width="25%">Totals</TD><TD width="25%">3</TD><TD width="25%">3</TD><TD width="25%"> </TD></TR><TR><TD width="25%">ID3</TD><TD width="25%">3</TD><TD width="25%"> </TD><TD width="25%"> </TD></TR></TBODY></TABLE><P> </P><P>i would like to have somthing like this and export to excel</P><TABLE border="1" width="100%"><TBODY><TR><TD width="25%"> </TD><TD width="25%">Working directory 1</TD><TD width="25%">totals</TD><TD width="25%">Working directory 2</TD></TR><TR><TD width="25%">totals</TD><TD width="25%">12</TD><TD width="25%">12</TD><TD width="25%">X</TD></TR><TR><TD width="25%">ID1</TD><TD width="25%">6</TD><TD width="25%"> </TD><TD width="25%">X</TD></TR><TR><TD width="25%">ID2</TD><TD width="25%">6</TD><TD width="25%"> </TD><TD width="25%">X</TD></TR><TR><TD width="25%">%</TD><TD width="25%">"ratio 15/6"</TD><TD width="25%"> </TD><TD width="25%"> </TD></TR><TR><TD width="25%">Totals</TD><TD width="25%">3</TD><TD width="25%">3</TD><TD width="25%"> </TD></TR><TR><TD width="25%">ID3</TD><TD width="25%">3</TD><TD width="25%"> </TD><TD width="25%"> </TD></TR><TR><TD width="25%"> </TD><TD width="25%">"ratio 15/3"</TD><TD width="25%"> </TD><TD width="25%"> </TD></TR></TBODY></TABLE><P> </P><P>is there an easy way to do this?</P><P>Thanks.</P><P> </P> Thu, 09 Apr 2020 09:35:45 GMT CHEWBAKA 2020-04-09T09:35:45Z Export to excel whith formulas https://community.qlik.com/t5/App-Development/Export-to-excel-whith-formulas/m-p/1692288#M52886 <P>Hi everyone,</P><P>I would like to export to excel from QlikSence to a specific format.</P><P>In my app, i've a cross-table like this</P><TABLE border="1" width="100%"><TBODY><TR><TD width="25%"> </TD><TD width="25%">Working directory 1</TD><TD width="25%">totals</TD><TD width="25%">Working directory 2</TD></TR><TR><TD width="25%">totals</TD><TD width="25%">12</TD><TD width="25%">12</TD><TD width="25%">X</TD></TR><TR><TD width="25%">ID1</TD><TD width="25%">6</TD><TD width="25%"> </TD><TD width="25%">X</TD></TR><TR><TD width="25%">ID2</TD><TD width="25%">6</TD><TD width="25%"> </TD><TD width="25%">X</TD></TR><TR><TD width="25%">Totals</TD><TD width="25%">3</TD><TD width="25%">3</TD><TD width="25%"> </TD></TR><TR><TD width="25%">ID3</TD><TD width="25%">3</TD><TD width="25%"> </TD><TD width="25%"> </TD></TR></TBODY></TABLE><P> </P><P>i would like to have somthing like this and export to excel</P><TABLE border="1" width="100%"><TBODY><TR><TD width="25%"> </TD><TD width="25%">Working directory 1</TD><TD width="25%">totals</TD><TD width="25%">Working directory 2</TD></TR><TR><TD width="25%">totals</TD><TD width="25%">12</TD><TD width="25%">12</TD><TD width="25%">X</TD></TR><TR><TD width="25%">ID1</TD><TD width="25%">6</TD><TD width="25%"> </TD><TD width="25%">X</TD></TR><TR><TD width="25%">ID2</TD><TD width="25%">6</TD><TD width="25%"> </TD><TD width="25%">X</TD></TR><TR><TD width="25%">%</TD><TD width="25%">"ratio 15/6"</TD><TD width="25%"> </TD><TD width="25%"> </TD></TR><TR><TD width="25%">Totals</TD><TD width="25%">3</TD><TD width="25%">3</TD><TD width="25%"> </TD></TR><TR><TD width="25%">ID3</TD><TD width="25%">3</TD><TD width="25%"> </TD><TD width="25%"> </TD></TR><TR><TD width="25%"> </TD><TD width="25%">"ratio 15/3"</TD><TD width="25%"> </TD><TD width="25%"> </TD></TR></TBODY></TABLE><P> </P><P>is there an easy way to do this?</P><P>Thanks.</P><P> </P> Thu, 09 Apr 2020 09:35:45 GMT https://community.qlik.com/t5/App-Development/Export-to-excel-whith-formulas/m-p/1692288#M52886 CHEWBAKA 2020-04-09T09:35:45Z