Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
logo
1,617 online
Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now

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 QlikWorld 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.

Participate in Qlik Technical Previews, submit ideas, and review documentation.

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 ten unique blogs. Check out the new Product Insight & Ideas Blog!

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

Discussion Boards and Documents for Qlik Services.

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

  • No Boards Found
  • forum
    New to Qlik Sense

    Download date from table

    Hello experts,I have an issue with downloading data from Qlik Sense. When I try to download data, where I have used a special  dimension to filter, th... Show More

    Hello experts,

    I have an issue with downloading data from Qlik Sense. When I try to download data, where I have used a special  dimension to filter, that does not work.

    When I use other dimensions or do not at all filter, I can download the data.

    Does anybody have an idea why that could be?

     

    Thanks in advance.

    Show Less
  • forum
    New to Qlik Sense

    cumulative bar chart help in the attached app

    Hi Experts,Can any one please help me to build the below cumulative bar chart(like in second chart)Original chart has the data like below in first cha... Show More

    Hi Experts,

    Can any one please help me to build the below cumulative bar chart(like in second chart)

    Original chart has the data like below in first chart.

    Requirement

    I have to build a cumulative bar chart with May to Jan sorting and need to show the highest value on May like second chart.

     

    cumulative chart.png

    Please help me on this. I have tried the default accumulation but getting May with low value.

    Please find the below attached application and source file.

    Thanks in advance.

    Show Less
  • forum
    New to Qlik Sense

    Rangesum with If condition

    Hi Everyone,I am facing issue with one of the KPI. I need to calculate Yearly accumulated of Spend_actual per supplier . Sample data as below  , Here ... Show More

    Hi Everyone,

    I am facing issue with one of the KPI. I need to calculate Yearly accumulated of Spend_actual per supplier . Sample data as below  , Here I need to get count of total suppliers who provided 80% of spend (KPI1) and also need to count the % of the supplier who provided 80% of Spend (KPI2) .

    #suppliers providing 80% spend = count of (supplier in top 80 % spend  ) 

    % suppliers providing 80% spend = count of (supplier in top 80 % spend  )  /Total suppliers

    I came up with formula to calculate accumulated spend_actual per supplier :

    num((RangeSum(Above(SUM({<$(vSet)>}SPEND_ACTUAL), 0, RowNo())))/(sum({<$(vSet)>}SPEND_ACTUAL)),'###.##%) 

    But I am struggling to get top suppliers who provided 80% spend.

    Kindly Please help.

     

    Parent SupplierSum(SPEND_ACTUAL)/1000000Sum(SPEND_ACTUAL)/Sum(total SPEND_ACTUAL)RangeSum(Above(Sum(SPEND_ACTUAL),0,RowNo()))/sum(total SPEND_ACTUAL)

    //0 offset
    Supplier in top 80% spend?    Formula - =IF(D<=80%,1,0)
    A118.513.5%3.5%1
    B94.962.8%6.3%1
    C79.012.3%8.6%1
    D74.902.2%10.9%1
    E71.932.1%13.0%1
    F67.422.0%15.0%1
    G61.971.8%16.8%1
    H47.121.4%18.2%1
    I43.001.3%19.5%1
    J36.221.1%20.6%1
    K27.600.8%21.4%1
    L26.430.8%22.2%1
    M25.720.8%22.9%1
         
    Show Less
  • forum
    New to QlikView

    Special characters in a number field

    Hi, I have a field (SMSNo) field where cell numbers are captured in, but i have occasions where people capture  special characters in, i want to creat... Show More

    Hi, 

    I have a field (SMSNo) field where cell numbers are captured in, but i have occasions where people capture  special characters in, i want to created an if statement in my script to identify just the client records  whom has a special character in the (SMSNo) field and where the number does not contain 10 digits. I also want to eliminate the fields that are blank.

    Thank you

     

     

    Show Less
  • forum
    New to Qlik Sense

    If condition need to apply when all or none selected from filter

    hi, I am new to Qlik Sense. In my application , I have one filter named "DIRECT_INDIRECT" which filters on "DIRECT_INDIRECT" filed from Table. This fi... Show More

    hi,

     

    I am new to Qlik Sense. In my application , I have one filter named "DIRECT_INDIRECT" which filters on "DIRECT_INDIRECT" filed from Table. This filter only has two values "DIRECT" and "INDIRECT" .  I want to apply condition in KPI that when both value selected or none of the value is selected then it should one formula and one of the value selected then other formula

    Basically I want to perform below action :

    if(DIRECT_INDIRECT = none or DIRECT_INDIRECT= All , 1, 0)

    Kindly please guide me for the same.  I tried using "ALL" or "none" in condition but it is not giving any output.

    thank you in advance

     

     

    Show Less
  • forum
    Qlik Sense App Development

    Help Me to get Horizontal filter pane or List Box to directly select values

    Hi guys,Please Help Me to get  Free Horizontal list box or filter pane extension which is working,Need a Filter pane which shows the values in horizon... Show More

    Hi guys,

    Please Help Me to get  Free Horizontal list box or filter pane extension which is working,

    Need a Filter pane which shows the values in horizontal without a dropdown option 

    Show Less
  • forum
    QlikView App Development

    Flag for selected or not selected value in Current Selection Box

    Hi Team,I want to create a flag in QlikView Script, If I select entry_date. Total no. of record in entry_date is 644 and I have selected 401 value. So... Show More

    Hi Team,

    I want to create a flag in QlikView Script, If I select entry_date. Total no. of record in entry_date is 644 and I have selected 401 value. So I need a flag like Y for all those value selected and N means not selected records.

    Hope you got my answer. Can any one help me on this.

    For data related qvw, I am attaching my qvw.

    Regards,
    Sona_SA

    Show Less
  • forum
    New to QlikView

    2 Total

    Hi All , Please find the attachment of the excel sheet , I want to show subtotal and Total  in a table in QlikView . I have Department and Category an... Show More

    Hi All , 

    Please find the attachment of the excel sheet , 

    I want to show subtotal and Total  in a table in QlikView . 

    I have Department and Category and Sales , 

    As shown in the screenshot below is it possible to achive this in Qlikview ? 

    smilingjohn_1-1590755821066.png

     

    Thanks in Advcance 

    Show Less
  • forum
    Qlik Server Side Extensions Discussions

    Number of requests made to the SSE

    Hi there,I observed the following behaviour. Can someone tell me if this is a known limitation, architectural design, known bug or something else enti... Show More

    Hi there,

    I observed the following behaviour. Can someone tell me if this is a known limitation, architectural design, known bug or something else entirely?

    I simplified the problem for this forum.

    Let’s say I have one SSE function: SSE.Increase, which will increase a given field by 5.

    Additionally, my datamodel has one table with 5000 rows and two fields:

    my_idmy_number

     

    with my_id being a dimension and my_number a measure.

    Now, if I build a table in a QlikSense sheet with:

    Column-NameTypeValue
    Column 1Dimensionmy_id
    Column 2MeasureSSE.Increase(my_number)

     

    my SSE function will be called once with 5000 rows => high performance.

    2nd try: I now change my table to:

    Column-NameTypeValue
    Column 1Dimensionmy_id
    Column 2MeasureSSE.Increase(my_number) + 1

     

    This will lead to my SSE function to be called 5000 times with 1 row each => significant decrease in performance.

    And lastly, another table:

    Column-NameTypeValue
    Column 1Dimensionmy_id
    Column 2MeasureSSE.Increase(my_number)
    Column 3Measure1
    Column 4Measure[Column 2] + [Column 3]

     

    This time, again, QlikSense will call my SSE function just once with 5000 rows => high performance. This table will lead to the same results as table #2, but with a much better performance (and some additional columns...)

    I tested this with the latest Qlik Sense Version.

    As I stated in the beginning: Why?

    Thanks.

    Murat

    Show Less
  • forum
    QlikView App Development

    Ranking on multiple measures Top 3 Customers With Sales amout or Top 3 customers...

    Hello Folks, Looking for help. Can you give some insight to provide Top 3 customers by sales plus top 3 customers by product count.Appreciate your tim... Show More

    Hello Folks, 
    Looking for help. Can you give some insight to provide Top 3 customers by sales plus top 3 customers by product count.

    Appreciate your time and help.

    ScreenShotExample.jpg

    Show Less

Top Participants

Blogs

Qlik Community Manager Blog

Hear from the Qlik Community team about the latest platform enhancements for December 2019 and January 2020.

Blogs

Customer Success Blog

Read all about Qlik's Voice of the Customer program and Customer Success initiatives.

Blogs

Blogs

Hear directly from Qlik employees and stay current on the latest and greatest information about Qlik products.

Groups

Qlik Insight Bot

Join the Qlik Insight Bot Group and bring the power and simplicity of natural-language, conversational analytics to everyone in your organization

open to all

Groups

QlikView to Qlik Sense

Join the QlikView to Qlik Sense group and help you modernize your BI experience through adoption of Qlik Sense.

open to all

Groups

Qlik Healthcare

This group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights.

750+ Members

Events

The Human Impact of Data Literacy

Boosting the data skills of your entire workforce can exponentially increase your data’s value. In this webinar, discover the big opportunity in data literacy.

On Demand Webinar

Events

Events & Meetups

Virtual Meetups are now a possibility! With the impact of COVID-19, the Qlik Meetup network has expanded its support to include the ability to host your next Meetup online. Email QlikMeetups@qlik.com to get your virtual Meetup started!


Events

What's New in 2020?

Join us on for a deep-dive discussion and tailored product demonstration on the newest capabilities delivered as part of Qlik’s most recent product release.

Now Available on Demand