topic Reading a large table into a single result in QlikView

Reading a large table into a single result

Anonymous — Wed, 27 Nov 2013 19:24:07 GMT

Starting to buikd output in Qlikview with source a large table

before starting to build a test is the question if the following would work in a acceptable time

I read using a single key from a datebase wich will have aprox 200000 records, and aprox 1400 hits with

this: Select * from sales_naw where Country = 'US'

The total read should return as a single sum(sales)

Now in VB issuing this call i read until eof(sales_naw) and count the sales to a single amount,

takes aprox 15 seconds.

What would be the time in a qlikview design? and aceptable ?

Regards

Re: Reading a large table into a single result

Anonymous — Wed, 27 Nov 2013 19:39:27 GMT

Jack

Summarising what I think you have:

Source table 200,000 rows [I guess from a database]
Dimension of Country [probably more dimensions like Sale Date ]
Facts of Sales [probably more facts]

For starter in your load script you could load:

Country
Sales

Then in your dashboard create a Chart Object of type Straight Table with:

Dimension Country
Expression Sum(Sales)

You should see the Sales for each Country.

Then create a List Box for Country.

Then you'll be able to select Countries.

Next start adding more dimensions and facts fields into your load script and add them into your existing objects / new objects.

At a complete guess the load script run time will be measured in seconds, not minutes. But selecting Countries in the dashboard and seeing their Sales should near instantaneous.

Best Regards, Bill

Re: Reading a large table into a single result

Anonymous — Wed, 27 Nov 2013 19:42:12 GMT

Hello Bill,

Ok thanks, wil start doing this and let you know

Regards Jack