Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm getting below error while trying to read data from a HIVE table
20240415T105556.712-0500 Error: QVX_UNEXPECTED_END_OF_DATA: SQL##f - SqlState: 08S01, ErrorCode: 115, ErrorMsg: [Microsoft][Hardy] (115) Connection failed with error: SSL_read: error code: 0
I'm getting this error only while fetching data from a particular table, for rest of the other tables it works fine with same connection.
Can anybody give any pointers to how to debug this? I ran the same query via Hue SQL interface which HIVE provides, the query works fine and I'm able to export whole dataset
Using a SQL Query on a SQL database returns the following data:
With the following result:
But executing the same SQL query into Qlikview returns the following:
toetsOnveranderd - Test with no change
toetsText - Using Text script formula to get text property
toetsJippo - Self help method to force test property
With the following outcome in Qlikview:
It seems that the 'raw' data in the SQL database is 0965 (OneID,toetsOnveranderd)
But the SQL query in SQL returns (0965,965) (?)
And it seems that the script formula "Text" first identify the property is integer makes it a number and the concerts it to text 0965 -> 965 -> "965"
[It must be noted that data input is from multiple sources into the SQL database].
This outcome of the usage of the the text formula vs 'raw' data causes a different result/outcome.
Any idea how to "fix" this?
Buongiorno,
Come eseguire una selezione multipla su più elementi in un campo mediante un Pulsante ? (Azione: Seleziona nel Campo...)
Con Sense si mette il punto e virgola tra un elemento e l'altro, tra apici...ma in View non funziona...
Grazie, Maurizio
Dear All,
Anytime I am sending emails to more than two recipients, the macros would give this error "that "Outlook does not recognize one or more names. " and it would highlight objMail.Send in my code. here is my code:
Sub mSendMail(pdfFilePath)
Dim objOutlk
Dim objMail
Const olMailItem = 0
' Check if Outlook is already running
On Error Resume Next
Set objOutlk = GetObject(, "Outlook.Application")
On Error GoTo 0
' If Outlook is not running, start it
If (objOutlk = "") Then
StartOutlook
' Wait for 5 seconds for Outlook to start
ActiveDocument.GetApplication.Sleep 5000
' Create a new instance of Outlook application
Set objOutlk = CreateObject("Outlook.Application")
End If
' Create a new mail item
Set objMail = objOutlk.createitem(olMailItem)
' Recipient's email address
objMail.To = "example@yahoo.com"
objMail.Cc = "example2@gmail.com"
' Subject of the email
objMail.Subject = "Testing " & Date()
' Body of the email
objMail.HTMLBody = "Body of the email, This is an automatic generated email from QlikView."
' Add attachment (use the generated PDF file)
objMail.Attachments.Add pdfFilePath
' Send the email
objMail.Send
' Release resources
Set objMail = Nothing
Set objOutlk = Nothing
End Sub
if I add BCc to the ' Recipient's email address it would complain :
' Recipient's email address
objMail.To = "example@yahoo.com"
objMail.Cc = "example2@gmail.com"
objMail.BCc = "example3@abc.com" or I added two email to the cc like this
Recipient's email address
objMail.To = "example@yahoo.com"
objMail.Cc = "example2@gmail.com, example7@abc.com" it would say "Outlook does not recognize one or more names. " and it would highlight objMail.Send in my code. here is my code,
Please, what can I do to be sending emails to more than 10recipients at the same time .
Thanks
Hi there.
I have a series of documents which are version numbered, e.g. 5.1, 5.2, ...5.9, 5.10, 5.11 etc.
Any number which ends in a zero is converted to remove the zero (e.g 5.10 becomes 5.1)
I would like two things:
1 - Show numbers as thier original form, e.g. 5.10 should be 5.10
2 - Allow sorting on the field ascending e.g (5.1, 5.2, 5.3, 5.4, 5.5, 5.6, 5.7, 5.8, 5.9, 5.10, 5.11 etc)
Thanks for your help.
Mark.
Hello Everyone,
I have an issue with the Set expression in KPI chart. i'm calculating the percentage in my expression i'm using Parent incident id for this column is having Null values i want to calculate the Null values. but while calculating the t column not considering. please find the below expression
Num(sum({<Goal={'Cpi - Critical - Restore'},ID={'365'},Reported_13Month={1},[Status]={0},[Parent Incident ID]={'Null'}>}[Ticket Count])/sum({<Goal={'Cpi - Critical - Restore'},ID={'365'},Reported_13Month={1},[Parent Incident ID]={'Null()'}>}[Ticket Count]),'##.##%')
please anyone can help me on this.
Hello,
I've some users in Basic user and 7 full user on qlik cloud capacity .
But when a Basic user try to connect in an apps he was directly transform in a full user asked .
We use Microsoft Entra as ID provider and the basic user is in a group how has just a restricted access.
How to block that to avoid the full user asked ?
Best regards
PS: someone know when a basic user we will able to download a table as data and not in jpg ou pdf ?
Wondering about Qlik Talend Data Integration Sessions? There are 11, in addition to all of the Data & Analytics. So meet us in Orlando, June 3 -5.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Join us on April 24th at 10 AM ET for the next Do More with Qlik webinar focusing on Qlik’s Data Integration & Quality solutions.
Your journey awaits! Join us by Logging in and let the adventure begin.
Qlik enables a frictionless migration to AWS cloud by Empresas SB, a group of Chilean health and beauty retail companies employing 10,000 people with 600 points of sale.
Qlik Luminary Stephanie Robinson of JBS USA, the US arm of the global food company employing 70,000 in the US, and over 270,000 people worldwide.
Join one of our Location and Language groups. Find one that suits you today!
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!