Qlik Community

Welcome to Qlik Community

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

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

    Qlik Default Join

    I am joining two tables.Lets say for example(Table A, Table B)Table A:A,BTable B:A,CThe result from the above is not matching when I put outer join be... Show More

    I am joining two tables.Lets say for example(Table A, Table B)

    Table A:

    A,B

    Table B:

    A,C

    The result from the above is not matching when I put outer join between these two

    Table A:

    A,B

    outer join(Table A)

    Table B:

    A,C

     

    Ideally both should be same right?

    Show Less
  • forum
    New to Qlik Sense

    Return only Sales of the current month in KPI Window

    Hello,I tried many time to find a solution but its still doesn't work out. I loaded a table with a Revenue_Month field like the following.Revenue_Mont... Show More

    Hello,

    I tried many time to find a solution but its still doesn't work out. I loaded a table with a Revenue_Month field like the following.

    Revenue_MonthRevenue_Target
    05.202028170000
    05.202028170000
    05.202028170000
    06.202030000000
    06.202030000000
    06.202030000000
    06.202030000000

    Qlik didn't recognized as a Date field, so I put a additional Date function in the loading script like á la Date(date#(MM.YYYY),'DD.MM.YYYY') as Revenue_Month. Now Qlik know its a date I also got automated.date function to chose from. Since I add the days also, I got the following table: 

    Revenue_MonthRevenue_Target
    01.05.202028170000
    01.05.202028170000
    01.05.202028170000
    01.06.202030000000
    01.06.202030000000
    01.06.202030000000
    01.06.202030000000

    Now I want a KPI Window which always shows me the Revenue_Target of my current month. I don't want a sum of the values, so for instance when now its May I just want to display  '28170000' and next month in June it should return '30000000'. 

    I tried many variation of set expression combined with like this with and without "distinct": 

    =Sum({<[Revenue_Month]={'<=$(=Date(Today()))'}>}distinct [Sales])

    or

    Sum({<[Revenue_Month.automated.Month]={'<=$(=Date(Today()))'}>}distinct [Sales])

    also

    If-Function like: if (Revenue_Month==$(=Date(Today()), distinct Sales)) 

    never worked out for me. Mostly I got some aggregated big amount but mostly 0 respectively no value at all.

    Hope someone has an idea whats going on here. 

    Thanks in advance!

    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