Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
I have created a Straight Table of Customer Data based on some Selection (like Year, Quarter, Product Segment etc.) and with the resultant Data set I want to further process with other Source Tables and generate further presentations like Bar Chart, Pivot Chart etc.
Is it possible have those Straight Table Customer Data as a Table (QVD, Inline Table or any other form like Excel) so that on the fly I can re-use those Data for further presentation?
Appreciate any responses.
Sajjad.
Yes that is possible to do - but let me first point out that your requirements might be perfectly met by just using bookmarks. Have you looked into that?
If not - bookmarks can store selections and searches that leads to selections.
In many charts ("presentation") you can then reference this bookmark as a named entity in a set expression like this:
Sum( { BM_My_Selections } Sales )
Then you can anytime reuse your selections as a basis for further calculations.
If on the other hand this does not meet your requirements - please explain a little bit further what they are?
Well Mr. Peter,
My requirement is - to dump the Straight Table's Data into a Temporary file/table in run-time and re-use those Data-set with other Source Data Table and create further Charts or Other Presentations.
Hope this clarifies.
Thanks again,
- Sajjad.
Sajjad,
Take these requirements with a grain of salt. Requirements should be describing the result (what to achieve) rather than the process (how to do that). I don't see how the dumping is helpful here.
In the QlikView world, the selection you make (Year, Quarter, Product Segment etc.) affect not only the straight table, but all objects, unless you take additional measures to break this. No "dumping" needed.
Maybe I didn't get your request right?
Regards,
Michael
Noted with Thanks.
- Sajjad.