topic Is there an option to display a limited data set while developing? in QlikView

Is there an option to display a limited data set while developing?

Wed, 30 Jun 2010 17:21:26 GMT

I have a number of large data sets (20+ million rows) that have been loaded into the application. I'm wondering if while I'm developing charts etc if there is a way to have the application only use a subset of the overall data in order to improve development time (i.e. not having to wait for charts to load). Once I'm done, and/or I' ready to test the full data set after the chart is developed I can then go back and run against the full volume.

Thanks,

Dan

Is there an option to display a limited data set while developing?

Wed, 30 Jun 2010 17:23:48 GMT

Hi Dan,

can you just load a subset of the source data?

Tony

Is there an option to display a limited data set while developing?

Wed, 30 Jun 2010 17:24:53 GMT

When you run the load script you can execute a limited load of x number of rows (you input the number of rows.

The only thing to be careful of is that if you have multiple dimensions joined to a fact, you need to be sure that you're limited load is enough to bring in all of the dimension values, otherwise your model ends up having some problems.

Good luck,

Is there an option to display a limited data set while developing?

Anonymous — Wed, 30 Jun 2010 17:36:43 GMT

We have the same problem when developing. Once we have the data cloud correct, we will typically make selections down to a level that is reasonable for development and then reduce the data to those selections.

File --> Reduce Data --> Keep Possible Values.

Then all you have to do is reload to get all the data back.

Is there an option to display a limited data set while developing?

Wed, 30 Jun 2010 18:45:18 GMT

As Nigel said, I would go to the debug mode and load a limited number of rows. That is also a best pratice to validate the script sintaxe and database connections.

Is there an option to display a limited data set while developing?

hector — Wed, 30 Jun 2010 18:50:40 GMT

Hi, use First command

Ex:

First 1000
SQL/Load Statement

;

Rgds