topic Including formulas into Excel Export in QlikView

Including formulas into Excel Export

Thu, 07 Jun 2012 13:40:19 GMT

Hi everyone,

I got a nut case to expose, here's the thing :

I want to export a tab chart into excel. But, before the export end, Qview must add an expression (Column A/ Column B) into the exported file .

After, users would possibly change the datas in the exported file, so I'd like to have the expression included into the formula in excel export.

I don't even know if that's possible...

Wish you the best

Will

m_woolf — Thu, 07 Jun 2012 14:56:40 GMT

This can be done with a macro.

Mon, 11 Jun 2012 14:24:45 GMT

I thought so,

But even with API guide, I really need help to establish something like this.

What would be the different steps?