Qlik Community

Welcome to Qlik Community

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

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

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 eight unique blogs. Check out the new Architecture Deep Dive Blog!

Find a forum to ask a question or start a discussion.

Discussion Boards and Documents for Qlik Services.

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

Discussion board and documents related to Qlik Associative Big Data Index.

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.


Make Your Data Dance - Virtual Forum 2019

You’re managing more data than ever before. But are you getting the insights you need? The Qlik Virtual Forum is here to help you take control and make your data dance.

Recent Discussions

  • New to QlikView

    Restrict access vs data model

    Good morning,I have following problem with restricting access to data for users - I have a database containing sales volumen in the branches and ... Show More

    Good morning,

    I have following problem with restricting access to data for users - I have a database containing sales volumen in the branches and for single employees (Akquisitors)
    The goal of this report is to show on 2 charts to each employee (identified by NTNAME in SECTION ACCESS) total sales volume of each branch and his own (employee's) sales volume. Employee cannot see sales volume of his colleagues, only specified users (like branch directors) can do that.

    To be honest I don't know how to define SECTION ACCESS or maybe i need to change the data model?

    SECTION ACCESS;

    LOAD * INLINE [
    ACCESS, NTNAME, ACQUISITOR_NO, BRANCHID
    USER,AT\123025236,*,*
    ];

    SECTION APPLICATION;

    ACQUISTOR:
    LOAD * INLINE [
    ACQUISITOR_NO, Name, BRANCHID
    18291, Name1, 1
    11555, Name2, 1
    11236, Name3, 2
    14214, Name4, 3
    18712, Name5, 2
    ];

    BRANCH:
    LOAD * INLINE [
    BRANCHID, BranchName
    1, Branch1
    2, Branch2
    3, Branch3
    ];

    SALES:
    LOAD * INLINE [
    ACQUISITOR_NO, Vol
    18291, 10000
    11555, 2500
    11236, 12000
    14214, 7800
    18712, 5600
    ];

     

    Many thanks in advance for your help.
    Best regards

    Show Less
  • New to Qlik Sense

    Only show latest project

    Hello Community,I need your help with the following topic. I have an excel table with the columns below: project / status / date For ea... Show More

    Hello Community,

    I need your help with the following topic. 
    I have an excel table with the columns below: 

    project / status / date 

    For each project it is possible to change the status more then once a month. 
    At the end of each month I want to know the latest project status of the month. (E.g. at the 01.02 project status was 'nok' but it changed on 20.02 to 'ok') 
    If I use the count function in the table chart I can see both project status in February. Instead I only want to see the 'ok' status. 

    Have you any advice how to handle? 

    Thanks in advance! 
    Rebecca

    Show Less
  • New to Qlik Sense

    Dynamic Statistical Date

    Hi Expert,Here's my question and if I explain not properly, please don't hesitate to indicate me.I have Account Receivable data set, which has several... Show More

    Hi Expert,

    Here's my question and if I explain not properly, please don't hesitate to indicate me.

    I have Account Receivable data set, which has several fields. Two of them called "Accounting Date" and "Clearing Date".

    I would like to create a bar chart, the x axis would be Statistical Year Month, which is not included in the AR data set.

    And the value should be filter and accumulated by Statistical Year Month, for example,

    If the statistical year month is 2019/3 , and the formula  should be "Accounting Date"<= 2019/3/31 and "Clearing Date">2019/3/31.

    However, I've tried below expression in bar chart and it doesn't work well. Is there anyone could give me some instruction?

    Expression:

    sum({<[Accounting Date]={"<=Date"}, [Clearing Date]={">Date"}>}AR balance Amount)

    Note:

    I generate a "StatDate" table contain three fields which is Date, Year , Month for bar chart X axis (Statistical Year Month).

    Show Less
  • Qlik NPrinting Discussions

    NPrinting pixelperfect y axis adjust to values

    Hi, I have a line chart in NPrinting in pixel perfect and I would like the start point of the Y axis to be adjustable to the data and not to start alw... Show More

    Hi, I have a line chart in NPrinting in pixel perfect and I would like the start point of the Y axis to be adjustable to the data and not to start always in the 0 position.

    Is there any option in NPrinting to adjust the start of the Y axis based on the existing data and not to start at 0?

    asfddsa.PNG

    Thank you.

     

    Best regards.

    Show Less
  • Qlik NPrinting Discussions

    NP16-Recipients import how to set notification to "Send reports to ..." instead ...

    Hiwith NP16 I import recipients with different settings - but I can´t find setting for the notification of a recipient.This is always set to: "Replace... Show More

    Hi

    with NP16 I import recipients with different settings - but I can´t find setting for the notification of a recipient.

    This is always set to: "Replace groups e-mail addresses with these e-mail addresses"

    I would like to set it to: "Send reports to these e-mail addresses in addition to groups e-mail addresses"

    Thanks for help

    Michael

     

    Show Less
  • Qlik Sense Deployment & Management

    Import data - Error message: 400 Bad Request

    Hi,Need advice. 😞There were some changes with the certificates and we ran into some trouble. Our solution was to completely re-install the server. No... Show More

    Hi,

    Need advice. 😞

    There were some changes with the certificates and we ran into some trouble. Our solution was to completely re-install the server. Now I want to re-import the apps but I get following message:

    import1.png

    In the log file I find this message: Bad Request [400]:Bad Request() (HTTP code: 500)

    I found this information, but I don't this this will be the case for us:

    https://help.qlik.com/en-US/sense/April2019/Subsystems/ManagementConsole/Content/Sense_QMC/troubleshooting-managing-QMC.htm#anchor-1

    Anything that I can try? Any help is very welcome.

    If more information is needed, please ask.

    Best regards,

    Ramzi

    Show Less
  • Qlik NPrinting Discussions

    Qlik Sense Qliknprinting on-demand extension- report downloads

    Hi all,After much trouble-shooting, we were able to get the on-demand extension (available on the qlik branch) working for qlik nprinting in our qlik ... Show More

    Hi all,

    After much trouble-shooting, we were able to get the on-demand extension (available on the qlik branch) working for qlik nprinting in our qlik sense instance.  It was pretty nifty for a day or so- then something changed so that when any user clicks a button in the qlik sense report to download, it now loads (as it did before), but does not show a download arrow button to then download the generated report (SEE SCREENSHOT IN ATTACHMENT).

    The only things I'm able to narrow down that changed are:

    1. Gave the user role more permissions (to make sure my new users could actually download the file without having developer access)

    2. Added about 15 additional user accounts with the updated user role

    I can't find record of the original user role permissions to reset the user role too, and I've disabled (though not deleted) the new user accounts in case to try to revert back to the 5-6 user accounts I had created originally that were working.  I have all the roles (admin, user, developer, newstand user), yet am facing the same download issue as my other users.

    What am I missing here?  Suggestions on what to try next?

    Thanks!
    Katie

    Show Less
  • Qlik Sense Deployment & Management

    summary by group

     my expression => Num(Sum(netamt)/Sum(Total netamt),'#,##0.0 %') what if I want the percentage of room type to be calculated per yea... Show More

    Capture.JPG

     

    my expression => Num(Sum(netamt)/Sum(Total netamt),'#,##0.0 %')

     

    what if I want the percentage of room type to be calculated per year??

    Show Less
  • Qlik NPrinting Discussions

    Email : Only if nprinting task runs successfully

    We are running in a scenario where nprinting task fails for the first time and runs successfully when we run it again.The issue is we have Email confi... Show More

    We are running in a scenario where nprinting task fails for the first time and runs successfully when we run it again.

    The issue is we have Email configured based on a variable condition and due to task failure for the first time incorrect mail is triggered to users.

    Is there any way we can control sending an email based on completion of nprinting task?

    Show Less

Blogs

Qlik Community Blogs

Check out our community blogs to stay current on the latest and greatest information about Qlik products.

7 Blogs

Groups

Join a Group

Join one of our Qlik Community groups related to an Industry, Location, Language, or Topic.

28 Groups

Events

Events & Meetups

Participate in an upcoming Qlik related event, webinar, or local meetup.