Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
9,900 online
Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER

Find the forums for your Qlik data analytics products to ask a question, start a discussion, or review documentation.

Find the forums for your Qlik Data Integration products to ask a question, start a discussion, or review documentation.

Welcome to the Qlik Alerting Product Forum! Join in on the discussion around Qlik’s intelligent alerting solution for Qlik Sense! This is an open group to share and collaborate!

Participate in Qlik Technical Previews, submit ideas, and review documentation.

Qlik partners with leading technology companies to develop integrations, extensions, and connectors to the Qlik platform.

Learn about the Qlik Community. Explore 'How-To' documentation, ask questions, and engage in discussion around the community platform. This will also be the place where, from time to time, we will do some fun things.

Learn about upcoming Qlik related events, webinars and local meetups.

Join one of our Qlik Community Groups. Anyone can view content in Open Groups, but you must join to participate. Closed Groups require joining in order to view content and participate.

Hear directly from Qlik employees in our ten unique blogs. Check out the new Product Insight & Ideas Blog!

Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.

Recent Discussions

  • No Boards Found
  • forum

    Qlik Connectors Discussions

    Qlik Sense Rest API Connector for Jira/Getting custom fields with their names fr...

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

    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.

     

     

     

    Show Less
  • forum

    Qlik GeoAnalytics Discussions

    Geo-Operations in SaaS environment

    I am having problems applying this operation dissolve in the SaaS environment .To my knowledge the autogenerated script from geoanalytic can be migrat... Show More

    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 

     

     

    Show Less
  • forum

    Qlik Sense Data Connectivity

    Creating a new Rest Connection via SendAsync method in Csharp qlik.net Sdk?

    I am trying to create a new REST connection through  the below mentioned line of code in C#:var task= location.App(newAppIdentifier,noVersionCheck:tru... Show More

    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?

     

    Show Less
  • forum

    Qlik Connectors Discussions

    Qlik Business Cloud Saving data to a Google Sheet

    Is it possible for Qlik Sense Business  save directly as Google Sheet? Thanks in advancei.e. Store into ..... [Googlesheet file ]
  • forum

    Qlik Sense App Development

    How to pass fields having special characters in Qlik sense url

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

    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

    Show Less
  • forum

    New to Qlik Sense

    AppSerializer: SaveApp_internal caught extended exception -1: Unknown error

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

    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"

    alex_red_0-1600263453435.png

     

    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?

     

     

    Show Less
  • forum

    Qlik Sense App Development

    Problems with sorting in pivot table

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

    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

    Show Less
  • forum

    Qlik Sense App Development

    Fields Parsing from XML

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

    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;

    Show Less
  • forum

    New to Qlik Sense

    Help Loading Table (Formatting issues)

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

    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):

    Enriquemmesteo_0-1603282129115.png

    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:

    Enriquemmesteo_1-1603282997653.png

     

    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

    Show Less
  • forum

    Qlik Sense App Development

    Section Access Country level Restriction for Holiday List

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

    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

    Show Less

Top Participants

Blogs

Qlik Community Manager Blog

Hear from the Qlik Community team about the latest platform enhancements and other topics.

Blogs

Support Updates Blog

Important and useful support information about end-of-product support, new service releases, and general support topics.

Blogs

Blogs

Hear directly from Qlik employees and stay current on the latest and greatest information about Qlik products.

Groups

Covid 19

We are bringing together people and resources in response to the pandemic of Coronavirus, aka COVID-19, aka SARS-CoV-2.

open to all

Groups

QlikView to Qlik Sense

Join the QlikView to Qlik Sense group and help you modernize your BI experience through adoption of Qlik Sense.

open to all

Groups

Qlik Healthcare

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

750+ Members

Events

Data Revolution Virtual Summit

The new normal requires a new approach to data. Join this event to learn about the latest trends and approaches for accelerating value from your data.

October 27 - 29, 2020 Virtual Summit

Events

Events & Meetups

Virtual Meetups are now a possibility! With the impact of COVID-19, the Qlik Meetup network has expanded its support to include the ability to host your next Meetup online. Email QlikMeetups@qlik.com to get your virtual Meetup started!’

Events

Direct Relief Uses Qlik to Manage Its COVID-19 Supply Chain

Qlik can help you manage your supply chain risks during COVID‑19.The nonprofit organization, Direct Relief, uses Qlik’s Supply Chain solution to scale its delivery of medical supplies worldwide.

Available on Demand