Reading a large table into a single result

[Anonymous]

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

[Anonymous]

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

[Anonymous]

Hello Bill,

Ok thanks, wil start doing this and let you know

Regards Jack