Is anyone familiar with the Qlik Sense Jira integrated connector?

I'm trying to fetch a specific field from Jira: the Issue's original estimated time.

However, the provided Jira connector script for issues doesn't seem to include this importanr field, which strikes me as odd.

Does anyone have insight or suggestions on how I might access this field? I believe its original name is 'originalEstimate'."

Jira Connector script for issues:

"SELECT
id,
key,
fields_summary,
fields_description,
fields_environment,
fields_created,
fields_lastViewed,
fields_updated,
fields_resolutiondate,
fields_duedate,
fields_labels,
fields_components_ids,
fields_components_names,
fields_fixVersions_ids,
fields_fixVersions_names,
fields_versions_ids,
fields_versions_names,
fields_creator_accountId,
fields_creator_active,
fields_creator_displayName,
fields_creator_emailAddress,
fields_creator_key,
fields_creator_name,
fields_creator_timeZone,
fields_assignee_accountId,
fields_assignee_active,
fields_assignee_displayName,
fields_assignee_emailAddress,
fields_assignee_key,
fields_assignee_name,
fields_assignee_timeZone,
fields_reporter_accountId,
fields_reporter_active,
fields_reporter_displayName,
fields_reporter_emailAddress,
fields_reporter_key,
fields_reporter_name,
fields_reporter_timeZone,
fields_issuetype_description,
fields_issuetype_iconUrl,
fields_issuetype_id,
fields_issuetype_name,
fields_issuetype_subtask,
fields_priority_iconUrl,
fields_priority_id,
fields_priority_name,
fields_status_id,
fields_status_name,
fields_status_description,
fields_status_iconUrl,
fields_resolution_id,
fields_resolution_name,
fields_resolution_description,
fields_votes_hasVoted,
fields_votes_votes,
fields_watches_isWatching,
fields_watches_watchCount,
fields_parent_key,
fields_parent_id,
fields_subtasks_ids,
fields_subtasks_keys,
fields_issuelinks_ids,
fields_issuelinks_keys,
fields_outwardIssueLinks,
fields_inwardIssueLinks
FROM Issues
WITH PROPERTIES (
projectIdOrKey='$(vProjectId)',
createdAfter='',
createdBefore='',
updatedAfter='', 
updatedBefore='',
customFieldIds='',
jqlQuery='',
maxResults=''
);"

Hello Qlik experts,

I am facing an issue that seems quite simple, but I have spent a lot of time trying to make it work with no luck. I need to create a straight table with Date, Revenue, and Last 7 Days Revenue, but I am having trouble with the Last 7 Days Revenue value.

I want this column to show the revenue for the last 7 days, and it should not change when I select different dates in the table. It should always display the same fixed value, regardless of what date is selected.

The Last 7 Days Revenue will also be used as a factor to calculate further measures, so it is crucial that this value stays constant.

Here is my sample data 

LOAD
INLINE [
ClickDate, Revenue
2025-04-30, 100
2025-05-01, 120
2025-05-02, 130
2025-05-03, 110
2025-05-04, 90
2025-05-05, 150
2025-05-06, 80
2025-05-07, 160
2025-05-08, 140
2025-05-09, 100
2025-05-10, 180
2025-05-11, 170
2025-05-12, 200
2025-05-13, 90
2025-05-14, 210
];

My measure for revenue is:

Sum(Revenue)

And the expression for Last 7 Days Revenue is:

Sum({
<ClickDate = {">=$(=Date(Today()-6))<=$(=Date(Today()))"},
ClickDate= >
} Revenue)

Unfortunately, this expression does not give the expected result. The Last 7 Days Revenue column is not behaving as I intend.

Can someone point out what I’m missing here? I would appreciate any insights on how I can achieve the desired outcome.

Thanks in advance!

Hi all,

I have a web file connection in Qlik Sense that was working up until today. I'm pulling the Daily Treasury Bill data from Treasury.gov, the URL is: https://home.treasury.gov/resource-center/data-chart-center/interest-rates/daily-treasury-rates.csv/2025/all?type=daily_treasury_bill_rates&field_tdr_date_value=2024&page&_format=csv

I can still download the csv from my browser with this csv just fine. When I run the reload in Qlik that accesses this web file connection it seems to run indefinitely making no progress. Occasionally I will get an 'Unknown Error' if I run the job from the data load editor. I can't preview the data in the connections section in the data load editor.

How can I troubleshoot/resolve this? Thanks.

Hi,

Trying to start server in following sequence:

Quintiq server --> started

Quintiq Thin client server  -> start failed with error Can't connect to server 'SERVER',localhost:6000, Failed with below error

14-05-2025, 23:39:22.028 15 QTCE.exe HOSTNAME 192.168.0.1 36240 JobThread7 6 Can't connect to server 'SERVER',localhost:6000, Failed
14-05-2025, 23:39:22.028 16 QTCE.exe HOSTNAME 192.168.0.1 36240 JobThread7 6 Name='SERVER', Status='Failed', Status message='Cannot find the host to connect to, please make sure the connection settings are correct.', Computername=HOSTNAME, OSUsername=johnyjohn, Initiated

These are the errors

Any suggestions to resolve? Please support

Thanks

The November 2024 release of Qlik Sense offers a new menu object. It builds its menu based on the sheets in the dashboard automatically. We have a dashboard that currently links to other dashboards via button objects. Our intension is to use the new menu instead of buttons and somehow link to another dashboard possibly using a blank or hidden sheet.

Any ideas?

I need to create a bar chart that counts the number of distinct facilities in the trailing 12 month of the selected As_Of_Date. For example, if 03/31/2025 is selected, I need to show a bar chart showing each month facility could from 04/30/2024 to 03/31/2025. 

My data is only on month ends (business days), which means I only have one As_Of_Date in each month.

The dimension is As_Of_Date. This script provided by gpt on the measure is giving me erorr 'Error in Expression:'}' expected':

Count({
<As_Of_Date = {">=$(=Date(AddMonths(Max(As_Of_Date), -11), 'MM/DD/YYYY'))", "<=$(=Date(Max(As_Of_Date), 'MM/DD/YYYY'))"}>
>} distinct facility_id)

What should I do to get the right measure?

Hi
i created a dynamic view that contains a table.  i want to give the user ability to interact with the table - not just to filter for dimensions but also to add/remove dimensions - i do this by a filter that allows the user to select what dimensions they want.

initially i created 2 dynamic views: the filters + the table.  however, when i embed the two views into my base app - it appears the 2 dynamic views are is separate sessions, what i filter for cant be seen by the other dynamic view.

i tried hosting my 2 objects in a container (of course i made the container a master visualization) so that i would think they would be in the same session.

however, when i configure my dynamic view, i dont see the container as an option.

1st question if i have 2 dynamic views using the same template app, can i bind them together?

2nd question - failing the ability to bind and i think i know why they cant be bound, how do i use my container as a dynamic view?

thanks a lot for any assistance

Hi,

I identified that in the qlik replicate data folder, some files are with the root owner and for I had the error "<data directory>/logs/metrics/metricsLog.txt. Error: Permission denied", then I changd to attunity owner and works fine.
But I don't know why change owner directory, because we don't manually change this.
If any process in replicate that do that?

Thanks

Hello everyone!

if you’re at Qlik Connect, come see us at the Qlik Community and Customer Advocacy booths! 

We might have something special for you! 😉