Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
2,002 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 QlikWorld Online.

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.

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

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!

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

Discussion Boards and Documents for Qlik Services.

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

  • New to Qlik Sense

    Sorting Dimensions

    I am using a stacked bar chart with one dimension being a number format (stack), while the other dimension is character (bar). I'd like to sort this c... Show More

    I am using a stacked bar chart with one dimension being a number format (stack), while the other dimension is character (bar). I'd like to sort this chart by the number dimension(bottom 5) in ascending order using that dimension. However by default, Qlik is using the measure to sort my stacked dimension. This default sorting by the measure is not my preference for displaying the information of interest.

    Thanks

    Show Less
  • Qlik Sense App Development

    Null Values in Above() function produce wrong results

    Hi,I'm using following expression to get my accumulation values. but if I get any null values in the dimension then my accumulation sum is giving wron... Show More

    Hi,

    I'm using following expression to get my accumulation values. but if I get any null values in the dimension then my accumulation sum is giving wrong result. Can some one help me on this?

    =Range Sum(Above(TOTAL sum(SYSTEMS),0, Row No(TOTAL)))

    Acc.PNG

     

     

     

    Show Less
  • Qlik NPrinting Discussions

    Qliksense Rest API Script to NPrinting Broken After updating Both Nprinting and ...

    Hi AllI recently updated Qliksense to Feb 2020 Patch 1 and NPrinting to Feb 2020 SR1. I redistributed the certificates and all is working well (Nprint... Show More

    Hi All

    I recently updated Qliksense to Feb 2020 Patch 1 and NPrinting to Feb 2020 SR1. I redistributed the certificates and all is working well (Nprinting talking to sense all fine)

    The only issue I have now is with a script I use in sense that uses rest connectors to publish tasks on NPrinting.

    When testing the Rest Connectors they work fine. it seems the vCookie varible ends up blank and all subsequent calls fail with a 403 error.

    After the below script runs the vCookie variable ends up empty although the vCookieRaw varible contains a bunch of text.

    I'm guessing something has changed in the new versions and I am no longer able to get the Cookie data? Can anybody assist?

     

    LIB CONNECT TO $(vAPIConnectionNameForGET);


    let vEndpoint= vNPrintingServer & '/api/v1/login/ntlm' ;

    RestConnectorMasterTable:
    SQL SELECT
    "Content-Length",
    "Cache-Control",
    "Content-Type",
    "Date",
    "Set-Cookie",
    "Server",
    "__KEY__response_header",
    (SELECT
    "result",
    "code",
    "message",
    "__FK_root"
    FROM (wrap on) "root" FK "__FK_root")
    FROM JSON "_response_header" PK "__KEY__response_header"
    with Connection (URL "$(vEndpoint)");

    [_response_header]:
    LOAD
    [Set-Cookie] AS [Set-Cookie]
    RESIDENT RestConnectorMasterTable
    WHERE NOT IsNull([__KEY__response_header]);


    //Set Cookie header

    let vCookieRaw = peek( 'Set-Cookie',0,'_response_header');

    if vSSL='No' then
    let vCookie=TextBetween('$(vCookieRaw)','HttpOnly,','Path=/',1);
    else
    let vCookie = TextBetween('$(vCookieRaw)','Secure;','Path=/',2);
    end if


    //Remove login tables
    DROP TABLES RestConnectorMasterTable,[_response_header];
    //exit script;

    Show Less
  • New to QlikView

    May I have link to learn Qlik View?

    Hi All, This is my first post, can some one share the link for me to learn Qlik View
  • Qlik NPrinting Discussions

    Qlikview Nprinting lagging when generating report

    Hi,I have been battling the whole day with Nprinting.I have tried to send myself a Powerpoint  report via the task but it is not working. The status k... Show More

    Hi,

    I have been battling the whole day with Nprinting.

    I have tried to send myself a Powerpoint  report via the task but it is not working. 

    The status keeps on "running" for hours.

    I tried putting on filters but still cant generate the Powerpoint report. What could be the problem?

    Show Less
  • New to Qlik Sense

    Send filter table from a report by email without QlikNPrinting

    Hi all,I have a report with many graph. In this report, I created a table with many columns, they come from my database.In this table I have a column ... Show More

    Hi all,

    I have a report with many graph. In this report, I created a table with many columns, they come from my database.

    In this table I have a column "Service" with many values "Informatic" "Finances" "Education" "Travel" ...

    Actually, every day, I choose a service in this table (for example "Informatic"), I export the results of the table and send it by email to the responsable of the informatic service.
    I do the same for each service (I send the results to the responsable of each service).

    Unfortunately, I have 50 services so it's very very long.

    It's possible to do the same thing automatically ?

    I have Qlik Sense Enterprise

    Thanks you very much.

    Show Less
  • Qlik NPrinting Discussions

    NPrinting ignores cell formatting

    Hi guys,I have this issue that I have tried to resolve myself for a week or two where the values of my straight tables are rendering in reports under ... Show More

    Hi guys,

    I have this issue that I have tried to resolve myself for a week or two where the values of my straight tables are rendering in reports under the 'General' format instead of what I have chosen. I have posted some screenshots to help explain:

    1. The qvw with the correct number format (some other tables will need to be a % or have different decimals). I have tried formatting in the expression itself as a workaround but it did not work. I can't select 'Keep source formatting' for this project.

    1.PNG

    2.  The structure of the Template. You can see the cell is formatted to number. The table will expand across 5 cells and each is formatted to replicate how it is seen in the qvw. Each row will be a different table.

    2.PNG

     

    3. The result. It has ignored the formatting of the expression and the template editor and reverted to 'General'.

    3.PNG

     

    I have browsed before posting this question but I could not see a resolution, there were some considered solved but it was for QlikSense, and one post assumed that this problem would be fixed in a newer version of NPrinting (I started this project in NP 16.7 and continued it in the Feb 2020 version).

     

    It might not mean much but I did a direct export from the table in the qvw to an excel file just in case the server settings was overruling it and it was matching the qvw.

    Show Less
  • Qlik NPrinting Discussions

    NPrinting Report 'levels' function - how do I filter out null values?

    Morning,I am trying to set up a basic Nprint report which shows all invoices generated per customer... in order to do this I have added a Level into t... Show More

    Morning,

    I am trying to set up a basic Nprint report which shows all invoices generated per customer... in order to do this I have added a Level into the report.

    Snap 2020-04-02 at 11.03.03.png

    When the report runs, it includes ALL customers even those that have no sales / invoices.

    Snap 2020-04-02 at 11.05.53.png

    The source table in Qlik Sense is set to ignore null values, so only those customers with sales / invoices are displayed. How do I replicate this in the NPrinting report, so that customers with no sales / invoices are ignored? I cannot find any Nprinting options to enable me to do this.

     

    Thanks

    Craig

     

    Show Less
  • Qlik NPrinting Discussions

    variable expansion help

    Hi ,Can any one help me on variable expansion in NPrinting.I have passed the variables from csv file into qliksense app. There is no equal sign on var... Show More

    Hi ,

    Can any one help me on variable expansion in NPrinting.

    I have passed the variables from csv file into qliksense app. There is no equal sign on variable definition in CSV file.

    In Qliksense apps we have used these variables like =$(vTSCandidatesCount) but in N printing its not Working.

    could you please explain with this example how to call it in N Printing from variable expansion.

    tscount.png

     

     

    Preview: 

    Preview.png

     

    Thanks in advance

    Show Less
  • New to Qlik Sense

    13 months

    Hi All,For Fiscal Month i have values from Apr to Mar. I need a extra value 'ABC' added to fiscal month. From the transaction table, the master calend... Show More

    Hi All,

    For Fiscal Month i have values from Apr to Mar. I need a extra value 'ABC' added to fiscal month. From the transaction table, the master calendar is generated. How to do this?

    Show Less

Blogs

Qlik Community Manager Blog

Hear from the Qlik Community team about the latest platform enhancements for December 2019 and January 2020.

Blogs

Customer Success Blog

Read all about Qlik's Voice of the Customer program and Customer Success initiatives.

Blogs

Blogs

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

Groups

Qlik Insight Bot

Join the Qlik Insight Bot Group and bring the power and simplicity of natural-language, conversational analytics to everyone in your organization

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

The Human Impact of Data Literacy

Boosting the data skills of your entire workforce can exponentially increase your data’s value. In this webinar, discover the big opportunity in data literacy.

March 25, 2020 Webinar

Events

Events & Meetups

Participate in an upcoming local Qlik Meetup


Events

What's New in 2020?

Join us on for a deep-dive discussion and tailored product demonstration on the newest capabilities delivered as part of Qlik’s most recent product release.

Now Available on Demand