Skip to main content

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 187,990 members
  • 6,247 online
  • 1,741,404 posts
  • 133,532 Solutions
Announcements
Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW

Welcome to Qlik Community

FOR NEW MEMBERS

Everything you need to make your Qlik Community experience valuable.

SEARCH KNOWLEDGE BASE

Explore official Support and member created content.

QLIKWORLD 2023!

Welcome Emmy award-winning Katie Linendoll as our emcee and world record-holding cave diver John Volanthen as our keynote speakers.

Analytics

Forums for Qlik Analytic solutions. Ask questions, join discussions, find solutions, and access documentation and resources.

Data Integration

Forums for Qlik Data Integration solutions. Ask questions, join discussions, find solutions, and access documentation and resources

Qlik Gallery

Share your best Qlik apps and discuss impacts with peers! Show your work and get recognized for innovative uses of Qlik technologies.

Ideation

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

Support

Chat with us, search Knowledge, open a Case, read the latest Updates Blog, find Release Notes, and learn about our Programs.

Events

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

Groups

Join a Group that is right for you and get more out of your collaborations. Some groups are closed. Closed Groups require approval to view and participate.

About Qlik Community

Get started on Qlik Community, find How-To documents, and join general non-product related discussions.

Blogs

Hear directly from Qlik employees in our ten unique blogs.

Qlik Resources

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

Qlik Academic Program

Qlik gives qualified university students, educators, and researchers free Qlik software and resources to prepare students for the data-driven workplace.

Community Sitemap

Here you will find a list of all the Qlik Community forums.

