Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, dears!
I am currently involeved into one interesting project where customer is interested in DIRECT QUERY in Qlik Sense. I faced with some tough issues. There are 5 fact table in customer's data base which should be loaded through DIrect Query in ONE App of Qlik Sense. Eache table has more then 6 million rows. I tried use different kinds of 'join' but the time of respond is huge and sometimes my app crashed, nothing was not working.
1. So could you be so kind and clarify how Direct Query works, where and when are queries culculated ?
2. Should we make one huge flat table from our five fact tables in our data base?
3. Will Direct quiery work if fact table containes more then 150 attributes?
4. Why do we need reload script when we do correction in our script?
5. How often should we reload app with Direct Quiery?
6. Where i can read more information about direct quiery except qlik.help.com?
7. Is "dynamic views" in Qlik Sense the same as Direct Query?
8. What else can i use insted of Direct Query to echive real time reloading of data?
Hi @lena2a2a2
Very interesting question, I found this document in the Qlik Community Direct Query or Direct Discovery ; which contains a very interesting and illustrative PDF document I found enlightening, (I attached the PDF to this reply); based on reading that document:
1. So could you be so kind and clarify how Direct Query works, where and when are queries calculated ?
2. Should we make one huge flat table from our five fact tables in our data base?
3. Will Direct query work if fact table contains more then 150 attributes?
5. How often should we reload app with Direct Query?
6. Where i can read more information about direct query except qlik.help.com?
7. Is "dynamic views" in Qlik Sense the same as Direct Query?
8. What else can i use instead of Direct Query to achieve real time reloading of data?
It is a lot of fun! One last thing, read the Direct Discovery PDF, there are some suggestions-warnings on when to implement this feature.
Hope this helps!
Hi @lena2a2a2
Very interesting question, I found this document in the Qlik Community Direct Query or Direct Discovery ; which contains a very interesting and illustrative PDF document I found enlightening, (I attached the PDF to this reply); based on reading that document:
1. So could you be so kind and clarify how Direct Query works, where and when are queries calculated ?
2. Should we make one huge flat table from our five fact tables in our data base?
3. Will Direct query work if fact table contains more then 150 attributes?
5. How often should we reload app with Direct Query?
6. Where i can read more information about direct query except qlik.help.com?
7. Is "dynamic views" in Qlik Sense the same as Direct Query?
8. What else can i use instead of Direct Query to achieve real time reloading of data?
It is a lot of fun! One last thing, read the Direct Discovery PDF, there are some suggestions-warnings on when to implement this feature.
Hope this helps!
Thanks!
Hi @lena2a2a2
My YouTube featured a Qlik Video on Dynamic View, this is the first time I saw a DV in action, very interesting and they could be a way to implement near realtime or realtime solutions! Dynamic Views
Hope this helps,