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

[#1]

Help needed in addition to discussion- http://community.qlik.com/message/373043

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, but how to concatenate it daily with today() function.

Thanks for your help!

[#2]

Hello,

You can adopt the same macro as in the other thread.

But in your straight table, just add an expression as Today().

If you wish not to display it, go to the Presentation tab, select it and click on "Hide Column".

The macro will export it too even if it's hidden.

Hope that's what you were looking for.

[#3]

Thanks for your reply.

I tried that but it is not concatenating the data. I would like to add data daily to this qvd based on reload date.