Recent Discussions

  • forum

    New to Qlik Sense

    Load multiple sheets from multiple excel files from Sharepoint

    Hello, I can connect to sharepoint via metadata connector to get "filelist" But what to do in case i have files in different subfolders (some wildcard... Show More

    Hello,

    I can connect to sharepoint via metadata connector to get "filelist"

    But what to do in case i have files in different subfolders (some wildcard)?

    /sites/05_BUSINESSPLANNING/Shared Documents/06_Price List/03_SAS'

    Contains subfolders: "2021", "2022", "2023" and every subfolder contains another subfolder related to Quarters.

    At the end I have similar tables with matching columns within 5 sheets i every excel file.

     

    Is there any option to do this LOAD ? 

     

     

    LIB CONNECT TO 'DA_CONNECTORS:SHP_metadata';
    List_of_SASPRICELIST_FILES:
    LOAD UniqueId as [ListFiles.UniqueId],
    Name as [ListFiles.Name],
    title as [ListFiles.title],
    id as [ListFiles.id],
    updated as [ListFiles.updated],
    Author_Entry as [ListFiles.Author_Entry],
    CheckedOutByUser_Entry as [ListFiles.CheckedOutByUser_Entry],
    EffectiveInformationRightsManagementSettings_Entry as [ListFiles.EffectiveInformationRightsManagementSettings_Entry],
    InformationRightsManagementSettings_Entry as [ListFiles.InformationRightsManagementSettings_Entry],
    ListItemAllFields_Entry as [ListFiles.ListItemAllFields_Entry],
    LockedByUser_Entry as [ListFiles.LockedByUser_Entry],
    ModifiedBy_Entry as [ListFiles.ModifiedBy_Entry],
    Properties_Entry as [ListFiles.Properties_Entry],
    VersionEvents_Feed as [ListFiles.VersionEvents_Feed],
    Versions_Feed as [ListFiles.Versions_Feed],
    CheckInComment as [ListFiles.CheckInComment],
    CheckOutType as [ListFiles.CheckOutType],
    ContentTag as [ListFiles.ContentTag],
    CustomizedPageStatus as [ListFiles.CustomizedPageStatus],
    ETag as [ListFiles.ETag],
    Exists as [ListFiles.Exists],
    IrmEnabled as [ListFiles.IrmEnabled],
    Length as [ListFiles.Length],
    Level as [ListFiles.Level],
    LinkingUri as [ListFiles.LinkingUri],
    LinkingUrl as [ListFiles.LinkingUrl],
    MajorVersion as [ListFiles.MajorVersion],
    MinorVersion as [ListFiles.MinorVersion],
    ServerRelativeUrl as [ListFiles.ServerRelativeUrl],
    TimeCreated as [ListFiles.TimeCreated],
    TimeLastModified as [ListFiles.TimeLastModified],
    UIVersion as [ListFiles.UIVersion],
    UIVersionLabel as [ListFiles.UIVersionLabel];

    SELECT UniqueId,
    Name,
    title,
    id,
    updated,
    Author_Entry,
    CheckedOutByUser_Entry,
    EffectiveInformationRightsManagementSettings_Entry,
    InformationRightsManagementSettings_Entry,
    ListItemAllFields_Entry,
    LockedByUser_Entry,
    ModifiedBy_Entry,
    Properties_Entry,
    VersionEvents_Feed,
    Versions_Feed,
    CheckInComment,
    CheckOutType,
    ContentTag,
    CustomizedPageStatus,
    ETag,
    Exists,
    IrmEnabled,
    Length,
    Level,
    LinkingUri,
    LinkingUrl,
    MajorVersion,
    MinorVersion,
    ServerRelativeUrl,
    TimeCreated,
    TimeLastModified,
    UIVersion,
    UIVersionLabel
    FROM ListFiles
    WITH PROPERTIES (
    subSite='sites/05_BUSINESSPLANNING',
    folder='/sites/05_BUSINESSPLANNING/Shared Documents/06_Price List/03_SAS',
    maxResults=''
    );

    Show Less
  • forum

    QlikView App Dev

    Qlikview: Add an existing PDF-file to a report (and print the combination to PDF...

    Hi All In a dashboard I create a nice report but I want to combine this with an existing report. The external two-pages pdf should become some kind of... Show More

    Hi All

    In a dashboard I create a nice report but I want to combine this with an existing report.

    The external two-pages pdf should become some kind of object that will be embedded into my style. Is this possible?

    Even better would it be that I could define the exact two positions on a page so that the source can be cropped to those two points.

    Anyone who had to deal with such a challenge?

    Thanks,

    Alex

    Show Less
  • forum

    Qlik NPrinting

    Publishing Report to hub in a folder

    I have a NP report which cycles on a field called Program Name. When I publish it to hub, I see that the Report name is Report-ProgramCode and not the... Show More

    I have a NP report which cycles on a field called Program Name. When I publish it to hub, I see that the Report name is Report-ProgramCode and not the friendly name that I have given in the publish task. Is it possible to have the Friendly name shown in the Hub Reports area ? also can we create a folder structure under Reports area in the hub and publish to the hub in the folder ?

     

     

    Show Less
  • forum

    QlikView App Dev

    Qlik Sense xml export

    Hi all,is it possible to export the qlikSense document layout into xml files?Thanks in advance,Sascha
  • forum

    Qlik NPrinting

    NPrinting is not fetching all fields from a Qlik Sense table

    I am creating a report in NPrinting, but I am not able to bring the data of some specific fields, they are in date and percentage format, NPrinting ca... Show More

    I am creating a report in NPrinting, but I am not able to bring the data of some specific fields, they are in date and percentage format, NPrinting can bring the formatting, but it is not bringing the values, can anyone imagine the reason?

    Show Less
  • forum

    Qlik NPrinting

    running total from qlik sense tables

    Hi, I have created an object in Qlik Sense with monthly running totals. I then created a pixel perfect report where I add my table in a level. I now h... Show More

    Hi,

    I have created an object in Qlik Sense with monthly running totals.

    I then created a pixel perfect report where I add my table in a level.

    I now have 2 problems:

    1. the values shown are the values of each months and not the running totals, thus I have to format a sumreport to get the correct values

    2. I have a column which calculate the difference in percentage (Year N - Year N-1)/Year-1 And it does not work.

    For instance, in february, I wanted ((January N + february N )- (January N-1+february N-1)/(January N-1+february N-1).

    I only get (for february) (February N-february N-1) / February N-1.

    Can anyone help please?

    Thanks

    Show Less
  • forum

    New to Qlik Sense

    Qlik sense .Net SDK app theme name

    Hello Everyone, We're using Qlik Sense .Net SDK (14.1.0) in .Net Core 3.0. We need to get  theme name of selected qliksense app but we can't find any ... Show More

    Hello Everyone, We're using Qlik Sense .Net SDK (14.1.0) in .Net Core 3.0. We need to get  theme name of selected qliksense app but we can't find any solution. Does anyone know how to get theme name of qliksense app with .Net Core 3.0.

    Show Less
  • forum

    Japan Healthcare

    令和3年度(R3)DPC調査の"施設概要表"に住所と緯度経度を付けました

    3月22日(水)に厚生労働省のサイトで令和3年度(R3)のDPC調査結果(令和3年度DPC導入の影響評価に係る調査「退院患者調査」の結果報告について)が公開されました。https://www.mhlw.go.jp/stf/shingi2/0000196043_00006.html 昨年の公開データに... Show More

    3月22日(水)に厚生労働省のサイトで令和3年度(R3)のDPC調査結果(令和3年度DPC導入の影響評価に係る調査「退院患者調査」の結果報告について)が公開されました。
    https://www.mhlw.go.jp/stf/shingi2/0000196043_00006.html

    昨年の公開データに比べ、施設数が416施設増えていましたが、全5732施設の住所、二次医療圏、位置(緯度経度)を施設概要表に追記しました。手順は以下の通りです。

    〇追記等の手順
    1.施設概要表の通番を利用して、昨年作成した施設概要表マスタ(住所、二次医療圏、緯度経度)の情報を付加
    2.施設名が変更されており、移転や開院とわかるものは新住所の情報に変更
    3.追加された施設は国土数値情報の医療機関のポイントデータを利用し、住所や緯度経度を取得。ない場合は、HPの住所からGoogle Mapで緯度経度を取得し追記。二次医療圏名も追加

    住所や緯度経度は以下のサイトとGoogle検索を利用して情報を取得し追加しました。
    〇医療機関(国土数値情報)
    http://nlftp.mlit.go.jp/ksj/

    2023年3月29日(水)の医療データ活用勉強会でも解説します。
    https://techplay.jp/event/895905

    添付のExcelファイルをダウンロードしてご利用ください。
    ちなみに、Qlik Senseに取り込むと下図のように施設のポイントを地図上にあらわすことができます。

    Taro_Murata_0-1679823299930.png

     

    Show Less
  • forum

    Qlik Cloud Data Integration

    Report Issues

    Hi All, I am facing a bit weird issue . I have a straight table and a measure like below =Sum([Purchase Amount]). when I export the straight table in ... Show More

    Hi All,

    I am facing a bit weird issue . I have a straight table and a measure like below

    =Sum([Purchase Amount]).

    when I export the straight table in excel, and take the sum of Amount from the excel rows , the total shown in Qlik does not match with the total shown in excel rows. 

    Though the diff is very major, but still it exists. Could it be a number format issue?

    I have set the amount expression fixed to #,##0.00 (done from the Number tab)

    Show Less
  • forum

    Deployment & Management

    Security Rules for a stream

    Hi; I have a stream, inside, there are three published applications. I have two user groups: both read the stream but a group can also export sheet da... Show More

    Hi;

    I have a stream, inside, there are three published applications.
    I have two user groups:
    both read the stream but a group can also export sheet data.

    I knew how to implement the security rule for reading the stream but I didn't have to do the one for exporting data.

    Your help would be appreciated as I'm stuck.

    BELA.

    Show Less

Blogs

Community News

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

Blogs

Qlik Academic Program Blog

Read the latest blog around the Qlik Academic Program.

Blogs

Qlik Product Innovation Blog

If you want to know what's new across all of the products in our growing Qlik product portfolio.

Blogs

Support Updates Blog

Get the latest Support information about end-of-product support, new service releases, and general support topics.

Blogs

Qlik Design Blog

Read all about Qlik solutions: scripting, data modeling, visual design, extensions, best practices and more.

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

Events and Webinars

QlikWorld 2023, Technical Workshops!

10+ hours of roll up your sleeves, immersive working sessions. A $1000 value included in your conference pass!

Choose your workshops

Events and Webinars

Qlik and Qlik Community Hosted Events

Subscribe to our Events and Webinar page so you do not miss an event opportunity!

choose and register

Event

Welcome to Qlik

Join the "Welcome to Qlik" webinar and learn about the Qlik Ecosystem, such as Qlik Community, Learning, and Help.

On-Demand

Events

Upcoming Events and Webinars

There is more than one way to find upcoming events, look on the right side of any Qlik Community forum!

Upcoming

Events and Webinars

Qlik and Qlik Community Hosted Events

Subscribe to our Events and Webinar page so you do not miss an event opportunity!

choose and register

Event

Welcome to Qlik

Join the "Welcome to Qlik" webinar and learn about the Qlik Ecosystem, such as Qlik Community, Learning, and Help.

On-Demand

Events

Upcoming Events and Webinars

There is more than one way to find upcoming events, look on the right side of any Qlik Community forum!

Upcoming