Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
3,196 online

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.

This forum will provide you with event highlights and related content to get you energized and ready for Qlik’s largest customer and partner event of the year.

Here you will find Qlik Sense resources, partake in interesting discussions, solve problems and foster relationships with Qlik experts from around the globe.

Thank you for joining us in the QlikView Forum, your home for QlikView answers. Discover insights within your data that can transform your business.

Discussion Boards and Documents for Qlik Services.

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 nine unique blogs. Check out the new Customer Success Blog!

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

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.

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

Recent Discussions

  • QlikView Deployment

    Sub total between rows in Financial tables (in Pivot tables)

    I have an excel sheet which i'm trying to take  P&L Setup and B/S setup. I can bring the all accounts with interval match but I could not bring the "s... Show More

    I have an excel sheet which i'm trying to take  P&L Setup and B/S setup. I can bring the all accounts with interval match but I could not bring the "sub total" lines according to between RowFrom and RowTo columns. I'm adding my Excel file.

    I'm using in my expression but it does not help, can some one send me a sample?

    if(RowType = 'Regular',Sum({<[Fiscal Year]={$(vYTDYear)} >} Amount),
    if(RowType = 'Sum',aggr(Sum({<[Fiscal Year]={$(vYTDYear)}, RowNo= {"<=RowTo"}>}Amount), ReportRowGroup)
    ))

    Regular part is coming but Sum parts are not coming? Please advise

    Show Less
  • New to Qlik Sense

    Addition

    Hi Team,I have a below table.PH6PH6_descSales T/O231546BV 5461163729255373VAG Produkte1092099221051El. fusion fitti. PB880487201950Solv.cement fitt.me... Show More

    Hi Team,

    I have a below table.

    PH6PH6_descSales T/O
    231546BV 5461163729
    255373VAG Produkte1092099
    221051El. fusion fitti. PB880487
    201950Solv.cement fitt.me.874874
    230152Solv. Cement Fit. mm689215
    202956Ballvalves for water550592
    230153Adapter Fittings mm531082
    251313ELGEF Plus saddles464251
    221043Pipe PB in bars451753
    2J1J54Regulierarmaturen432843

     

    Further I want to add new column as below. Kindly help me in doing this.

    PH6PH6_descSales T/ONew ColumnDescription
    231546BV 54611637291163729For the first row the value should be same as Sales T/O(1163729)
    255373VAG Produkte10920992255828Addition of 1st row and 2nd row of Sales T/O(1163729+1092099)
    221051El. fusion fitti. PB8804873136315880487+2255828
    201950Solv.cement fitt.me.8748744011189874874+3136315
    230152Solv. Cement Fit. mm6892154700404689215+4011189
    202956Ballvalves for water5505925250996550592+4700404
    230153Adapter Fittings mm5310825782078531082+5250996
    251313ELGEF Plus saddles4642516246329464251+5782078
    221043Pipe PB in bars4517536698082451753+6246329
    2J1J54Regulierarmaturen4328437130925432843+6698082

     

     

    Show Less
  • New to Qlik Sense

    Table Chart Manipulation (RowNo)

    Hello,Please help me with the following. In the table below, I have columns "Index", which is the function RowNo(total), and "Hours". I am interested ... Show More

    Hello,

    Please help me with the following. In the table below, I have columns "Index", which is the function RowNo(total), and "Hours". I am interested in getting the column "Result". Essentially, "Result" is "Index", but the difference is where the observations "Hours" have the same value, I sum their corresponding "Index" and then divide by the number of "Index".

    For instance, for "Hours" 2, the frequency is 3. We do: (2+3+4)/3 = 3. For "Hours" 4: (5+6)/2=5.5. For "Hours" 6: (8+9)/2=8.5. All in all, I want to come up with an expression(charts only, no script) where I use the first two columns to get the third column.

    IndexHoursResult
    111
    223
    323
    423
    545.5
    645.5
    757
    868.5
    968.5
    10810

     

    Here is what I have done so far, but has not been working as desired:

    if (pick(count(total [Hours]) - rowno(total) + 1, $(=concat([Hours], chr(44), -[Hours]))) =
    pick(count(total [Hours]) - rowno(total) + 2, $(=concat([Hours], chr(44), -[Hours]))), rowno(total)+rowno(total)-1,
    rowno(total))

    Thank you for your time and help.

    JF

    Show Less
  • QlikView App Development

    Blank Rows Comes when using Hierarchy Fuction

    Hi All ,I am using just a simple script to load the hierarchy , but i am geting 1 bank roe at each level . please tell why ?A:Hierarchy(X,Parent,Des)L... Show More

    Hi All ,

    I am using just a simple script to load the hierarchy , but i am geting 1 bank roe at each level . please tell why ?

    A:

    Hierarchy(X,Parent,Des)

    LOAD Des,

         ID   AS X,

         Parent

    FROM

    (ooxml, embedded labels, table is Sheet1);

    Hierarchy_New.jpg

    Show Less
  • Qlik Sense Deployment & Management

    Where to find Hub initiated reload information?

    We are currently experiencing some performance issues in our Qlik Sense site and have been monitoring app reloads from the reload monitor app. However... Show More

    We are currently experiencing some performance issues in our Qlik Sense site and have been monitoring app reloads from the reload monitor app. However it only appears to show apps reloaded on a schedule or manually from the QMC.

    We are concerned that a large number of Hub reloads could be causing performance degradation and so would like to see information in relation to this i.e. how many have been triggered and from which apps, but we can't find anything. Where can this information be found?

    Show Less
  • QlikView Scripting

    How to aggregate the costs of each individual BOM level in connection with MS Na...

    Hello QLIK Community,at the moment I am despairing of the following topic and I hope someone can assist me here. What is it about:It should be possibl... Show More

    Hello QLIK Community,

    at the moment I am despairing of the following topic and I hope someone can assist me here. What is it about:

    It should be possible to aggregate the costs of each individual BOM level so that the total costs (material costs, production costs) for the product are visible at the end. The used ERP ist Microsoft Navision 2009.

    I know that the "Hierarchy" syntax should work but i don´t have any clue, how to use it correct. At the moment I use the following script similar to that topic: https://community.qlik.com/t5/QlikView-Scripting/Bill-of-Materials-from-Navision/td-p/414790

    Fakten_BOM:

    Hierarchy ( Article_Nr., BOM_Nr., Node_Name, BOM_Name,Child, Pathfield,'|',Level)
    Load

    Article_Nr.,

    Article_Nr. as [Node_Name],

    BOM_Nr.,

    BOM_Nr. as BOM_Name,

    Description

    Version

    Art,

    Amount


    FROM
    [XYZ.qvd]
    (qvd);

     

    The result is not as desired, because within my Table-Box I only see results until Level 2. But there are at least 8 Levels within BOM´s.

    Does anyone have an experience in aggregating the costs of each individual BOM level in connection with MS Navision? If so can you give me a hint how to solve the problem? 

    Many thanks in advance

    Greetings

    Manuel

    Show Less
  • Qlik NPrinting Discussions

    Store excel attachments in a place, again send them by a different report.

    I have a Nprinting 16.9 report in which I'm applying filters on owners and sending them mails. However, the xls attachment needs to be formatted befor... Show More

    I have a Nprinting 16.9 report in which I'm applying filters on owners and sending them mails. 

    However, the xls attachment needs to be formatted before I send. I have created a macro to do so.

    Is it possible that with one report task, I create the files and store in a location.

    The next report will pick the files from the location and trigger the mails. 

    Please help!

    Show Less
  • New to QlikView

    Expression not working

    Hi AllPlease find below my problem. My Table only contains these 4 fields and a variable called vPreviousPeriod that is equal to 201910 at the moment.... Show More

    Hi All

    Please find below my problem. My Table only contains these 4 fields and a variable called vPreviousPeriod that is equal to 201910 at the moment.

    I've created 2 textboxes so you can see what I am trying to do. The top one, shows the expression I'm using. The bottom one, the result.

    I want to get the FINYR_CALL for the max(CALLMONTH) but its not working.

    Please may you assist with my expression?

     

    Thanks

     
     

     

    Show Less
  • New to Qlik Sense

    How can I place my local application?

    Guys, now I have my qlikview application finalized and I would like to leave it in a browser, how can I do that? Local Only.(I would like to see it wo... Show More

    Guys, now I have my qlikview application finalized and I would like to leave it in a browser, how can I do that? Local Only.

    (I would like to see it working in a browser)

    Show Less
  • QlikView Layout & Visualizations

    Text objects as images not working properly

    Text obj with images as expression (with relative path, e.g., ='..\data\img\imagefil.png') are not working properly. When the path is correct, the obj... Show More

    Text obj with images as expression (with relative path, e.g., ='..\data\img\imagefil.png') are not working properly. When the path is correct, the object is blank (its configured without a background). If invalid path, it works showing the invalid path.

    This behavior started after upgrade to april 2019 version (12.40.20200.0)

    Show Less

Blogs

Qlik Community Manager Blog

Hear from the Qlik Community team about the latest platform enhancements for October and November 2019.

Blogs

Qlik Support Updates Blog

Read the latest blogs from Qlik Support and get important and useful support information.

Blogs

Blogs

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

Groups

Join a Group

Join one of our Qlik Community user groups around an Industry, Location & Language, or Topic.

Groups

Qlik Deployment Framework

This group hosts information related to the Qlik Deployment Framework (QDF).

2700+ Members

Groups

Qlik Healthcare

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

750+ Members

Events

Qlik World 2020

Transform your digital world. Join us for our annual conference (formerly Qonnections) in Phoenix, AZ. Register by January 31, and save $300.

May 11- 14, 2020 Global Conference

Events

Events & Meetups

Participate in an upcoming local Qlik Meetup


Events

Customer Spotlight Series

Discover the secrets behind data-driven transformation with real-world examples from Qlik customers.

Watch the Series Today