Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
prasadcm
Contributor II

Macro to export to excel depending on Column Data

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


My table would be something like below

Capture1.PNG

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

Capture2.PNG

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

1 Reply
HirisH_V7
Honored Contributor

Re: Macro to export to excel depending on Column Data

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

HirisH
“Aspire to Inspire before we Expire!”