Avatar of cbrune
cbrune asked on

loop through a pivot table that is stored in memory from qlikview and exporting certain columns into excel?

loop through a pivot table that is stored in memory from qlikview and exporting certain columns into excel?
VB ScriptSoftware

Avatar of undefined
Last Comment
Rob

8/22/2022 - Mon
Rob

Set the columns you don't want to hidden.  Export to Excel.  You're wanting to script this or do it manually?
ASKER
cbrune

Well its needs to be scripted bc of the way the report needs to look
Rob

needs to be scripted bc of the way the report needs to look
I don't follow you on this...

Can you explain what you are trying to achieve?  
What are the reasons for exporting to Excel in the first place.  
Why do you not just have another pivot table with only the columns you want with an Export to Excel button on the caption bar?

If I have a good idea what you're trying to achieve I can suggest how to get there.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
ASKER
cbrune

bc the way they want the report in excel.. they want one sheet to be the pivot table and other sheets are summaries based on it
ASKER CERTIFIED SOLUTION
Rob

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question