topic Re: Load/Reuse/Extract Straight Table Data in QlikView

Load/Reuse/Extract Straight Table Data

Sun, 03 May 2015 07:41:12 GMT

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.

Re: Load/Reuse/Extract Straight Table Data

petter — Sun, 03 May 2015 08:21:13 GMT

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?

Re: Load/Reuse/Extract Straight Table Data

Sun, 03 May 2015 15:53:28 GMT

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.

Re: Load/Reuse/Extract Straight Table Data

Anonymous — Sun, 03 May 2015 16:03:51 GMT

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

Re: Load/Reuse/Extract Straight Table Data

Mon, 04 May 2015 12:56:05 GMT

Noted with Thanks.

- Sajjad.