Qlik Community

Welcome to Qlik Community

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

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


Introducing Qlik Gallery

Announcing the newest addition to the Qlik Community, Qlik Gallery!

Qlik Gallery is all about sharing – apps, outcomes, and ideas. This is your space to learn from each other as Qlik users, fans, thought leaders and data enthusiasts

Recent Discussions

  • Qlik Sense App Development

    Struggle with Data Joins

    Hi everyone, I have got a problem to solve, if you've any idea please write about it, i would be appreciate.I've a data set like table 1, if the compa... Show More

    Hi everyone, 

    I have got a problem to solve, if you've any idea please write about it, i would be appreciate.

    I've a data set like table 1, if the company can not deliver all of order quantity, system will split. And make 2 new orders which have the same main order no. Like the row no 1,2,3. If still can not deliver the rest of the 2.step of no delivered order, again system split the quantity again. It can be go forever like this (: In my data set I saw 10 step split movement. 

    What i need is in table 2. I need the main order in one raw and the delivered - not delivered in by columns. I thought the join the orders table by itself but i don't know the splitting count of each main order. I think I need to use something like while loop but at the same time it s not a small table, it s like 500 k rows so I need also performing thin. So thanks for now.

    table 1:

    Order NoMain Order NoQuantityState
    1NULL10Not Delivered
    215Delivered
    315Not Delivered
    433Delivered
    532Not Delivered
    652Delivered
    7NULL5Not Delivered
    871Delivered
    976Not Delivered

     

    table 2:

    Main Order NoDelivered Order No 1Not Del Order No 1Delivered Order No 2Not Del Order No 2Delivered Order No 3
    123456
    789NULLNULLNULL
    Show Less
  • QlikView App Development

    Change date field format from Google Analytics API

    I've pulled in data in Qlik Sense (cloud) from the Google Analytics connector. I'm trying to convert the standard date [ga_dateHourMinute] field to a ... Show More

    I've pulled in data in Qlik Sense (cloud) from the Google Analytics connector. I'm trying to convert the standard date [ga_dateHourMinute] field to a more eligible date format.

    The current format is YearMonthDayhHourMinute, for instance: 201810250004, I would like to convert this to the standard date format 2018-10-25 00:04:00. How do I do this? Answers concerning methods in the data load script or master formula's or variables are all welcome.

    Click to see screenshot: left = current date format and right = desired date format

    Show Less
  • New to Qlik Sense

    CHART - USING TWO DIFFERENT DATE FIELDS

    I have two date fields.  Date discharged & date completed.  I would like to display the month of discharge (Sept) but include  the number completed (r... Show More

    I have two date fields.  Date discharged & date completed.  I would like to display the month of discharge (Sept) but include  the number completed (regardless of when discharged). I started with bar and line graph.  Example.  A service will be discharged in July but the date completed (of final paperwork) didn't occur until September.  If I am running the report in September I want to see the number of discharges for Sept and the number of completions in Sept (which would include the july discharge)as a comparison. Make sense?  

    Show Less
  • QlikView App Development

    How to spot an Alternate State has been chosen

    Hi I'm using Alternate State in my QV document to compare two financial periods.I have a table with a number of expression based columns and what I wa... Show More

    Hi 

    I'm using Alternate State in my QV document to compare two financial periods.

    I have a table with a number of expression based columns and what I want to do is to hide the alternate state column if the user has not selected any of the alternate state options by using the conditional function on the Expression.

     

    clipboard_image_0.png

     

    Anyone got an idea how to do this? 

    TIA

    Andy

    Show Less
  • Qlik Sense Data Connectivity

    SaveToFile using Qlik Web Connector

    HiI'm trying to use the Qlik General Web Connector (May 2019) to download a file from a URL.  This worked using an older version of the connector, but... Show More

    Hi

    I'm trying to use the Qlik General Web Connector (May 2019) to download a file from a URL.  This worked using an older version of the connector, but I can't get the May 2019 version to work.  The connector is running as a service and is licenced.

    I've selected the Request Method (GET), entered the Request URI, checked the "Is File" checkbox and entered the File Name.  I've added the folder that is in the File Name to deploy.config.  When I click on "Save Inputs and Run Table", the connector displays "Running... Making request to https://data.gov.au/data/dataset/8ab10b1f-6eac-423c-abc5-bbffc31b216c/resource/8d06d260-5b08-4d20-9d31-c4c9bd8b5bc2/download/privatehealth-01-oct-2019.zip" which is the file I am trying to download.  From there nothing else happens, it just hangs on that message until I cancel.  If I paste the URL into the browser the file is downloaded.

    This does work with an older version of the connector, but that doesn't give the required script for Standard Mode.

    Any suggestions?

    Thanks

    Show Less
  • Qlik Sense App Development

    Article# 000034667

    Hi Qlik,Read about a document on how to use security rule for enabling the sharing of bookmarks from this article: https://community.qlik.com/t5/New-t... Show More

    Hi Qlik,

    Read about a document on how to use security rule for enabling the sharing of bookmarks from this article: https://community.qlik.com/t5/New-to-Qlik-Sense/Sharing-bookmarks-between-users/td-p/1540877

    Am I able to get a hold of that document ?

    Thanks,

    Aladdin

    Show Less
  • Qlik Sense Integration, Extensions, & APIs

    Qliksense Mashup: Retrieve active object in a container

    Hi,I am building a mashup.I have a container which holds different objects. Is there a way I can access the active object from inside mashup java scri... Show More

    Hi,

    I am building a mashup.

    I have a container which holds different objects. Is there a way I can access the active object from inside mashup java script code.

    Thanks,

    Jyotsna

    Show Less
  • Qlik NPrinting Discussions

    Nprinting Designer can't find a supported reporting template editor for file....

    Getting the Dreaded Nprinting Designer can't find a supported reporting template editor for the file.... error.I have the Office Click to Run Version ... Show More

    Getting the Dreaded Nprinting Designer can't find a supported reporting template editor for the file.... error.

    I have the Office Click to Run Version installed. Version 1902 (Build 11328.20420 Click-to-Run) (it's the 64 bit version)  it is installed locally also.

    The screen adjustment comments have nothing to do with the error that everyone posts about.

    Is it that I have the 64 bit version of MS Office, not the 32 bit?  is it because Nprinting is looking in the Program Files x86, and not Program files?

    We upgraded to the latest version of Nprinting this weekend 10/19/2019   September 2019 version 19.29.3.0 hoping that would fix the issue.  It did not.

    Show Less
  • QlikView App Development

    Hyperlink does not work after QlikView April 2019 upgrad

    Hi Experts,I have used file folder path similar to below as hyperlink in the dashboard chart expression.The path used to open the folder as normal and... Show More

    Hi Experts,

    I have used file folder path similar to below as hyperlink in the dashboard chart expression.

    The path used to open the folder as normal and it worked before the April 2019 upgrade.

    It works on the desktop too. However, it stopped working on AccessPoint once I upgraded to April 2019 version. Does not work both on IE and on chorme.

    'C:\Users\ssreeramula'

    Can you please let me know what mistake I am doing.

     

    attached is the sample QVW.

    Show Less
  • Qlik NPrinting Discussions

    Nprinting Condition Task

    Hi,I have a table with 4 Fields:1- Brand2- Product3- Date4- Stocki want to create Condition task in nprinting 18 Nov, when the stock of any product fr... Show More

    Hi,

    I have a table with 4 Fields:

    1- Brand

    2- Product

    3- Date

    4- Stock

    i want to create Condition task in nprinting 18 Nov, when the stock of any product from any branch on any date = 0,

    Send me a report details (Brand, Product and Date).

    Thank you

     

    Show Less

Blogs

Qlik Community Manager Blogs

Hear from the Qlik Community team about the latest platform enhancements, announcements, and more.

Blogs

Qlik Education Blog

Check out the latest Education Blog written by Kevin Hanegan,Qlik Chief Learning Officer.

Blogs

Blogs

Hear directly from Qlik employees and stay current on the latest and greatest information about Qlik products. We have 8 blog types for you to choose from.

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 Insider Webinar Series

What's New in 2019. Register for the Qlik Insider Webinar Series to stay connected on our latest releases

Available On Demand Webinar

Events

Events & Meetups

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

Events

Welcome to Qlik

Join the “Welcome to Qlik” webinar and learn about the Qlik Ecosystem

Tuesday, August 27, 2019 Webinar