Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Load/Reuse/Extract Straight Table Data

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.

4 Replies
petter
Partner - Champion III
Partner - Champion III

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?

Not applicable
Author

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.

Anonymous
Not applicable
Author

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

Not applicable
Author

Noted with Thanks.

- Sajjad.