Everything you need to make your Qlik Community experience valuable.
Explore official Support and member created content.
Welcome Emmy award-winning Katie Linendoll as our emcee and world record-holding cave diver John Volanthen as our keynote speakers.
Forums for Qlik Data Integration solutions. Ask questions, join discussions, find solutions, and access documentation and resources
Share your best Qlik apps and discuss impacts with peers! Show your work and get recognized for innovative uses of Qlik technologies.
Get started on Qlik Community, find How-To documents, and join general non-product related discussions.
Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.
Qlik gives qualified university students, educators, and researchers free Qlik software and resources to prepare students for the data-driven workplace.
Hi all,
Silly question this one.
Please paste the below code in an empty QlikView file. My Code fails on the 'Match' statement. I need some assistance to get this to work please, and I've tried all options I can think of.
Thank you
Tbl:
load
chr(40) & concat(Code, ',') & chr(41) as Codelist;
LOAD * INLINE [
Code
28
29
30
];
Let MyVar = FieldVAlue('Codelist',1);
drop table Tbl;
DemoData_1:
LOAD * INLINE [
Student, Code
Peter, 28
Pam, 88
Paul, 30
];
DemoData:
NoConcatenate load
*
Resident
DemoData_1
where match(Code, $(MyVar)) > 0 ; //this is where it fails - I've also tried $(MyVar), with no luck - it runs, but returns nothing
drop table DemoData_1;
exit SCRIPT
Hi there,
just got the problem yesterday and today that 8 out of 10 times i try to load data via Qlik Data Gateway it fails with the notice:
"Requested endpoint could not be provisioned due to failure to acquire a load slot:"
Any of you got some ideas ?
Hi, start to use Qlik gateway, and few days a ago we start to get errors on our app reloads:
<Requested endpoint could not be provisioned due to failure to acquire a load slot: Unable to connect to the gateway (DirectAccess-2006)>
maybe someone saw such before? and know how to solve it.
We have a SAP Extractor replicate job built over a standard SAP HR extractor. When executed without any selection criteria over SAP RSA3 transaction, there is data in the extractor. However, we don't get any data out of Replicate tas.k Any suggestions on what might be causing this issue ?
SAP -
Replicate -
Data looks like this -
Family Name | Gift Date | PledgeNum | Pledged | Individual Name | IsGivingShared | Sum(GiftDetail_Amount) | Cumulative Family Amount | Max(GiftDate) |
Family1 | 5/10/2022 | - | No | Individual1 | False | $ 200.00 | 200 | 5/10/2022 0:00:00 TT |
Family1 | 10/9/2022 | - | No | Individual1 | False | $ 250.00 | 450 | 10/9/2022 0:00:00 TT |
Family2 | 3/13/2023 | - | No | Individual2 | False | $ 325.00 | 775 | 3/13/2023 0:00:00 TT |
Family3 | 9/25/2022 | - | No | Individual3 | False | $ 314.00 | 1089 | 9/25/2022 0:00:00 TT |
Family4 | 6/23/2022 | 27 | Yes | Individual4 | True | $ 50.00 | 1139 | 6/23/2022 0:00:00 TT |
Family4 | 7/23/2022 | 27 | Yes | Individual4 | True | $ 50.00 | 1189 | 7/23/2022 0:00:00 TT |
Family4 | 8/26/2022 | 27 | Yes | Individual4 | True | $ 350.00 | 1539 | 8/26/2022 0:00:00 TT |
Family4 | 9/23/2022 | 27 | Yes | Individual4 | True | $ 300.00 | 1839 | 9/23/2022 0:00:00 TT |
Family4 | 9/26/2022 | 27 | Yes | Individual5 | True | $ 100.00 | 1939 | 9/26/2022 0:00:00 TT |
Family4 | ######## | 27 | Yes | Individual5 | True | $ 100.00 | 2039 | 10/25/2022 0:00:00 TT |
Family4 | ######## | 27 | Yes | Individual4 | True | $ 200.00 | 2239 | 10/25/2022 0:00:00 TT |
Family4 | ######## | 27 | Yes | Individual4 | True | $ 470.00 | 2709 | 11/17/2022 0:00:00 TT |
Family4 | ######## | 27 | Yes | Individual5 | True | $ 100.00 | 2809 | 11/25/2022 0:00:00 TT |
Family4 | ######## | 27 | Yes | Individual4 | True | $ 200.00 | 3009 | 12/15/2022 0:00:00 TT |
Family4 | ######## | 27 | Yes | Individual5 | True | $ 100.00 | 3109 | 12/25/2022 0:00:00 TT |
Family4 | 1/25/2023 | 27 | Yes | Individual5 | True | $ 100.00 | 3209 | 1/25/2023 0:00:00 TT |
Family4 | 2/24/2023 | 27 | Yes | Individual4 | True | $ 200.00 | 3409 | 2/24/2023 0:00:00 TT |
Family4 | 2/25/2023 | 27 | Yes | Individual5 | True | $ 100.00 | 3509 | 2/25/2023 0:00:00 TT |
I'm using this expression for Cumulative amount in the above table: RangeSum(Above(total sum(GiftDetail_Amount),0,rowno(total)))
What I need is to aggr the cumulative amount by Family (a dimension). I want the data to look like table below - I've tried several things but cannot get it to work. Can anyone help me??
Family1 | 5/10/2022 | - | No | Individual1 | False | $ 200.00 | 200 | 5/10/2022 |
Family1 | 10/9/2022 | - | No | Individual1 | False | $ 250.00 | 450 | 10/9/2022 |
Family2 | 3/13/2023 | - | No | Individual2 | False | $ 325.00 | 325 | 3/13/2023 |
Family3 | 9/25/2022 | - | No | Individual3 | False | $ 314.00 | 314 | 9/25/2022 |
Family4 | 6/23/2022 | 27 | Yes | Individual4 | True | $ 50.00 | 50 | 6/23/2022 |
Family4 | 7/23/2022 | 27 | Yes | Individual4 | True | $ 50.00 | 100 | 7/23/2022 |
Family4 | 8/26/2022 | 27 | Yes | Individual4 | True | $ 350.00 | 450 | 8/26/2022 |
Family4 | 9/23/2022 | 27 | Yes | Individual4 | True | $ 300.00 | 750 | 9/23/2022 |
Family4 | 9/26/2022 | 27 | Yes | Individual5 | True | $ 100.00 | 850 | 9/26/2022 |
Family4 | 10/25/2022 | 27 | Yes | Individual5 | True | $ 100.00 | 950 | 10/25/2022 |
Family4 | 10/25/2022 | 27 | Yes | Individual4 | True | $ 200.00 | 1150 | 10/25/2022 |
Family4 | 11/17/2022 | 27 | Yes | Individual4 | True | $ 470.00 | 1620 | 11/17/2022 |
Family4 | 11/25/2022 | 27 | Yes | Individual5 | True | $ 100.00 | 1720 | 11/25/2022 |
Family4 | 12/15/2022 | 27 | Yes | Individual4 | True | $ 200.00 | 1920 | 12/15/2022 |
Family4 | 12/25/2022 | 27 | Yes | Individual5 | True | $ 100.00 | 2020 | 12/25/2022 |
Family4 | 1/25/2023 | 27 | Yes | Individual5 | True | $ 100.00 | 2120 | 1/25/2023 |
Family4 | 2/24/2023 | 27 | Yes | Individual4 | True | $ 200.00 | 2320 | 2/24/2023 |
Family4 | 2/25/2023 | 27 | Yes | Individual5 | True | $ 100.00 | 2420 | 2/25/2023 |
Hi folks,
I have to move all the QVDs from Spaces to the Shared space - I have seen various articles on REST calls, powershell scripts to make API calls - I implemented in Postman a simple to get a list of spaces and although it kind of works it couldn't get all of the spaces we have. I have checked the spaces one by one for permissions and the account I use has all of the permissions available so I don't believe that is the issue - is there a bug in the API or more probably am I calling it incorrectly?
In postman I use the bearer token, newly created in case that is the issue, then the URl is
https://XXXXX.qlikcloud.com/api/v1/spaces/
The resulting JSON only pulls 10 spaces but I have 30 - is there something else I need to do to get the full list?
Thanks
Hi,
QS is behaving strangely after the upgrade Feb2018 enterprise to Apr2019 enterprise (but also in my Feb2019 Desktop).
When exporting a table to excel, the cells which contain a zero are represented as blank. The value is present in the cell (you can see it when you click on it) but it happears as blank.
if you look at the format in xls you see the following:
This is the code I used to create a table containing numbers from 0 to 9:
load RowNo()-1 as riga
AutoGenerate 10;
It does not happen if I slitly change the code to:
load (RowNo()-1)/3 as riga
AutoGenerate 10;
In this case the format in excel is the generic one:
1) Has anyone experienced the same issue?
2) Is there any way to fix it for the entire app? Maybe using some kind of variable similar to MoneyFormat. I have thousands of fields and it is unthinkable to change the format one by one.
Thank you for your support.
Hello,
I have created a mashup using sense object id. so far everything working fine the only issue I was facing is when I am pulling the map object id inside the <div> the map size gets small (maybe zoom) but when I load the page again everything gets normal.
There is something wrong with click map behavior don't know why this happening.
Any help?
Not a major issue but since the SR4 release when I preview an Excel report using the designer, sometimes the excel window jumps out of the designer frame and into it's own Excel tab in task bar.
If you accidentally close the excel window then the only way to close designer is ending task via task manager - because of the continuous error "The RPC server is unavailable".
nPrinting May 2022 SR4
nPrinting Designer May 2022 SR4
Microsoft® Excel® for Microsoft 365 MSO (Version 2301 Build 16.0.16026.20214) 32-bit
Windows 10 Pro 21H2
Any advice?
Thanks
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!
If you want to know what's new across all of the products in our growing Qlik product portfolio.
Get the latest Support information about end-of-product support, new service releases, and general support topics.
Read all about Qlik solutions: scripting, data modeling, visual design, extensions, best practices and more.
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.
10+ hours of roll up your sleeves, immersive working sessions. A $1000 value included in your conference pass!
Subscribe to our Events and Webinar page so you do not miss an event
opportunity!
Join the "Welcome to Qlik" webinar and learn about the Qlik Ecosystem, such as Qlik Community, Learning, and Help.
There is more than one way to find upcoming events, look on the right side
of any Qlik Community forum!
Subscribe to our Events and Webinar page so you do not miss an event
opportunity!
Join the "Welcome to Qlik" webinar and learn about the Qlik Ecosystem, such as Qlik Community, Learning, and Help.
There is more than one way to find upcoming events, look on the right side
of any Qlik Community forum!