topic Re: How to store a dataset in QV in QlikView

How to store a dataset in QV

Thu, 21 Jun 2012 09:23:49 GMT

Hi!

How do I store the result from a selection at a certain point in time? I know that you can use bookmarks to store the selection you have done but this doesn't store the data (the result set) at a certain point in time.

As an example, the customer wants to store "a picture of the situation" every week or every month. . I have not worked with reports and maybe this is the way the problem is solved? I mean, are reports stored with its data and are possible to use? I guess that you are building a report template and when you run the report, the recent updates are populated into the report but are the data also stored so you can in some way go back after, for example a year, and check how the outcome was for/in the end of June 2011 when you are in June 2012?

So my question is - can you solve this problem using:

a) Report and/or

b) By using an ordinary dashboard in QV where you have stored the situation back in time?

Rgds

Fredrik

Re: How to store a dataset in QV

m_woolf — Thu, 21 Jun 2012 10:02:03 GMT

If you are using the IE Plugin, you can write data out to Excel or to a database by a macro.

Re: How to store a dataset in QV

Thu, 21 Jun 2012 10:11:28 GMT

OK, so you are not able to solve this within Qlikview? If not, it seems strange that they not have found a solution for this which seems to be a very common problem which many users.

The result would be that you have one qlikview dashboard were you have an instant view and then you would store data at certain points in time into a Datawarehouse (DW) and then have a second QV-dashboard/solution collecting data from that DW to show more or less the same data.

/Fredrik

Re: How to store a dataset in QV

m_woolf — Thu, 21 Jun 2012 10:37:32 GMT

You might want to read this thread:

http://community.qlik.com/thread/12769?start=15&tstart=0

Re: How to store a dataset in QV

Thu, 21 Jun 2012 14:20:26 GMT

Hi again!

Thank you for your answers. Can you please tell me more about the IE Plugin?

Rgds

Fredrik