Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI
I am trying to call below API
curl -i -k -v -X PUT --header "EnterpriseManager.APISessionID: wCo0_KvjEUFROvfHF5KGrw" --header "Content-Length: 242" https://computer.network.net/attunityenterprisemanager/api/v1/servers/myrepsrv1/def -T "C:\myrepsrv1.json"
I have put my APISessionID and url and its connecting fine. At the end of log message, it says
> Content-Type: application/json
> Content-Length: 242
> Expect: 100-continue
>
< HTTP/1.1 100 Continue
HTTP/1.1 100 Continue
* We are completely uploaded and fine
and then gets stuck.
Any idea, whats going on. I am able to run REST API GET commands. I see below line in enterprise manager log when GET command is successful
25 2024-03-29 02:21:48 [Manager ] [INFO ] Executing public api AemGetServer.
Hello,
I have following data-
If above scenario, balance due is $60. Because the payment made by CC somehow did not go through even though status shows "Paid".
How I can calculate the "Balance Due" in Qlik?
I used the following expression but it is not working in above example. I am getting Balance Due = 0 instead of 60
IF(([PAYMENT_STATUS] = 'Paid' OR [PAYMENT_STATUS] = 'Blank') ,
SUM(TOTAL_RATE) - SUM(ALLOCATION_AMOUNT))
I also used following but not getting correct Balance due amount-
IF(([PAYMENT_STATUS] = 'Paid' OR [PAYMENT_STATUS] = 'Blank') AND [2nd_LOCK] = 'Y', SUM(TOTAL_RATE) - SUM(ALLOCATION_AMOUNT), 0 )
Please help me to correct my formula to calculate the correct "Balance Due"
I have this column in a straight table chart as a measure.
Many thanks!
I need to load 100+ files (pipe delimited) with different schemas to DB tables.
I have created a mapping using Dynamic Schema and it is able to iterate the files , create table and load the data.
But issue is , All the column data types are created as VARCHAR2 .
What I want is that the column datatype in the output tables should be created as per data present in the input files.(say NUMBER for values like 1,2,3 etc and DATE for values like 1/1/2020 etc).
Please suggest how to make this happen.
Hi,
I'm looking for a set analysis expression where if we select an year it has to show previous year sales. Below example data.
Date | Market | Sales |
1/1/2024 | IND | 100 |
1/21/2024 | NAM | 200 |
1/16/2024 | AUS | 600 |
12/15/2023 | IND | 300 |
9/16/2023 | NAM | 400 |
8/26/2023 | AUS | 500 |
4/13/2022 | AUS | 600 |
5/18/2022 | IND | 900 |
6/10/2022 | NAM | 700 |
So I'm looking for a set analysis or a flag in the back end where if I select year it has to show previous year values. Below example.
If I select 2024 from year filter it has to show 2023 values.
Year | Sales 2024 | Sales 2023 |
2024 | 900 | 1200 |
If I select 2023 from year filer it has to show 2022 values
Year | Sales 2023 | Sales 2022 |
2023 | 1200 | 2200 |
Loading a QVD file from a SFTP connector (not from webconnector) occurs an error: noFileSize
Any file format doesn't have an error when loading.
I tried to load with an other QVD, the same issue persist.
Antivirus doesn't scan the SFTP folder.
There is not file access restrictions, antivirus software locking the file, or resource bottlenecks
Any idea to fix it?
Hi,
I'm running a new installatoin of Npriting May 2023. HTML reports, Word to PDF reports works fine. however, entity reports are not. The email gets sent without the PDF attachment with a message "some reports failed to generate"
this is what I found in the log file of the NPrinting engine:
Content request Qlik.Reporting.Engine.Messages.Requests.SomethingReportNodeRequest 886b52d1-42b0-4cd4-82ff-9376e8dec3f1: resolution ended unsuccessfully with exception System.Exception: Qlik NPrinting PDF Printer not installed or not properly registered
I tried reinstalling the NPrinting Engine but that did not help.
Bonjour,
Je n'arrive pas a me connecté au cluster Dataproc depuis Qlik replicate.
Erreur veut dire que l'adresse host et le numéro du port pour se connecter à Hive qui bloque par contre la config pour le cloud Storage est OK .
Cordialement.
Cordialement.
Hi team,
We are transferring data from oracle to kinesis. In one of the task which contained 38 tables got failed due to error that is failed to produce message to the exception stream. After giving warning for data error in one of the table that is A data error was encountered.refer to the attrep_apply_exceptions table for details.
Please let us know in which scenario this happens. Is there any workaround for this issue.
Attaching error screenshot for your reference.
Regards,
Sushant
I just wanted to post here to avoid people from wasting the time I did.
I was trying to load data from a Google Sheet into Qlik Sense SaaS. I looked through the available list of connectors, and picked the one called "Google Drive Spreadsheets". (This one should really be called, "Google Drive Metadata" to avoid users from thinking it is the one for Google Sheets.) Of course, when I went in, all I could see was the ListFiles table that has metadata about all the objects in my Google Drive.
So, I messed around with that connector for a while, looking at on-line articles and seeing if there was some way to put something in the Query field that would allow it to access one of my Google Sheet files itself. Every once in a while, I went & tried to connect using the "Google Drive" connector, but without success. In my case this was failing (no spreadsheet files were visible), because the connector requires files to match one of the types in its File type menu, or they don't show up. In other words, if you just create a Google Sheet & paste in some data, then go look for it to be visible in the Google Drive connector, you won't see it. You have to save it as a type .XLSX or something before it will show up.
So, both the name of the Google Drive Spreadsheets connector and the fact that there were no Google Sheet files visible through the Google Drive connector convinced me that the Google Drive Spreadsheets connector was the right one, so I wasted quite a bit of time researching on-line & trying to get that to work. Qlik support finally straightened me out. This is the right connector for Google Sheets in Qlik Sense SaaS: https://help.qlik.com/en-US/connectors/Subsystems/Web_Storage_Provider_Connectors_help/Content/Connectors_StorageProvider/Storage%20provider%20connectors/Google-Drive-storage-provider-connector.htm. After changing the file type of my Google Sheets in my Google Drive, they showed up & I was able to load them.
I hope this post will save you some time.
Elevate your career with Connect. 15 Hands-on workshops and certifications for Data and Analytics.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
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!