Macro to export to excel depending on Column Data

[prasadcm]

I want to export  qlikview object (Straight table) to an excel sheet

My table would be something like below

Now if Currency is equal to Tran Curr(USD) then it should be exported as it is(Trans Curr & Cal Amount excluded), but if different then

as below

with Trans Curr & Cal amount in next row with Row No as 1.1

[HirisH_V7]

Hi,

you can create two straight tables with those logic's and call them accordingly to export to excel button.Provide some sample app or data.

Qlikview to excel export macro

HTH,

-Hirish