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

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

Mon, 05 Aug 2013 20:27:00 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, but how to concatenate it daily with today() function.

Thanks for your help!

Mon, 05 Aug 2013 21:25:38 GMT

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.

Mon, 05 Aug 2013 21:58:30 GMT

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.