Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
1,881 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 nine unique blogs. Check out the new Customer Success 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.

Recent Discussions

  • QlikView Scripting

    What If Analysis

    I have a chart that has data similar to that displayed belowI would Like to be able to do quick what if charts for scenario planning like to show what... Show More

    I have a chart that has data similar to that displayed below

    Sample Data Set.JPG

    I would Like to be able to do quick what if charts for scenario planning like to show what it would look like if I moved the 50 units of product B from plant 3 to plant 2.  I would like to be able to this in Qlikview and not have to keep changing the input data.  Is this possible in Qlikview or would I need to manipulate data prior to uplaod?

    Show Less
  • Qlik Sense Deployment & Management

    Is it possible to track which sheets users are visiting during there sessions? A...

    Hi all,Is it possible to track which sheets users are visiting during there sessions? Any log files?It may be possible through the QIX engine logs I s... Show More

    Hi all,

    Is it possible to track which sheets users are visiting during there sessions? Any log files?

    It may be possible through the QIX engine logs I suppose but I am not sure how to increase the level of logging to do this.

    Any help or info would be great!

    Show Less
  • QlikView App Development

    How to use Interval Match on 2 tables?

    HiI have the following 2 tables in which each record has a Start date and End Date. How do I create a data model with these 2 tables? The requirement ... Show More

    Hi

    I have the following 2 tables in which each record has a Start date and End Date. How do I create a data model with these 2 tables? The requirement is to have a date filter and display the Emp_NM, Salary & Manager_NM in a Straight table on UI.

     

    Emp_Manager table:

    EmpIDEmp_NMManagerIDManager_NMStart_DateEnd_Date
    1John Smith76Leo Maguire1/1/20149/30/2015
    1John Smith77Trace Young10/1/201512/31/2099
    2Paul Lin98Eric Dwight1/1/20141/31/2016
    2Paul Lin99Tom Luff2/1/201610/31/2018
    2Paul Lin100Karen James11/1/201812/31/2099

     

    Emp_Salary table:

    EmpIDEmp_NMSalaryStart_DateEnd_Date
    1John Smith900001/1/201412/31/2014
    1John Smith1000001/1/20157/31/2018
    1John Smith1200008/1/201812/31/2099
    2Paul Lin1900001/1/20148/31/2015
    2Paul Lin2000009/1/20155/31/2018
    2Paul Lin2200006/1/201812/31/2099
    Show Less
  • Qlik Sense App Development

    Qliksense Data Load Negatives

    Hiya,  I'm currently loading in my data and in my txt file the negatives are shown in Brackets.This doesn't get read as numbers by Qliksense.I can't c... Show More

    Hiya, 

     

    I'm currently loading in my data and in my txt file the negatives are shown in Brackets.

    This doesn't get read as numbers by Qliksense.

    I can't change the load data as this is how it comes out the system. 

    Do you know how I can script it to make it recognise them as negative numbers?

    Thanks!

    Show Less
  • Community Corner

    mutiple wilmatch and simple if

    Hi, I have a a colonne with differents code to exclude the next code:CODE  > 401231CODE finish by '5*'CODE finish by '5A*Code don't begin by '603*'I t... Show More

    Hi, 

    I have a a colonne with differents code to exclude the next code:

    • CODE  > 401231
    • CODE finish by '5*'
    • CODE finish by '5A*
    • Code don't begin by '603*'

    I test this code, but i have errors : 

    if(WildMatch(CODE,'*5','*5A'),CODE,
         if(Not WildMatch(CODE,'*603*'),CODE,NULL())
             if (CODE > 401231,CODE)
    )

     

    Thanks in advance

     

    Show Less
  • Community Corner

    Can't able to get all cells from apps

    Hi, I' m trying to pull all the cells from apps is there any method or any request which returns me complete cells from all the apps or from any singl... Show More

    Hi, 

    I' m trying to pull all the cells from apps is there any method or any request which returns me complete cells from all the apps or from any single app, and what are the parameters should i need to pass for the request, 

    please provide me any request object, so that it would be a detail informative and very helpful,

    thanks 

    Show Less
  • Qlik Sense App Development

    Count in Load Sciprt

    i am having a script error on the end of my script when i try to aggregate i can not figure out what is wrong with the script it run well expert for t... Show More

    i am having a script error on the end of my script when i try to aggregate i can not figure out what is wrong with the script it run well expert for the count at the end any help would be greatly appreciated

    [T188T]:
    Mapping Load
    // Key fields:
    [KONDA],
    [VTEXT] as [Price Group Descr.]
    from $(vSources)T188T.qvd (qvd);

    // consolidate the 3 tables of condition price :
    [PRICE_COND]:
    Load
    VKORG as comp_price,
    KUNNR as custo_price,
    MATNR as mat_price,
    KNUMH as cond_price,
    DATBI as Valid_to_price,
    DATAB as Valid_from_price,
    'Customer / Material' as option
    from $(vSources)A05.QVD (qvd)
    where DATBI > date(today()) and DATAB <= date(today())
    ;


    //added
    concatenate(PRICE_COND)

    Load
    VKORG as comp_price,
    KUNNR as custo_price,
    MATNR as mat_price,
    KNUMH as cond_price,
    DATBI as Valid_to_price,
    DATAB as Valid_from_price,
    'ALL' as option
    from $(vSources)A05.QVD (qvd)

    ;
    //endadd
    concatenate(PRICE_COND)
    load
    VKORG as comp_price,
    KONDA as custo_grp_price,
    ApplyMap('T188T',KONDA) as [Price Group Descr.],
    MATNR as mat_price,
    KNUMH as cond_price,
    DATBI as Valid_to_price,
    DATAB as Valid_from_price,
    'Price Group / Material' as option
    from $(vSources)A32.QVD (qvd)
    where DATBI > date(today()) and DATAB <= date(today())
    ;

    concatenate(PRICE_COND)
    load
    VKORG as comp_price,
    MATNR as mat_price,
    KNUMH as cond_price,
    DATBI as Valid_to_price,
    DATAB as Valid_from_price,
    'Material with release status' as option
    from $(vSources)A304.QVD (qvd)
    where DATBI > date(today()) and DATAB <= date(today())
    ;

    //link the condition price table with the pricing table (konp "normal price"/ konm "scale price")
    NoConcatenate
    PRICE_tmp:
    load
    comp_price,
    custo_price,
    custo_grp_price,
    [Price Group Descr.],
    mat_price,
    cond_price,
    Valid_to_price,
    Valid_from_price,

    [custo_grp_price]& '-' &[comp_price] as Pr_Group_Comp,
    //[comp_price]& '-' &[mat_price] as Company_Material_Pric,
    option
    resident PRICE_COND;

    left join(PRICE_tmp)
    load
    KNUMH as cond_price,
    if(KZBZG = 'C', ' ', KBETR) as amount_price,
    KPEIN as per_unit,
    KMEIN as unit_of_measure,
    KONWA as currency_price
    from $(vSources)KONP.QVD (qvd);

    left join(PRICE_tmp)
    load
    KNUMH as cond_price,
    KSTBM as scale_price,
    KBETR as amount_scale_price
    from $(vSources)KONM.QVD (qvd);

    drop table PRICE_COND;


    //Add the customer of price group
    NoConcatenate
    PRICE_tmp2:
    load *
    resident PRICE_tmp;

    /*join(PRICE_tmp2)
    load Pr_Group_Comp,
    [KUNNR] as custo_price_grp
    resident KNVV;
    */
    //drop table KNVV;
    drop table PRICE_tmp;

    //rework the table
    NoConcatenate
    PRICE_tmp3:
    load
    //if (isnull(custo_price_grp),[comp_price]& '-' &[mat_price]& '-' & custo_price, [comp_price]& '-' &[mat_price]& '-' & custo_price_grp) as %Company_Material_Pric,
    [comp_price]& '-' &[mat_price]& '-' & custo_price as %Company_Material_Pric,
    comp_price,
    //if (isnull(custo_price_grp), custo_price, custo_price_grp) as custo_price,
    custo_price,
    custo_grp_price,
    [Price Group Descr.],
    mat_price,
    cond_price,
    Valid_to_price,
    Valid_from_price,


    //Company_Material_Pric,
    option,
    if (amount_price = ' ', amount_scale_price, amount_price) as amount_price,
    per_unit,
    unit_of_measure,
    currency_price,
    if (isnull(scale_price), '1', scale_price) as scale_price
    resident PRICE_tmp2
    where not isnull(mat_price);


    left join(PRICE_tmp3)
    Load
    KUNNR as custo_price,
    [NAME1] as [Cust_price_Name],
    KUNNR & ' - ' & NAME1 as [customer code & name price],
    [KONZS] as [Corporate Group_Price]
    from $(vSources)KNA1.qvd (qvd);

    left join(PRICE_tmp3)
    LOAD
    MATNR as [mat_price],
    VKORG as [comp_price],
    KUNNR as [custo_price],
    KDMAT as [Customer Part Price]
    FROM
    $(vSourcesShared)KNMT.QVD
    (qvd);

    left join(PRICE_tmp3)
    Load
    [KUNNR] as [custo_price],
    [VKORG] as [comp_price],
    [KONDA] as custo_grp_price

    FROM $(vSources)KNVV.QVD (qvd);

    [PRICE]:
    Load *,
    Count(scale_price) as count_scale_price

    resident PRICE_tmp3
    group by custo_price, mat_price,comp_price ;


    drop table PRICE_tmp2;
    drop table PRICE_tmp3;

    STORE [PRICE] INTO $(vDirectoryPath)PRICE.QVD;

     

    Show Less
  • Qlik NPrinting Discussions

    Npriniting Connection shows Cache Status 'Generating' for several hours

    Hello Experts,I have made some changes on Qlik App and then tried to reload the metadata in Nprintimg connection for the Qlik App. The connection show... Show More

    Hello Experts,

    I have made some changes on Qlik App and then tried to reload the metadata in Nprintimg connection for the Qlik App. The connection shows cache status as generating for several hours. 
    I then deleted the connection and created a new one and it still shows Cache Status Generating as shown below in the screenshot:

    CacheStatusIssue.PNG

    Any idea what could be the issue?

    Show Less
  • QlikView Scripting

    How to Left Join() a table with another below?

    Hi,if i have 2 tables like the following:TABLE1:...TABLE2:...How can i Lef Join() TABLE1 with TABLE2 if the first table is before the second in the sc... Show More

    Hi,

    if i have 2 tables like the following:

    TABLE1:

    ...

    TABLE2:

    ...

    How can i Lef Join() TABLE1 with TABLE2 if the first table is before the second in the script?

    I can't change the order of the tables because i need to insert an expression in TABLE2 that involve also some fields of TABLE1.

    Please, anyone have a suggest?

    Thanks,

    Mattia

    Show Less
  • Qlik Sense App Development

    QVD and CSV issues

    Dear all,during the development of our apps we have encountered some strange issues by using Qlik Sense.First of all, let me describe the configuratio... Show More

    Dear all,

    during the development of our apps we have encountered some strange issues by using Qlik Sense.

    First of all, let me describe the configuration:

    • We are using Qlik Sense February 2019 patch 4
    • Our Postgres DB have all values stored as STRINGS, in a table whose columns are (more or less) Timestamp, MetricID, Value. This is because NOT all our stored values are numbers.
    • Our environment is configured as Italian (so uses comma as decimal separator for numbers), but in our Postgres DB the numbers are stored represented by using the dot (".") for decimal separator (in order to have a environment independent format).

    The workflow is as follows:

    1. Importing "as is" the values from Postgres, and storing into a QVD.
    2. Read the QVD, filtering out the metrics which we know have actual string values (so we preserve only "numeric" values). [Let's name this QVD#1]
    3. Converting the remaining values to numbers: num(num#(Value, '#.#', '.', ','))
    4. Storing the converted values into a QVD and into a CSV. [Let's name these QVD#2 and CSV#2]
    5. Load the QVD, perform some aggregation on values, such as SUM(), AVG(), STDEV().
    6. Storing the results into a QVD and a CSV [Let's name these QVD#3 and CSV#3]

    Here the description of the strange behaviors:

    • Behav#1: With this workflow, everything seems to go fine, except if we open into the Data Model Viewer the QVD#3, it does not shows the values (it shows "?"). Nevertheless, the resulting plots seem fine. Please note that QVD#2 is shown correctly.
    • Behav#2: If, in the step 3 of the flow, instead of using num(num#(Value, '#.#', '.', ',')), we use num#(Value, '#.#', '.', ',') to convert the numbers, the generated CSVs and QVDs have anomalies, as question marks, some numbers are recognized as strings in the model viewer (and some are viewed with dot as separator, others with comma). Also into the CSV there are some anomalies: numbers have different formats (some with comma, others with dot).

    From my (very basic) understanding, some issues are due to the dual values management of Qlik. For example, it is likely that the printing of the CSV uses the string representation of the dual values (this should explain BEHAV#2 for CSV).

    On the other hand, I am not expecting to have issues with the QVD, since it is a binary format (so I hope numbers are "auto-magically" handled). So I do not get why  I see question marks (BEHAV#1), or mixed number representations in the model viewer (BEHAV#2 for QVD).

    So, can someone explain me why I have these issues with the QVD?

    Best regards.

     

    Show Less

Blogs

Qlik Community Manager Blogs

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

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

Join the last Qlik Insider Webinar of 2019, where our experts will discuss the latest features and capabilities in Qlik's platform.

November 20, 2019 Webinar

Events

Events & Meetups

Participate in an upcoming local Qlik Meetup


Events

Qlik Data Revolution Tour

Discover how to transform your entire data value chain for deep insights at unprecedented speed.

Find a location One Day Event