Qlik Community

Welcome to Qlik Community

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

Discussion board and documents related to Qlik Associative Big Data Index.

Find a forum to ask a question or start a discussion.

Information about additional Qlik opportunities and offerings.

Qlik partners with leading technology companies to develop integrations, extensions, and connectors to the Qlik platform.

Discussion Boards and Documents for Qlik Services.

View our Technical Blogs for updates and information.

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.

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

  • New to QlikView

    Median for Table Total Row

    I require help in identifying Median for Table Total in Row (highlighted in Blue). Shown sample below. please provide the QVW sample file for this. it... Show More

    I require help in identifying Median for Table Total in Row (highlighted in Blue). Shown sample below. please provide the QVW sample file for this. it would be a great help. Thanks in advance.

    CURABCDE
    USD10.008.0013.006.0014.00
    INR58.0056.0061.0054.0062.00
    EUR62.0060.0065.0058.0066.00
    CZK35.0033.0038.0031.0039.00
    Total165.00157.00177.00149.00181.00

    Median for the total 165.00

     

     

    Show Less
  • New to Qlik Sense

    Creating a calculated field using another calculated field in load script

    Hello community,I am trying to create a calculated field with the use of a previous calculated field When i create this and Load the data, QLIK g... Show More

    Hello community,

    I am trying to create a calculated field with the use of a previous calculated field 

    When i create this and Load the data, QLIK gives me an error that the "previous Calculated field" was not found

     

    Example (where [TOTAL DURATION] is the field i am creating in "1" and trying to use in "2")

    Calculated Field number 1:

    IF([ATA DATE]='','',IF([POD DATE]='','',IF(NETWORKDAYS([ATA DATE]+1,[POD DATE]+1)<0,0,NETWORKDAYS([ATA DATE]+1,[POD DATE]+1)))) AS [TOTAL DURATION],

    Calculated Field number 2:

        IF([TOTAL DURATION]='','',
        IF([TOTAL DURATION]<=3,'0 TO 3',
        IF([TOTAL DURATION]<=5,'4 TO 5',
        IF([TOTAL DURATION]<=7,'6 TO 7',
        IF([TOTAL DURATION]<=15,'8 TO 15',
        IF([TOTAL DURATION]>15,'OVER 15')))))) AS [CLOSED BUCKETS]

     

    Any help is appreciated

    Thanks

    Show Less
  • Qlik Sense App Development

    Qlik Analytics Plugin for Visua Studio 2015

    Hello all,Please send me a link to download the Qlik Analytics plugin for Visual Studio 2015.Thank youLebo
  • New to QlikView

    Redondear al numero siguiente

    buena tardes a todos:quisiera saber como puedo redondear al dijito siguiente dentro del Qlikview quisiera saber como puedo redondear al numero si... Show More

    buena tardes a todos:

    quisiera saber como puedo redondear al dijito siguiente dentro del Qlikview

     

    redon.JPG

    quisiera saber como puedo redondear al numero siguiente en la columna de "Kist Solicitados", 

     

    ejemplo 1.3 = 2  ó  .32 = 1

    espero me haya esplicado la formula que utiliza es:

     

    =Round((sum(pruebasSubrogadas)+sum({<esquema-={'FICTICIO'}>}totalPruebas))/performanceUnit)

     

    Saludos!!!!

     

     

     

     

     

    Show Less
  • Qlik Sense App Development

    How do I display hours on Y-axis

    I'm looking to display a simple hourly (0-23) number format on the y-axis, based on sample data in Excel file .How would I do this.
  • New to Qlik Sense

    conditional number formatting as percentage in graph or kpi does not work

    Hi People,I would like to do conditional formatting of number for scatter plot and KPI. If it fits the condition match(Fin, 'IQ')<>0, then ... Show More

    Hi People,

    I would like to do conditional formatting of number for scatter plot and KPI. If it fits the condition match(Fin, 'IQ')<>0, then I would like the number to show as percentage like 95.6%, otherwise, just show as normal number like 95.6. Somehow, the formatting with num function does not work properly after I add If condition. It works without if condition. 

    Please see my example code below:

    If(
    match(Fin, 'IQ')<>0,

    num(Avg(
    {
    State4< FYear={'$(vStartYear)'}, nValue-={0}>
    }
    nValue)/100, '#,#%'),

    Avg(
    {
    State4< FYear={'$(vStartYear)'}, nValue-={0}>
    }
    nValue)
    )

    Interestingly, the same formula above works in table element. 

     

    Anyone can help? Thanks!

    Show Less
  • Qlik Sense App Development

    Multiple foreign keys between dimension table date and fact table

    Multiple foreign keys between dimension table date and fact tablehi there,i am a beginner in qlik sense, and i found a problem with association betwee... Show More
    Multiple foreign keys between dimension table date and fact table

    hi there,
    i am a beginner in qlik sense, and i found a problem with association between dimension table date and fact table (MEL).

    Annotation 2019-05-19 012402.png

    could you explain the best way to resolve the problem.

    Anyone please help.
    Thanks,

    https://imgur.com/apSalgI

    Show Less
  • New to QlikView

    Graph not showing results

    Hi All,I have a bar chart which I want to run off a variable. At the moment it works, but only when a person is selected from a drop down. I want them... Show More

    Hi All,

    I have a bar chart which I want to run off a variable. At the moment it works, but only when a person is selected from a drop down. I want them all showing at the same time.

    Dimension = Full Name

    Expression = $(vOverallRisk)

    Any help?

    Show Less
  • Community Corner

    THE FASTEST SOLUTION

    Hi,the following expressions give the same result:- If(Condition, Sum({<Set Analysis>}Dimension_1), Sum({<Set Analysis>}Dimension_2))- Sum... Show More

    Hi,

    the following expressions give the same result:

    - If(Condition, Sum({<Set Analysis>}Dimension_1), Sum({<Set Analysis>}Dimension_2))

    - Sum({<Set Analysis>} If(Condition, Dimension_1,Dimension_2))

     

    I want to say if there is a difference in terms of optimization? What is the fastest expression?

    Thank You

     

    Show Less
  • QlikView Scripting

    Using IsNum in SQL SELECT

    Hello all,When I run my script I have an error in the following lines in particular:SQL SELECT *FROM Table_CusWHERE SUBSTRING(NUM_CUS,1,1)='S' AN... Show More

    Hello all,

    When I run my script I have an error in the following lines in particular:

    SQL SELECT *

    FROM Table_Cus

    WHERE SUBSTRING(NUM_CUS,1,1)='S' AND ISNUMERIC(SUBSTRING(NUM_CUS,2,LEN(NUM_CUS)-1));

    In attached file, I screened the detail of my error.

    Please could you help me to identify what's wrong in my where clause.

    Thank you in advance for your help.

    Capture.PNG

    Show Less

Blogs

Qlik Community Blogs

Check out our community blogs to stay current on the latest and greatest information about Qlik products.

7 Blogs

Groups

Join a Group

Join one of our Qlik Community groups related to an Industry, Location, Language, or Topic.

28 Groups

Events

Events & Meetups

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