This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
My query with many CTEs used to work fine, but the data loading is now stuck at the same place.
Here is the last several lines in the log file.
6/29/2018 8:16:47 AM: 1401 )
6/29/2018 8:16:47 AM: 1402 select *
6/29/2018 8:16:47 AM: 1403 from HM_ModifierDTT
6/29/2018 8:17:21 AM: 5 fields found: PAT_ID, HM_MODIFIERID3, USERID, HM_AUDITACTION, HM_MODIFIERDTT, 10,132 lines fetched
Any suggestions are welcome.
By the way, The Qlik desktop I am using is 11.20.13607.0 SR17 64-bit. The database is Oracle 11g.
there is no issue with the log lines shared above.. maybe share the log file ?
Here is the log file. Thanks
do you have +11k of sql code lines ??
did you try the same request without qv
directly on the db ?
The query is about 842 lines. I used Include like below. The same query might load multiple times.
The query in DB works fine. It only takes about 10 seconds to return first 50 rows.
Shared query might not be a good approach. Is QVD a better way?
as you write : 10 secs but for 50 rows
don't forget qlik retrieves all rows
so if you try to retrieve all rows , how long does it take ?
About the same when exporting all the records from that query to Excel - less than 10 seconds.