Qlik Community

Welcome to Qlik Community

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


Reducing Analytics Cycle Time with DataOps

DataOps is a powerful new discipline that accelerates your entire data supply chain, from ingestion to insight – so you can make data-driven initiatives sustainable once again. How can you put DataOps to work in your business? Register now for the September 26, 2019 webinar: Reducing Analytics Cycle Time with DataOps.

Recent Discussions

  • Qlik Sense App Development

    Show only customers who did order products by state_didbuy and not state_didntBu...

    Hello,I try to use alternate state to make it possible for end user to get insights which customer did order specific products (state_didBuy) and did ... Show More

    Hello,

    I try to use alternate state to make it possible for end user to get insights which customer did order specific products (state_didBuy) and did not order specific other products (state_didntBuy).

    For example: Show only customers who did order more than 2 drinks, but didn't order any burger this year. 

    I only want to show customers in the table for whom criteria apply with sum(of state_didBuy)

    Is this possible?

    I did include sample qvf

    The result with sample data should be only cust2 and cust3

    Regards,

     

    Show Less
  • QlikView App Development

    Condition using MAX() in IF... else

    I surprised to find out that Max() cant be used in conditional statement of IF. I was trying to use ::if(max(marks)=marks, Rollnumber)type of statemen... Show More

    I surprised to find out that Max() cant be used in conditional statement of IF. I was trying to use ::

    if(max(marks)=marks, Rollnumber)

    type of statement. but its showing "error in expression".

    Even set analysis isnt helping to get solution :

    sum({$<marks={$(max(marks))}>} Rollnumber)

    Is it something wrong with my approach or QV doesnt allow function in Conditions??

    Show Less
  • New to Qlik Sense

    Sum of a Valuelist by Dimension

    Hi,I am using Valuelist to built a table I have 2 dimensions(State and Status) and a single measure using Valuelist as seen below=If(ValueList('A... Show More

    Hi,

    I am using Valuelist to built a table 

    I have 2 dimensions(State and Status) and a single measure using Valuelist as seen below

    =If(ValueList('A', 'B','C')= 'A', COUNT({<[status] = {'A','B'},current_month = {'Current'}
    >} DISTINCT Id),
    If(ValueList('A', 'B','C')= 'B',COUNT({<[status] = {'B'},current_month = {'Current'},[Target Type] = {'B'}
    >} DISTINCT Id),
    If(ValueList('A', 'B','C')= 'C',COUNT({<[codes] = {">=1"}, [status] = {'B'}>} DISTINCT [Id]),
    )))

    This gives the following output 

    clipboard_image_0.png

    Which is correct but I need to add another column sum by the state so that I get an output like 

    clipboard_image_1.png

     

    I tried adding sum and total to the above measure but I am not getting the desired output 

    Show Less
  • Qlik NPrinting Discussions

    QlikView app returning incorrect data to NPrinting

    I'm encountering an odd issue with NPrinting June 2019 and QlikView 12.4. I have an NPrinting report that connects to a QlikView app to generate ... Show More

    I'm encountering an odd issue with NPrinting June 2019 and QlikView 12.4. I have an NPrinting report that connects to a QlikView app to generate an Excel recipient file, to be imported into the NPrinting user database. (My report's Excel template uses the sheet/column layout specified in Recipients.xlsx -- extracted from Examples.zip, which I downloaded from the NPrinting help page. The QlikView app has a hidden tab containing three tables -- Filters, Users, and Groups -- which expose the data referenced in the Excel template. I'm not using nor exposing the Filters sheet's Advanced Search.) When I run the publish task to run the report to generate the recipients file, the data on the Filters sheet is in the wrong columns; i.e., rather than this:

    Name | Description | App | Enabled | Connection | Values | Numeric Values | Formulas | Advanced Search
    <Name> | <Description> | <App> | <Enabled> | <Connection> | <Values> | <Numeric Values> | <Formulas>

    The data looks like this:

    Name | Description | App | Enabled | Connection | Values | Numeric Values | Formulas | Advanced Search
    <Name> | <Values> | <Description> | <App> | <Enabled> | <Connection> | <Numeric Values> | <Formulas>

    Note that the data in the second through sixth columns is mixed up. (The data on the Users and Groups columns is correct.) Not surprisingly, the data on the Filters sheet being in the wrong columns is causing the corresponding import task to fail!

    I worked around the issue by changing the report's template to output each of the second through sixth columns in the 'wrong' location; i.e.,

    Name | Description | App | Enabled | Connection | Values | Numeric Values | Formulas | Advanced Search
    <Name> | <App> | <Enabled> | <Connection> | <Values> | <Description> | <Numeric Values> | <Formulas>

    This results in a correct recipient file which can then be imported.

    What steps have I taken to try to resolve this? I deleted and re-pasted the data columns in the Excel template. I deleted and re-imported the three table objects in the Excel template. I reloaded the connection's metadata. I deleted and re-created the report and template. I even deleted and re-created the connection and the app. I created a new report and template. No change. I'm not seeing this issue with any other NPrinting / QlikView apps.

    What could be causing this issue?

    Show Less
  • Qlik Sense Advanced Authoring

    Rolling sum by ID and Date

    Dear Experts,I need to figure out how to do a rolling sum in the Qlik sense.I have the data as shown belowCurrent table  iddatevalue1Jan101F... Show More

    Dear Experts,

    I need to figure out how to do a rolling sum in the Qlik sense.

    I have the data as shown below

    Current table  
    iddatevalue
    1Jan10
    1Feb20
    1March30
    1April40
    1May50
    2Feb10
    2March20
    2May30
    2June40

     

    Need the data  as below

    Required Table   
    iddatevalueCummulative
    1Jan1010
    1Feb2030
    1March3060
    1April40100
    1May50150
    2Feb1010
    2March2030
    2May3060
    2June40100

     

    Thanks for your time

    Show Less
  • New to Qlik Sense

    Drill Down / Parent Child?

    Question.  I have on my dashboard a table chart with a few columns (Sales person, invoice#, sales total). When the user clicks on a row, how... Show More

    Question.  I have on my dashboard a table chart with a few columns (Sales person, invoice#, sales total). 

    When the user clicks on a row, how can I navigate to a different sheet and show all additional detail information based on the click? 

     

    Show Less
  • New to Qlik Sense

    How-To Link / Navigate to Detail sheet?

    I have a KPI that shows Total Sales along with many other KPIs with single values.  The user wants to be able to CLICK on said KPI (Total Sales) ... Show More

    I have a KPI that shows Total Sales along with many other KPIs with single values.  The user wants to be able to CLICK on said KPI (Total Sales) and have it navigate them to a different sheet with all the Detail information related to the (Total Sales).

     

    How can i do this?

    Show Less
  • QlikView Layout & Visualizations

    QlikView 12.4 SR1 Pivot Table issue

    We have just upgraded from QV 12.1 SR8 to QV 12.4 SR1 in our test environment.We are seeing what looks like a bug in pivot tables.If any dimension in ... Show More

    We have just upgraded from QV 12.1 SR8 to QV 12.4 SR1 in our test environment.

    We are seeing what looks like a bug in pivot tables.

    If any dimension in the pivot table contains a function or even a comment after the field, when the pivot table is collapsed the dimension headers are still visible.

    The forum won't allow me to post an image.

    If we remove the function or comment so the dimension is just a field name, then the dimension headers collapse as expected.

    Has anyone else noticed this issue? 

    Do you have a solution other than changing all pivot tables to remove function and comments from dimensions?

     

    Show Less
  • New to QlikView

    Help With Pick match Condition

    HI teamI Am trying to convert number to MIllion/Billions,I have a Variable vScaleTotalARBal which return M or B or Ki am using pick match like vD... Show More

    HI team

    I Am trying to convert number to MIllion/Billions,

    I have a Variable vScaleTotalARBal which return M or B or K

    i am using pick match like vDivParam=Pick(alt(match($1,'B','M','K',''),0),1000000000,1000000,1000,1)

    now if i use $(vDivParam(vScaleTotalARBal)) ir is returning null .

     

    Thanks in Advance

    @sunny_talwar 

    Show Less
  • QlikView Deployment

    Plugin issues with new installed PC and newer IE version

    So,we've run in to a QV Plugin issue we can't figure out.* Server/plugin: April 2019 SR1* IE: 11.295.18362.0On 2 new laptops with newer Win/IE version... Show More

    So,
    we've run in to a QV Plugin issue we can't figure out.
    * Server/plugin: April 2019 SR1
    * IE: 11.295.18362.0

    On 2 new laptops with newer Win/IE version than before there is 1 thing that don't work with IE Plugin.
    This is what vi do:
    * Open any App
    * Right click -> New Sheet Object
    * Choose any of the alternatives, ex. list box
    * Instead of a new window with properties popping up, everything just disappears.

    See attached pic

    Anyone with the same version of IE (or newer) that it works/don't works for?

    (it works when running Ajax/Full browser version)

    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
Sue_Stage : List Private Messages : Sign out : Switch user COMMUNITY Qlik Community Settings for: Community Qlik Community ChooseGo to Community ADMIN STUDIO TOOLBOX DISCUSSION STYLES FEATURES SYSTEM DISPLAY CONTENT USERS MOD TOOLS METRICS COMMUNITY STRUCTURE Search for settings Announcements Custom Content Custom Pages ActiveCast Featured Threads Promoted Search Select Custom Content Setting Event Card event-card Custom Content 7 Text

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
Show help for this page