Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 216,765 members
  • 5,476 online
  • 1,994,027 posts
  • 149,420 Solutions
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW

Welcome to Qlik Community

Recent Discussions

  • forum

    New to Qlik Analytics

    How to automate data export from a visualization to an excel file?

    Hello ,   Has anyone tried setting up a task that could export data from a visualization inside an app to a shared location on the server in Qliksense... Show More

    Hello ,

     

    Has anyone tried setting up a task that could export data from a visualization inside an app to a shared location on the server in Qliksense Enterprise?

    any suggests??

    Thanks,

    Vamsi

    Show Less
  • forum

    App Development

    Hide Navigation Bar

      I am wanting to hide the navigation bar in my published app but retain the Toolbar (see image), Is there a way I can do this? Thanks Mark
  • forum

    Design and Development

    Can not read all data of Excel when using Dynamic Schema

    Hello everyone I am using Talend Data Integration Job to read the following Excel which has 3 rows and 88 columns:     But only part of data(2 rows... Show More

    Hello everyone

    I am using Talend Data Integration Job to read the following Excel which has 3 rows and 88 columns:

    laughsmile_1-1713160148764.png

     

    laughsmile_0-1713160123911.png

    laughsmile_4-1713160415225.png

     

    But only part of data(2 rows and 17 columns) can be read, the first row and part of columns lost after read by using dynamic schema.

    laughsmile_3-1713160307060.png

    By the way, if I define 88 string column in the schema , I can read the all data.

    Thanks in advance.

     

     

     

    Show Less
  • forum

    Connectivity & Data Prep

    Fetch Data with the Qlik Jira Connector

    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.... Show More

    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=''
    );"

    Show Less
  • forum

    Qlik Reporting Service

    Paging in tabular reporting for paged pivot tables? Is it possible?

    I have been trying to create a report using the excel tabular reporting, that creates a new sheet for each Sales Person. To do this I have been trying... Show More

    I have been trying to create a report using the excel tabular reporting, that creates a new sheet for each Sales Person. To do this I have been trying to use the pages option.

    It appears that this works fine for the straight table that is used for the report (i.e. it creates a sheet for each sales person with a straight table on it and the data filtered for each sales person).

    However, I need the chart to be shown as a pivot table and if I use the pages option on the pivot table it doesn't seem to work? I end up with a sheet created for each Sales Person (i.e. the tab of the sheet is named correctly for each sales person) but the data within each sheet is not filtered to each Sales Person, all sheets created show the same data on the pivot table which is for the first Sales Person only. 

    Can someone advise if what I am attempting to do is actually possible? 

    Thanks. 

     

    Show Less
  • forum

    App Development

    RangeSum using RowNo is not resetting in a table as the dimension changes

    Were trying to calculate hours accumulated across the Fiscal_QTR field. When the Fiscal_QTR field changes, the hours needs to reset and start accumula... Show More

    Were trying to calculate hours accumulated across the Fiscal_QTR field.

    When the Fiscal_QTR field changes, the hours needs to reset and start accumulating again. The image on the left is what is returning from the line of code below.

    RangeSum(above(Sum(Hours Amount]),0,RowNo()))

    The line on the right is what I expected, to restart from 1 as the Fiscal_QTR changes.

    The ultimate goal is to add up cumulative hours  restarting as the Fiscal_QTR field changes. Below I'm showing a table as an example but ideally I want to visualize as a Qlik Sense line chart that shows across Fiscal_QTR's.

    wcoleman0908_5-1712940929513.png

     

    Any help is appreciated.

     

     

     

    Show Less
  • forum

    New to Qlik Analytics

    Access Denied when reloading app if not the current app owner

    Hi, Guys! I have a Button with "reload" action in a dashboard , but it only works if the user is the owner of the app. It is NOT in a cloud enviroment... Show More

    Hi, Guys!

    I have a Button with "reload" action in a dashboard , but it only works if the user is the owner of the app.

    It is NOT in a cloud enviroment.

    Users have professional licenses.

    Can you help me?

     

    Show Less
  • forum

    New to Qlik Analytics

    why Join is not working?

    Hi -I'm trying to add the storename to my emp_name table based on the salesman_id and date fields together but the qlik is got stocked. the join that ... Show More

    Hi -
    I'm trying to add the storename to my emp_name table based on the salesman_id and date fields together but the qlik is got stocked.

    the join that is not working:

    EmpStore:

    LOAD DISTINCT
    SalesmanID & '|' & date(trim(Date)) AS EmpStoreKey,
    StoreHanut
    FROM [lib://ETL/Sales_final.QVD](qvd);


    EmpName_new:
    LOAD
    *
    FROM [lib://ETL/EmpName.QVD] (qvd);
    LEFT JOIN (EmpName_new)
    LOAD
    EmpStoreKey,
    StoreHanut
    RESIDENT EmpStore;
    drop table EmpStore;

     

     

    the apply map that's work:

    EmpStoreMapping:
    Mapping
    load distinct
    SalesmanID & '|' & date(trim(Date)) as EmpStoreKey,
    StoreHanut
    FROM [lib://ETL/Sales_final.QVD]
    (qvd);


    EmpName_new:
    LOAD
    *,
    ApplyMap('EmpStoreMapping', SalesmanID & '|' & date_num_new, '') as StoreHanut
    from [lib://ETL/EmpName.QVD] (qvd);


    Store EmpName_new into [lib://ETL/EmpName_new.QVD] (qvd);


    Drop Table EmpName_new;

     

    when i'm using apply mapping it's working but I want to  use join to fetch more then single value.

    what I'm doing wrong?



    Show Less
  • forum

    New to Qlik Analytics

    Date format to MM/YYYY (Month year)

    Hi need help in below Date format conversion        Change the following Date format   1087560:00:00  to MM/YYYY
  • forum

    New to Qlik Analytics

    Qlik to Power Bi logic replication

    Hello All,I have posted this question before, but haven't recieved correct response, I also tried but didn't exactly helped. I don't know this would b... Show More

    Hello All,

    I have posted this question before, but haven't recieved correct response, I also tried but didn't exactly helped. I don't know this would be the right place to ask this question, but I am not so perfect in Qlik

    I need below Qlik logic same in Power BI

    count
    (
    DISTINCT
    {
    <
    [Im Date]={">=$(=QuarterStart(max([Im Date]))) <=$(=date(max( [Im Date])))"},
    FyQtr=,
    Quarter=,
    Year=,
    [Type]={"Northern"},
    [Category]={'INELIGIBLE'},
    [En Number]=E({<[HM Flag]={'Y'},FyQtr=,Quarter=,Year=>}[En Number])

    >
    }

    [En Number])



    Could anyone please help....

    Thanks!!!

    Show Less
Leaderboard

Customer Story

Qlik Data Integration & Qlik Replicate story

Qlik enables a frictionless migration to AWS cloud by Empresas SB, a group of Chilean health and beauty retail companies employing 10,000 people with 600 points of sale.

Customer Story

Building a Collaborative Analytics Space

Qlik Luminary Stephanie Robinson of JBS USA, the US arm of the global food company employing 70,000 in the US, and over 270,000 people worldwide.

Location and Language Groups

Choose a Group

Join one of our Location and Language groups. Find one that suits you today!

Collaborate

Healthcare User Group

Healthcare User Group

A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..

All are welcome

Japan Group

Japan

Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。

Request to join

Brasil Group

Brazil

Welcome to the group for Brazil users. .All discussions will be in Portuguese.

open to all

Blogs

Community News

Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!