Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
5,852 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

  • Qlik NPrinting Discussions

    No report Generated : Throwing message as "plan branch execution completed"

    Hi Qlikies,I am creating a country based report. The users will receive the reports of their specific country which we specified in the user filter. I... Show More

    Hi Qlikies,

    I am creating a country based report. The users will receive the reports of their specific country which we specified in the user filter. I have used Cycle option in the report. In Nprinting I have imported the user filter via excel. The Import task ran successfully. And was able to get the imported filter, users list & user's corresponding assigned filters as below.


    user1 -> Country - UK, USA
    user2 -> Country - Italy.

    we are using The NewsStand to distribute the reports to the users.

    when we run the task to generate the report the task is completed without any error but it did'nt produce any reports. In task details there is a msg "plan branch execution completed". I am not sure why i didn't receive the report, and what could be the cause. Any inputs will be helpful.

    Thanks!

    Pooja!

    Show Less
  • 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 QlikView

    Script Key between tables

    I have two tables on the Script:Telehone_table:loadTelephone,Campaing_code,Campaing_descrip,Campaing_start_date,Campaing_end_date Telephones_records:T... Show More

    I have two tables on the Script:

    Telehone_table:

    load

    Telephone,

    Campaing_code,

    Campaing_descrip,

    Campaing_start_date,

    Campaing_end_date

     

    Telephones_records:

    Telephone,

    Date,

    Calls,

    Sales

    The most obvious will be to do  use Telephone as KEY but  the problem here is that Telephones are reused over time for new campaings, so there is a list of about 50 telephones whereas they are reused for Campaings over time. How to link those tables by a convination of Telephone, Campaing_start_date and Campaing_end_date?

    Here is a small sample of each table

    Telephone_table:

    Telephone,       Campaing_code,      Campaing_descrip,     Campaing_start_date,     Campaing_end_date

    1001 (*)                    001                                 Campaing1                      01/01/2019                            15/01/2019

    1001                     002                                  Campaing2                      16/01/2019                             23/01/2019

    .....                           ......

    Note (*): Watch that the same telephone number 1001 is reused for Campaing1 and Campaing2

    Telephone_records:

    Telephone,           Date,                      Calls,           Sales

    1001                       01/01/2019          20                   3

    1001                       02/01/2019          25                   6

    .....                            .....

    Thanks in advance!!!

     

     

    Show Less
  • Qlik Sense App Development

    Custom Value Labels on Bar Chart

    Hi All, I have the below dataDateValueRegion01/01/201910East02/01/201915West03/01/20198North04/01/201912South I'd like to make a Bar Chart such as the... Show More

    Hi All,

     

    I have the below data

    DateValueRegion
    01/01/201910East
    02/01/201915West
    03/01/20198North
    04/01/201912South

     

    I'd like to make a Bar Chart such as the below where my Dimension is the Date, my measure is sum(Value) and the label on the bar is the Region and the Value.  I've tried using Dual(Only(Region),Sum(Value)) but it does not seem to be working.  Does anyone know if this is possible?

     

    2020-01-21 19_09_16-Clipboard.png

     

     

    Thanks!
    Mark

    Show Less
  • New to QlikView

    Color coding a pivot cell based on value on the earlier cell value

    Hi All,My data looks like below. My requirement is to highlight the cells based on previous value and mark them either Red or Amber.If the current cel... Show More

    Hi All,

    My data looks like below. My requirement is to highlight the cells based on previous value and mark them either Red or Amber.

    If the current cell is less than its previous cell, then the value of the current cell should be Red,  

    If the current cell is equal to its previous cell, then the value of the current cell should be Amber, 

    otherwise default.

    Can you please suggest what should be my text color under Edit Expression of a Pivot Table

     

    Data:

    TeamReleaseMonthTargeted Regression ScenariosAutomatedManual
    ADec 1914712225
    AJan 2015512233
    AFeb 2015210052
    BDec 192793274746
    BJan 203121305170
    BFeb 201055055

     

    What I want is: a Pivot Table

    TeamReleaseMonthTargeted Regression ScenariosAutomatedManual
    ADec 1914712225
    AJan 2015512233
    AFeb 2015210052
    BDec 192793274746
    BJan 203121305170
    BFeb 201055055

     

    Show Less
  • Qlik Replicate Discussions

    DB2 LUW Replication to AWS Platform

    Hi,Like to know if QLIK Replicate (Attunity) Supports replication of DB2 LUW (Linux Unix Windows) V9.7 from Linux/Unix to AWS Platform (RDS and EC2 - ... Show More

    Hi,

    Like to know if QLIK Replicate (Attunity) Supports replication of DB2 LUW (Linux Unix Windows) V9.7 from Linux/Unix to AWS Platform (RDS and EC2 - Windows/Linux/Unix)?

    Please kindly advise.

    Cheers.

     

    Show Less
  • QlikView App Development

    Set analysis modifiers without quotes

    This is a more general question about set analysis modifier behaviour. I've always believed that string modifiers in a set analysis have to be within ... Show More

    This is a more general question about set analysis modifier behaviour. I've always believed that string modifiers in a set analysis have to be within quotes, like this
    Sum({<Color={'Green'}>}Amount)


    and for modifiers with numeric value the quotes where optional like this 
    Sum({<ColorID={1}>}Amount) OR   Sum({<ColorID={'1'}>}Amount)

    But I noticed that the two expressions below returns the same result.  

    Sum({<Color={'Green'}>}Amount)  AND 
    Sum({<Color={Green}  >}Amount)

     

    Is this an correct observation? Is this new or old behaviour? I notice that the examples in the Qlik help page Set analysis and set expressions  are ambivalent in the use of ' ' or not ' '. 

    Does anyone have a link to Qlik Help och Qlik Support that describes the use of quotes in modifers? I assume that QlikView/Qlik Sense intepret the two differently hence: 

    Sum({<Color={'*'}>}Amount)  is not equal to Sum({<Color={*}>}Amount)

     

    Data sample from the attached qvw file:

    DATA:
    LOAD * INLINE [
    ColorID, Color,   Amount
    1,       Green, 100
    2,       Red,   200
    3,       Yellow,300
    0,       *,       400
    ];

    image.png

    Do you @BrettBleess or @rwunderlich  know anything about this set modifier behaviour/intepretion?

    Show Less
  • New to QlikView

    Transpose a column and add missing columns

    Hi,I'm a new bee to Qlikview, Could you please help me with one situation ?I have a table with two column(Column-1) with multiple values like:Column-1... Show More

    Hi,

    I'm a new bee to Qlikview, Could you please help me with one situation ?

    I have a table with two column(Column-1) with multiple values like:

    Column-1            Column-2

    -------------             ------------

    X                               1

    Y                                2

    Z                                3

     

    I have transposed this column and got as below

    X        Y         Z

    1         2         3

    but yeah, here is my situation, 

    Where sometimes table consists of only 2 records as 

    X            1

    Y            2

     

    and i want to add the missing records through QV script by checkng whether the field Z is available or not, if not available add a column "Z" and if not available and corresponding value as null and if available do nothing.

     

    Could you please help us on this.

    Show Less
  • Qlik NPrinting Discussions

    NPrinting - Can I reference the value of a field I'm cycling on within my templa...

    I've built a report that cycles through a field called 'Country'.  When I'm editing my template, is it possible to reference the value of the 'Country... Show More

    I've built a report that cycles through a field called 'Country'.  When I'm editing my template, is it possible to reference the value of the 'Country' field?

    For example, when NPrinting is cycling through and is now using 'Country' = 'US', can I have the text 'US' appear in my template?

    Show Less
  • QlikView Scripting

    Difference between Dates

    Hello All,I try to calculate the difference between two dates with a condition.If the difference between the date is upper to one year then put the va... Show More

    Hello All,

    I try to calculate the difference between two dates with a condition.

    If the difference between the date is upper to one year then put the value '>365' else '=<365'.

    But the result is no correct.

    Below my script and a screenshot of the result:

    [DateDiff]:
    LOAD DISTINCT
    Item,
    IF(DATE(DATE#(LastTransDate,'YYYY/MM/DD'),'YYYY/MM/DD')-DATE(DATE#(Ancienne_LastTransDate,'YYYY/MM/DD'),'YYYY/MM/DD')>=365,'>=365','<365') AS YearRatio
    RESIDENT CalculationDates;

    datediff.PNG

    Please could you tell me what is wrong in my script?

     

    Thank you in advance for your help.

    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