topic Re: Copy a Straight table into Excel file in QlikView

Copy a Straight table into Excel file

ttal7878 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Community,
Is there an option to copy a Straight table From qvw into Excel file, and the formulas used in the qvw will also apply to Excel.

The reason I'm asking,

There is a request from one of our users, to copy the 'Straight table' to Excel file and manually change some of the data shown in the 'Straight table', and when the user re-enters the data, the formulas will change accordingly.

Thanks in advance

Re: Copy a Straight table into Excel file

Anil_Babu_Samineni — Tue, 22 Aug 2017 14:26:27 GMT

As i am working more than few years with Qlik. I would say NO

Re: Copy a Straight table into Excel file

Clever_Anjos — Tue, 22 Aug 2017 14:40:29 GMT

There´s a small 'hack' that could solve your needs.

If your expressions are simple, you can create an expression returning the Excel desired formula.

So when you copy and paste your data into an Excel file, your string would be evaluated

Please not the straight table and the result