Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Jack
Summarising what I think you have:
For starter in your load script you could load:
Then in your dashboard create a Chart Object of type Straight Table with:
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
Hello Bill,
Ok thanks, wil start doing this and let you know
Regards Jack