Is there a decent zero to REST API tutorial or guide for Qlik Sense Enterprise?

I’m a full stack dev who is comfortable with JWTs, basic auth etc and very comfortable with Node/JS and API calls, custom headers, etc but for some reason none of the guides I’ve found really cover every setting that is required.

Why do I need a cert etc? What’s a virtual proxy vs proxy? If only there was an API to call.

Hi all,

I have a table loaded from a database with fields such as event_code, previous_event_code, event_name, category, and quantity.

I want to display the different categories of sold tickets of the previous event in a table on my dashboard.

So the tricky thing is that when I filter by an event_name, I will have the categories of the tickets of this year displayed in a table, but want to display the categories of the tickets of the previous_event_code. So if I filter and chose event_code = 'ER_2024_3' those rows will have a previous_event_code =' ER_2023_1' and need to display the categories of tickets when the rows of the whole dataset has ' ER_2023_1' as event_code and not as previous_event_code.

To do this, I create a table in the dashboard with a column called

category, another column with

sum(quantity), and another column with this expression:

Sum({<year_event=, month_event=, event_code=p(previous_event_code), event_to_compare=, event_name= >} quantity).

However, the categories of the previous event are all showing up as null. In the dashboard, I filter by event_name.

I think I need a set analysis that says when event_code is actually previous_event_code.

Is it possible to do it in Qlik via expression, or maybe I need to do something in the load editor, or actually I need to transform the data before Qlik?

Many thanks. Any help much appreciated.

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?

Hi,

I'm working with the Chart Exploration feature:

Is there a function that identifies these values I checked in chart exploration? (Similar to the GetFieldSelections() function).

Thanks,

Eli.

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 value there. 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 

https://community.qlik.com/t5/Official-Support-Articles/How-to-Loop-and-reduce-with-Qlik-Application-Automation-advanced/ta-p/1834378 

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!