Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
ttal7878
Creator
Creator

Copy a Straight table into Excel file

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



2 Replies
Anil_Babu_Samineni

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Clever_Anjos
Employee
Employee

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

Capturar.PNG