Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I would like to schedule export to excel pivot table. In the pivot table I created Expressions (Calculated Formula) that there are NOT in
the table Qlik (or should play). I'm forced to write a macro? with vba code?
thank in advance
Ettore
Hi,
To export pivot table in to excel, Qlikview has inbuilt functionality.
Please refer this image.
To enable this, you need to go to property, under caption tab you will find "Send to Excel" option.
-- Regards,
Vishal Waghole
Hi,
To export pivot table in to excel, Qlikview has inbuilt functionality.
Please refer this image.
To enable this, you need to go to property, under caption tab you will find "Send to Excel" option.
-- Regards,
Vishal Waghole
Thank you, your claim is correct.
but I would like to schedule this export not manually but automatically. I have to create a macro?
the report is refreshed from a night schedule, and I would like to generate excel at the time of the update. I would not open the document and manually export
Thank in advance
Ettore
Hi,
If is is single simple table you can store the same in xls while loading.
Regards
ASHFAQ
Thank you,
but In the pivot table I created Expressions (Calculated Formula) that there are NOT in
the table Qlik (or should play). if I export the table i NOT export expressions.
I'm forced to write a macro? with vba code?
thank in advance
Ettore