topic Re: How to save expression data created in straight table as a QVD File. in QlikView

How to save expression data created in straight table as a QVD File.

Fri, 26 Jul 2013 19:13:55 GMT

Dear Frieds

I have created a straight table calculating the standard deviation, Control limit, average etc. I want to export this data into a QVD file.

Please let me know how to go about it.

Rahul Kale

Re: How to save expression data created in straight table as a QVD File.

Sat, 27 Jul 2013 01:51:11 GMT

Hi Rahul,

Check this thread:

http://community.qlik.com/message/313121#313121

So your macro would like this:

sub straighttoqvd
set obj = ActiveDocument.GetSheetObject("CH02")
obj.ExportEx "straight.qvd",4
end sub

or using the serverside function like stated in the link.

Hope this helps.

Re: How to save expression data created in straight table as a QVD File.

Sat, 27 Jul 2013 10:30:57 GMT

hi JP

It works!

Do you how can we automate it so that with every reload the macro is executed automatically.

Pls share an example

Re: How to save expression data created in straight table as a QVD File.

Sat, 27 Jul 2013 12:06:08 GMT

Sure,

Go to Settings > Document Properties > Triggers tab > Document Event Triggers > On Post Reload > Add Actions > Add > External > Run Macro > type the macro name in the field.

You may need to add more than 1 action to be executed before running the macro, like clearing the selections, or applying certain selections. So just add them in the same "On Post Reload" trigger.

Reload (either manually/batch/server schedule) and your qvd will be updated

Re: How to save expression data created in straight table as a QVD File.

Mon, 05 Aug 2013 20:24:26 GMT

Hello,

Can someone please help me to concatenate the chart data with today's date into a qvd/ excel file.

I am trying to store the numbers that are calculated/refreshed daily into a qvd file.

Above post helps me make a qvd from post-reload trigger, butu how to concatenate it daily with today() function.

Thanks for your help!