Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everybody
I was trying to send email invitation through automation following the online help
Invite one or more users by email address.
but despite many try i'm always getting error 404
does anybody see where is my mistake ??
path : users/actions/invite
method : post
and body (raw input)
{
"invitees": [
{
"email": "test@company.com",
"resend": true
}
]
}
Hello experts,
There are connectivity problems in our site, which occurs on TASK relods only as far as we experienced. Its both occurs on ODBC & Rest connections.
When i check script logs we get this error immidiately after "Lib Connect to xxx" statement.
20240327T120257.655+0300 0023 LIB CONNECT TO 'SOME_ODBC_DB_Connection'
20240327T120339.724+0300 Error: Connection aborted (System error: The handle is invalid.)
20240327T120339.726+0300 Execution Failed
20240327T120339.730+0300 Execution finished.
the time from lib connect to statment and error differs from 30 to 150 seconds.
Btw <generatePublisherEvidence enabled="false"/> is set on all of our Qlik servers inside of <runtime> tag which is located on machine.config. We have to manually control the failed task list and manually send a re-start order to mitigate this, but its very exhausting effor to chase up a site with more than +2000 tasks. And this is still not a solution because sometimes its ends as a fail again, we always have to check if its finishes as success.
Qlik Sense Version: Qlik Sense February 2023 Patch 6 | 14.113.9
i have materail_desc, fees_revenue, extras revenue fields
i need to create stack bar chart, the bar names should be fees_revenue, extras revenue. lenghth of bars need to show, each maeterail id in different colours and corresponmding fees revenue. and extras revenue. Please find the sample diagram to look like. it's little urgent . Please help me
Good Day everyone.
Are there Qlik users in South Africa using Qlik Sense cloud who for the last +/- month have been experiencing performance issues? I have 2 clients experiencing issues and I am trying to determine if their issues are "local" or if it could possibly be tenant related on the cloud.
Would it be safe to assume that all South African Qlik Sense cloud-based organizations are hosted in the same cloud.
Any advice or feedback from others in South Africa with performance issues would be greatly appreciated.
Thanks
Phil
Hi everyone,
I am currently working on one of my first automations. I have used this very good knowledge base article to create a Loop and reduce automation
I have a working solution. The field I use to loop over has more values than I want to use to create apps from.
To filter them I use a condition. I wanted to list all the values in one condition. For this I tried to separate them by comma or semicolon, but this doesn't work. I also tried to compare with list contains or contains.
Does anyone have a working solution on how to compare to a list of values?
Thanks a lot for your help!
I have multiple tables coming from different sources with different granularity. They have some common fields like city, region etc for which I have made a key and am using the link table concept. the keys are this way:
Load
ProductName&'-'&ProjectName&'-'&RegionArName&'-'&CityArName&'-'&Year&'-'&Month as key,
....
From[Source 1]
Load
RegionArName&'-'&CityArName&'-'&SalaryRange&'-'&Year&'-'&Month as key,
......
From[Source 2]
LOAD
ProductName&'-'&ProjectName&'-'&RegionArName&'-'&CityArName&'-'&SalaryRange&'-'&Year&'-'&Month as key,
....
From[Source 3]
This created a link table from which Im using RegionArName, CityArName, ProjectName as filters across the dashboard. My issue is that the city filter is working fine but Region and Project filters are not, such that each projectname is showing mapping against multiple regions which is not the case at the backend. What am I doing wrong?
I have created a REST API connection with Quickbooks Online and fetching the General Ledger report by using GET method. The response tables are such that it is not at all understandable and all the values that I need are distorted and disarranged in the data model. I am not able to understand the column headers and their corresponding values.
Is there a way to get the response in such a way that the data is readable and analyzable? Or is there a way to convert the script to a normal Qliksense table script. Here's a sample of the script that i am having as a response to my Rest API call-
Dear community,
I am new to QlikView, I have data sources in Excel files.
When I load data, Qlikview generates fields that I don't want.
Load function added :
On each data update I have error regarding "DERIVE FIELDS FROM FIELDS" and QlikView generates new "Auto generated section" (7 for only 2 files loaded...)
Any solution to prevent QlikView from generating thoses lines ? I don't need them and I have more data to load.
I would like to report what I believe is a bug in inner and outer set expressions feature (May 2023 patch 1), not sure if this forum can be a suitable location.
Given the the script,
Fruits:
LOAD * Inline [
Type,Color,Quantity
apple,green,1
apple,green,1
apple,green,1
orange,orange,1
orange,orange,1
];
Consider the below formulae outputs, where we select apples (which exist in the data set) and kiwis (which do not exist):
Sum({<Type={'apple'}, Color={'green'}>} Quantity) |
3 | OK |
{<Type={'apple'}>} Sum({<Color={'green'}>} Quantity) |
3 | OK |
{<Type={'apple'}, Color={'green'}>} Sum(Quantity) |
3 | OK |
Sum({<Type={'kiwi'}, Color={'green'}>} Quantity) |
0 | OK |
{<Type={'kiwi'}>} Sum( {<Color={'green'}>} Quantity) |
3 | WRONG!! The outer set analysis is not inherited! |
{<Type={'kiwi'}, Color={'green'}>} Sum(Quantity) |
0 |
OK |
Sum({<Type={'orange'}, Color={'green'}>} Quantity) |
0 |
OK |
{<Type={'orange'}>} Sum( {<Color={'green'}>} Quantity) |
0 |
OK |
{<Type={'orange'}, Color={'green'}>} Sum(Quantity) |
0 |
OK |
Sum({<Type={'kiwi'}>} Quantity) |
0 |
OK |
{<Type={'kiwi'}>} Sum( Quantity) |
0 |
OK |
As per the results above: outer set expression is not inherited if
Could someone confirm this is indeed a bug and whether it has already been fixed in the recent version? Thanks!
Hi all,
I have a qlikview application with Geo Analytics map. I need to import it in Nprinting report, but when I place the map object as an Image in Qlik Nprinting ppt, it shows blank. Is there any other way of importing Geo Maps to Qlik NPrinting?
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.
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!