Qlik Community

Welcome to Qlik Community

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

  • New to Qlik Sense

    How to make field name from partial load return 2320 ?

    Hi AllMy load script below :-/////////////////////////////////////////////////////////////////////////////////////////'GL_TABLE:LOAD'PMC' as SOURCE,[A... Show More

    Hi All

    My load script below :-

    /////////////////////////////////////////////////////////////////////////////////////////'

    GL_TABLE:
    LOAD
    'PMC' as SOURCE,
    [Account Code] as AccountCode,
    // Below return correct value
    If([Account Code]>=5000000 and [Account Code]<=5999999,'P_Revenue') as [P_Revenue],
    [Deb./Cred. (LC)] AS Amount,
    Date( Date#([Posting Date], 'DD.MM.YY'), 'DD/MM/YYYY') as [date]
    FROM
    [C:\Users\Paul Yeo\OneDrive - ISDN Holdings Limited\RAW DATA SAP\GL_PMC_2019.xlsx]
    (ooxml, embedded labels, table is [Modified GL Data]);

    // Partial Relaod For create P_Revene_
    TABLE_P:
    left keep (GL_TABLE)
    load [AccountCode],
    // BELOW IS RETURN WRONG VALUE.
    if([AccountCode]>=5000000 and [AccountCode]<=5999999,'P_Revenue') as [P_Revenue_]
    resident GL_TABLE;

    /////////////////////////////////////////////////////////////////////////////////////////'

    I get 2 different result :-

    [P_Revenue] Return correct result which is 2320.
    [P_Revenue_] Return wrong result which is 0.

    Below expression return correct value :-
    =num(Sum(Aggr(SUM({<year = {"$(=Max(year)-0)"},month={"<=$(=Max({<sales = {'*'}, year = {$(=Max(year))}>}month))"},P_Revenue={P_Revenue}>}Amount*-1/1000), SOURCE)),)

    Below expression return wrong value :-
    =num(Sum(Aggr(SUM({<year = {"$(=Max(year)-0)"},month={"<=$(=Max({<sales = {'*'}, year = {$(=Max(year))}>}month))"},P_Revenue_={P_Revenue_}>}Amount*-1/1000), SOURCE)),)

    May i know how to make P_Revenue_ also return 2330 ?

    Paul Yeo

    Show Less
  • New to QlikView

    create an historical interval with fromDate and Todate

    Hi every one,I want to create a fromDate, toDate fields basing on an historical table, i have 3 date:- effective date- event date- due datehere is my ... Show More

    Hi every one,

    I want to create a fromDate, toDate fields basing on an historical table, i have 3 date:

    - effective date

    - event date

    - due date

    here is my code :


    policy_H_tmp:
    NoConcatenate
    LOAD policy_ID,
         date(EFFECTIVE_DATE,'DD/MM/YYYY') as EFFECTIVE_DATE,
         date(EVENT_DATE,'DD/MM/YYYY') as  EVENT_DATE,
         date(DUE_DATE,'DD/MM/YYYY') as DUE_DATE,
         CODE_INT,
        autonumber(CODE_INT,policy_ID) as rownumber_H
    FROM  […….\policy.xls]  (ooxml, embedded labels, table is Sheet1);

    LEFT JOIN(policy_H_tmp)


    load 
    policy_ID,
    date(max(DUE_DATE),'DD/MM/YYYY') as MAX_DUE_DATE ,
    max(rownumber_H) as rownumber_H
    resident policy_H_tmp GROUP BY policy_ID;


    policy_H:
    NoConcatenate
    load Distinct
    policy_ID,
    CODE_INT,
    date(Min(date#(EVENT_DATE,'DD/MM/YYYY'))) as FromDtae,
    date(date(MAX(if(isnull(MAX_DUE_DATE),EVENT_DATE,MAX_DUE_DATE +1)))-1)  as ToDate
    resident policy_H_tmp  group by policy_ID,CODE_INT ,rownumber_H order by policy_ID;

    drop table police_H_tmp;

    with this code i found a problem in policy : 656470115000131  it  gives me fromDate -> 06/04/2015 toDate -> 06/04/2016 CODE_INT -> 5700, which is wrong it must show toDate -> 05/04/2017

    i have joined my issue in attachment, the file named data represents my historical table while the other file is what i want,   can i do this with qlikview?

    thank you for advance.

     

    Show Less
  • New to QlikView

    Averaging problem

    Hello guys,I need help in calculating averages; pls have a look at my example: in the upper table I show all the participants to a championship and in... Show More

    Hello guys,

    I need help in calculating averages; pls have a look at my example: in the upper table I show all the participants to a championship and in the lower one I’d like to show the averages of them.

    The  averages for every season must be calculated in this way: Season number of participants of each age / Number of races of the season

    The  total averages must be calculated in this way: Total number of participants of each age / Total number of races of the seasons

    I currently use this formula: Sum(PartecipantiRP)/Count(IdGaraRP)

    But It’s wrong because Qlik considers only the races where has been at least one participant and not all the potential race for every season.

    Should anybody help me with the right formula, pls?

    Thanks.

    N.

    Show Less
  • Qlik Connectors Discussions

    problem in odbc oracle connector load

    hello experts,i am using qlikview 12 and for connect to our oracle database , i install odbc oracle . i connect to table of our oracle database and i ... Show More

    hello experts,

    i am using qlikview 12 and for connect to our oracle database , i install odbc oracle . 

    i connect to table of our oracle database and i can see columns same below picture:

    pic1.png

    but when i go to Preview tab for display fields values , no value display. same below picture:

    pic2.pngand when i reload data, display below message:

    pic3.png

    My question is:

    why i can connect to oracle table and view details of fields , but i can't view values of fields in Preview tab. and why display error 942 after reload?

    thank you for your attention.

    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
  • New to Qlik Sense

    Complex (impossible?) expression

    Hello Everyone,I have a problem with an expression today . I think what Iwant to achieve is impossible but.. But maybe someone will have a magical ide... Show More

    Hello Everyone,

    I have a problem with an expression today . I think what Iwant to achieve is impossible but.. But maybe someone will have a magical idea 😉 ?

    We sell a product  with a base on wich can be added options.

    Information are stored in a database in 2 differents tables :

    1 stored the SN (serial number of a system - unique indentifier of a system sold) with global options selected by the customer , Attention the customer can begin with Base system with or not options and in the future he can add Options, it will be still 1 line but add info to the SN : simplified exemple :

    BASE 1 :

    SNBaseOPTION 1OPTION 2OPTION 3
    11111101
    22221111
    333311 1
    44441001
    55551001
    6666100

    1

     

    If I want the total of Option 3 in the market : answer is 6

    Now I want have the number of this option 3 (or even system it is the same problem), sold per year or month, 

    I have an other database , which store every Orders by SN and date.

    So every time I have an entry it is a new line, If a customer update his system or add a new options :

    SNOrder Date
    11111janv-05
    22222mars-06
    33333juin-07
    44444janv-07
    55555mai-07
    66666mars-08
    11117juin-08
    33338juin-09
    22229juil-10
    222210mars-11
    111111juil-12

     

    Problem :

    I joined the 2 tables with Qlik to chart my sales per year or month.

    But If I make a chart to display the number of Options 3 or Systems per year for example (or month), The total through the years will be 11 instead of 6 because it will show every orders of Systems with the Option 3 for example. (If I want numbers of Option 1 instead by years, the real total is 3 but if I am charting it by years, it will display a total of 8 (because it will show every orders containing SN with option 1).

    The only solution I came up with was to do something like :

    To have Options 3 sold in 2012 for example

    (Total of Options 3 from year 0 to year 2012) - (Total of Options 3 from 0 to 2011)

    But this will give me number but I can't chart it anymore by using standard chart with Date as a dimension... Right ?

    I know it is not easy to understand but if somebody has an idea :)... 

     

    Show Less
  • Qlik Sense App Development

    Compare Event and Date

    Hi.I have an excel with 2 sheets:1- Sales and Date.2- Field 1(event)     Field 2(DateFromCY)     Field 3(DateToCY)     Field 4(DateFromLY)     Field 5... Show More

    Hi.

    I have an excel with 2 sheets:

    1- Sales and Date.

    2- Field 1(event)

         Field 2(DateFromCY)

         Field 3(DateToCY)

         Field 4(DateFromLY)

         Field 5(DateToLY)

         Field 6(Event Comparable)

         Field 6(DateFromComp)

         Field 6(DateToComp)

     temp prob event.PNG

     

     

     

     

    I want :

    Column 1: example: Compare Sales event 20-1 Current year with Last Year same period.

    Column 2: Compare event sales with the event comparable Sales ( Same row ),

                        example: Event 20-11  with  Event comparable 17-34.

     

    Find the attached excel file.

    Don't hesitate if you have any question.

    Thank you.

    Show Less
  • Qlik Sense App Development

    In Correct Avg of Percentage in pivot Table in Qlik Sense

    Hi All,Below are the some of details about dimension and measures are used in pivot table.Dimension:1.Bundle2.Initiative3.ProjectName4.Category(Calcul... Show More

    Hi All,

    Below are the some of details about dimension and measures are used in pivot table.

    Dimension:

    1.Bundle

    2.Initiative

    3.ProjectName

    4.Category(Calculated Field)

    Measures:

    1.ceil(avg(Category_Percentage))

    2.ceil(Avg(Category_Number))

    i am getting wrong (avg of "Category_Percentage",avg of "Category_Number" ) at  Project ,Initiative ,Bundle level in some of the cases. In some of the cases i am getting correct (avg of "Category_Percentage",avg of "Category_Number") at all level that Project,Initiative,Bundle.

    Note:All of the field used in pivot table  is coming from two table which is have mentioned in the attachment

    Please find attached script  which i have written in the back end for two tables used in the pivot table.

    Regards,

    Madhavi 

    Show Less
  • New to QlikView

    line chart option with two dimensions on x-axis

    Hi Alli have a combo chart with two dimensions on x axis. i want to include the line in the same chart as well.but when i use the line option in chart... Show More

    Hi All

    i have a combo chart with two dimensions on x axis. i want to include the line in the same chart as well.

    but when i use the line option in chart properties it does not work. could some one please help to sort this out.

     

    Capture.JPG

    Capture1.JPG

     

    Capture2.JPG

    Show Less
  • QlikView Scripting

    My date field D/M/YY How to recode ?

    Hi AllMy date field as below :-MonthD/M/YYI try below , it does not work :-Date( Date#([Month], 'DD/MM/YY'), 'DD/MM/YYYY') as [date],Hope some one can... Show More

    Hi All

    My date field as below :-

    Month

    month.png


    D/M/YY

    I try below , it does not work :-

    Date( Date#([Month], 'DD/MM/YY'), 'DD/MM/YYYY') as [date],

    Hope some one can advise me.

    Paul Yeo

    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