Welcome to Qlik Community

Hi Everyone,

Good Evening,

My source is jira, Loaded data from Jira through REST API into qlik sense, while loading Issue table custom fields are loading into Qlik like Custom filed ids as lable, so its difficult to identify what is the actual filed name from jira.

Due to requirement in project few field were added in Jira by Jira developer those fields called custom fields. These newly added fields by Jira developer are coming into qlik as custom filed with id (ex: custom field 250,custom filed 340).

While creating the REST connection defined the filed names in the parameters, even though custom filed with ids are loading.

Do i missed something while loading,please help on this.

Thanks in Advance!!!!!!!!!!!

Varsha.

I am having problems applying this operation dissolve in the SaaS environment .

To my knowledge the autogenerated script from geoanalytic can be migrated to geo-Operations in SaaS environment.

After several steps followed from script conversion 

I am still unable to migrate my script syntax.

@Patric_Nordstrom 

I am trying to create a new REST connection through  the below mentioned line of code in C#:

var task= location.App(newAppIdentifier,noVersionCheck:true).Session.SendAsync(1,"CreateConnection",null, <<HOW TO Pass the required Json Params here>>);

My code example:

var task= location.App(newAppIdentifier,noVersionCheck:true).Session.SendAsync(1,"CreateConnection",null, new Object[]{qname,qConnectionURL,qType});

Kindly suggest me how to parse the required details into the Param Object[] args field of the Send Async Method?

Hi All,

Is there any way to pass field value in QlikSense App url having special characters.

Below URL is working 

http://test/appid/test/sheetid/test/select/name/abc

Below URL is not working

http://test/appid/test/sheetid/test/select/field/IQG2HN?OM#P&RY?_\NY7.+2\,>D:BE2^36?PW>,73J

Please suggest how we can pass  special characters in URL

Event viewer log:

"The description for Event ID 300 from source Engine cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

If the event originated on another computer, the display information had to be saved with the event.

The following information was included with the event:

AppSerializer: SaveApp_internal caught extended exception -1: Unknown error"

Version: Qlik Sense June 2019 Patch 11

Behavior in Qlik Sense: Scheduled application tasks are randomly failing in QMC - despite the failed status of the tasks in QMC, the application log does not show any technical issue, however, the task still fails.

Is anyone else facing this behavior?

I have some troubles with sorting in QlikSense. Currently I have sorted my table where the sorting doesn't work in the middle field (supplier) Sorting on this page is setup exactly the same in another page where it does work.

See attachment

I am using Qlik Sense April 2020 Patch 8 Enterprise. I have pulled in the data from API in the form of a XML string as below(Sample)

<ns:getHistoryResponse xmlns:ns="http://Mywebsite.com/xsd"><ns:return>&lt;?xml version="1.0" encoding="UTF-8"?>&lt;RESULTS>&lt;STATUS MESSAGE="Normal Completion">Success&lt;/STATUS>&lt;AUTH_HISTORIES>&lt;AUTH_HISTORY DATES="2015-04-06 13:14:19" FIELDS="ATO Upcoming" NEW_VALUE="07/31/2015" OLD_VALUE="01/23/2018" SYSTEM_ID="9388"/>&lt;AUTH_HISTORY DATES="2015-08-14 13:21:36" FIELDS="ATO Status" NEW_VALUE="ATO (1yr)" OLD_VALUE="Expired" SYSTEM_ID="9388"/>&lt;AUTH_HISTORY DATES="2015-08-14 13:21:37" FIELDS="ATO Upcoming" NEW_VALUE="08/14/2016" OLD_VALUE="07/31/2015".

My Auto Generated script is as below

LOAD
XMLString
FROM [lib://My Connection]
(XmlSimple, table is getHistoryResponse);

I would like to parse out the below fields from the above XML. How I can accomplish that

LOAD SYSTEM_ID,
OLD_VALUE,
NEW_VALUE,
FIELDS,
DATES;

Hello everyone, I have to load a bunch of excel files and among those there is a table in a sheet that needs some preparation to load properly:

The table is structured like this (notice this is a simplified example):

Explanation:

• In the first column we have "Position" of the members of the team (Leader, Trainee,etc...) which is not always the same. One excel file can have 2 positions here and another one could have 12. The names you can see from cell B3 to E6 (notice that the number of columns isn't constant either from file to file as there can be different MILESTONES ,from cell B1 to the last milestone. Each milestone has a date assigned to it in the second row (from cell C1 to the last milestone).
• The seventh row is the STATUS for each milestone, which can be GOOD, BAD, ETC...

I'm not interested in any of the names or positions. Just need to load the milestones with their dates and scores.

I can't change the excel files, so I need load these tables like they had the following format in the script editor:

This doesn't look complex but the loading script already has a lot of stuff for the rest of the sheets and files and I need to do this as simple as possible.

Thanks very much

Hello,

 I have got a requirement as below,

I am having 4 countries like IN(India),SL(Srilanka),US(USA) and DE(Germany) with their holiday list.

So when I am logging in, I would like to have only that specific country holiday list that will be further used in calculation.

My below findings:

SECTION ACCESS FIELD is COMPANY

Temp_Holiday:
Load *,'DE' as COMPANY Inline [Holiday_Day, Holiday_Date
Mon,'13/04/2020'
];
Load *,'US' as COMPANY Inline [Holiday_Day, Holiday_Date
Mon,'20/01/2020'
];

Holiday:
Load 
COMPANY,
Chr(39)&Concat(Date(Floor(Date#(Holiday_Date)),'DD/MM/YYYY'),chr(39)&','&chr(39))&chr(39) as Holidays
Resident Temp_Holiday group by COMPANYKEY;

Let vholidays = Peek('Holidays',0,'Holiday');

trace $(vholidays);

If  I login with DE it works fine as the vholidays variable uses 1st row which is nothing but DE0 but if I login with US,the holiday for DE is storing in the variable for US as well.

I would like to store the holiday list in a variable based on COUNTRY login because I am using that variable for calculation

in network days.

Kindly provide your inputs.

Regards,

Pradeep