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?
Last Comment
Rob
Set the columns you don't want to hidden. Export to Excel. You're wanting to script this or do it manually?
ASKER
Well its needs to be scripted bc of the way the report needs to look
needs to be scripted bc of the way the report needs to lookI 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.
ASKER
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
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Software
Software is any set of instructions that directs a computer to perform specific tasks or operations. Computer software consists of programs, libraries and related non-executable data (such as documentation). Computer software is non-tangible, contrasted with computer hardware, which is the physical component of computers. Software written in a machine language is known as "machine code". However, in practice, software is usually written in high-level programming languages than machine language. High-level languages are translated into machine language using a compiler or interpreter or a combination of the two.
43K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
