Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vishalgoud
Creator III
Creator III

which is better View or Table in DB to implement Direct Discovery in Qv. ?

Hi All ,

For the first time started working on DD in Qlikview. Lot of doubts are there about different parameters like making connection and extracting the data and performance is another imp thing to consider.

we are connecting with a SQL DB ,where there are huge number around 5000 IDs are there, we are just taking 10 IDs info for this POC purpose.

So ETL team Decided to create a view ,which will take much time. we are in confusion to proceed further , which is good actually creating a view with 10 IDs / creating a table with 10 IDs....??

Please suggest as well as correct us if both are not apt...

My assumption : In DD whenever we reopen the app it will give the latest records from DB.

Ex : means at 10 am no of records are 12000 and if we close and open the app again @10:05 am then it will be 12050 i.e 50 are the latest .

Best Regards,

Dhasharadh.

1 Reply