Macro & Load Data

Tue, 26 May 2009 22:54:01 GMT

Hi there,

I wonder if someone already have down something in order to manage really big data.

I mean that i would like to do a qlikview app that allow users to select a dataset before loading.

The way i try to do this is the following:

1/ I have a load statement which just get the distinct value that can be use for some fields as those fields constitue the filter.

2/ I've made a sheet on qlikview where users can select the dataset, e.g. for exemple a date range ...

Now how don't know how to proceed. In fact, i am thinking about doing a macro which will do the load statement (as the same way as in the script) but i don't know if it was possible.

Is it possible? Has someone already done something in this way ? Are there others slutions?

Thanks for your help.

Macro & Load Data

Oleg_Troyansky — Tue, 26 May 2009 23:08:27 GMT

HI,

an attempt to get user input and load the relevant data is the most common first experience for new developers coming into QlikView from other environments - this is what we're all used to do with report writers...

In QlikView, you never do it this way. Even with huge data sets, you end up loading all the data and you let the user select what they want AFTER the load.

Now, if your data set is GIANT - and I mean the size that your hardware certainly can't process in one piece, than you have to think of a compromise:

you can increase your level of aggregation and not offer the most detailed piece of information in every document.
you can decrease the timeframe of your analysis - for example, you can offer most detailed information for the last 3 months only and more aggregate information for the last 3 years (find the formula that makes sense for your business)
you can slice the data based on something that makes sense - like a Division, or a market segment or something else that you users might be interested in separately. Load separate documents for each slice and let the users select the document that they want

Back to your original question - if your data is truly BIG, macro is certainly not an option (it's too slow). Any load (even the super-fast QVD load) would be too slow if your users are waiting in front of the screen to get the results. You have to find a way to pre-load the data and then let users play with it.

Having said all that - there is an example of loading the data based on user input. Download "QlikView Explorer" from "Share QlikViews", and you'll see a couple of different examples of conditional load.

cheers,

Oleg

topic Macro & Load Data in QlikView

Macro & Load Data

Macro & Load Data