Macro to export to excel depending on Column Data

prasadcm — Fri, 22 Jan 2016 06:50:15 GMT

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

Re: Macro to export to excel depending on Column Data

HirisH_V7 — Fri, 22 Jan 2016 14:26:24 GMT

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.

HTH,

-Hirish