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.

 

Show Less

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
}
]
}

 

 

Show Less

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

Show Less

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 

 

 

Show Less

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

Show Less

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!

 

Show Less

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?

 

Show Less

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-

 

 

Show Less

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 :

• APPLYMAP
• TAG FIELD
• DERIVE FIELDS FROM FIELDS 

 

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.

Show Less