Qlik Community

Welcome to Qlik Community

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

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.


WEBINAR SERIES: THE DX FILES

When disruption is nonstop, how do you compete – and thrive? Digital Transformation is a must, and data is at the heart of it. To pull ahead of the pack, stay in front of the trends, and keep pushing innovation further, you have to consistently reinvent your business – fast – with a modern approach to data. When it comes to Digital Transformation, the truth isn’t out there – it’s in here. Join us July 30 – August 28, 2019, for 5 tracks of insight-packed webinars.

Recent Discussions

  • New to Qlik Sense

    How can put upper and lower arrow indicators in qlik sense?

    Hi ,I have to add expression as value in pivot table.expression should be 1 or -1 value(like value=1,-1).I need to show in expression if value is 1 th... Show More

    Hi ,

    I have to add expression as value in pivot table.

    expression should be 1 or -1 value(like value=1,-1).I need to show in expression if value is 1 then i need show upper arrow with green colour ,if the value is -1 need to show down arrow with red colour.

    please explain me how can put arrows in qlik sense?

    Thanks,

    Rajesh

    Show Less
  • QlikView App Development

    Grouped bar chart percentage not working

    HI,          Every one i  have  a bar chart with a cyclic group plus a dimension and i have only one expression whi... Show More

    HI,

              Every one i  have  a bar chart with a cyclic group plus a dimension and i have only one expression which is 

               count ( distinct  units) / count ( total  distinct  units )  and this expression is represented as  percentage . But  this

    percentage is not summing unto 100  %. and the reason behind is   " count ( total  distinct  units )  " is not  calculating

    properly. When  i  changed the bar chart to straight table to find out the issue ,  the denominator value should be a sum of

    rows but its getting expression total . So  any one can tell me on how to get sum of rows value in the denominator , i tried

    aggr function , total <dimension 1, dimension 2 > both of them didn't work 

    Show Less
  • New to QlikView

    Numbering the customer name

    Hi Masters,If a customer belongs to a specific category, we do not want to disclose the customer name; thus I was wondering if it is possible to ... Show More

    Hi Masters,

    If a customer belongs to a specific category, we do not want to disclose the customer name; thus I was wondering if it is possible to replace the customer name with "Customer 1", "Customer 2", "Customer 3" ...etc during the load.

    Therefore, every time the category falls under "CMarket" we want to replace the customer name by "Customer" + "Autonumber" = Customer 1, Customer 2 etc

    The numbering should be automatic for every new customer under CMarket category.

    Currently:

    CategoryCustomer Name
    VendorJohn's Transport
    CMarketBarbershop Michigan
    CMarketNY cellphone
    VendorMary's Food Truck
    CMarketTexas Printer
    DirectFast Car Rental

     

    Expected:

    CategoryCustomer Name
    VendorJohn's Transport
    CMarketCustomer 1
    CMarketCustomer 2
    VendorMary's Food Truck
    CMarketCustomer 3
    DirectFast Car Rental

     

    Thanks for your help

    Show Less
  • QlikView Scripting

    Month Year

    Hi Experts !In my db month field is maintained in numeric form i.e 1,2,3,--12. and year field is also numeric like 2018,2019 and so on.I want to displ... Show More

    Hi Experts !

    In my db month field is maintained in numeric form i.e 1,2,3,--12. and year field is also numeric like 2018,2019 and so on.

    I want to display month year as a dimension in a bar chart. Any Ideas of how to achieve this field inside QV.

    Thanks.

    Show Less
  • QlikView Creating Analytics

    Help with removing NULL counts

    Hello, I don't know if this requires a total rewrite but having difficulty getting the count of AD_Account_Name to not include NULL's from the be... Show More

    Hello, I don't know if this requires a total rewrite but having difficulty getting the count of AD_Account_Name to not include NULL's from the below. Does anyone have any tips?

    Count (distinct (if([AD_LastLogonTimestamp.autoCalendar.Date] < Today()-90,AD_Account_Name)))

    Thanks

    Patrick

    Show Less
  • QlikView App Development

    Display Total as the value of a Column

    Hi Gurus,I have a scenario where I need to display a total as the value of existing column and not the sum or average of all the columns.The original ... Show More

    Hi Gurus,

    I have a scenario where I need to display a total as the value of existing column and not the sum or average of all the columns.

    The original data is like below:

    Original Table.png

    And I have converted to Pivot as per requirement as below

    Pivot.png

    Now as the values for AM PM an ND is being calculated as the average, so the partial sum (Total) for Census Period is also showing as average of AM,PM and ND. 

    Only for Census A,I want the total to be displayed as the value of ND only i.e. 30 and not 29 in the above case.Rest all Census can show the value as usual as they are showing now.

    I can achieve this using set analysis but can't find any way to write it for the total. Any pointers will be highly appreciated.

     

    Thanks

    Samir

    Show Less
  • New to QlikView

    Want axis in gauge chart in qlikview

    Dear All, I want axis in gauge chart. I created sales vs budget in gauge chartPlease help.I have image I want percentage axis like this.
  • New to Qlik Sense

    find Min Date1 greater than Date2 in set analysis

    I have a customer table with Customer and UpdateDate,another sales table with Customer, SalesDate and Amout. I would like to see the first Sales ... Show More

    I have a customer table with Customer and UpdateDate,

    another sales table with Customer, SalesDate and Amout.

     

    I would like to see the first Sales Amount after each customer updates. So For each customer, I need to find the minimum SalesDate greater than the UpdateDate, then sum up Amount on that SalesDate. 

     

    I'm not sure how to write the expression. Should be something like:

    sum( {<Min(SalesDate)={"=SalesDate>=UpdateDate"}>} Amount)

    Show Less
  • QlikView Publisher

    Task History Disappeared

    Dear Experts,Task History for executed tasks in QMC is disappeared.Can someone please help with your points.Thanks,John
  • New to Qlik Sense

    Error 1503 : Qlik Repository Service could not start on Local Computer

    Hi,I have been facing an issue while restarting the Qlik Services, i was able to start QRD and QSD but while starting QRS i got can error stating "The... Show More

    Hi,

    I have been facing an issue while restarting the Qlik Services, i was able to start QRD and QSD but while starting QRS i got can error stating "The service did not respond to start or control request in a timely fashion" 

    i tried the solution from this link > https://community.qlik.com/t5/Qlik-Sense-Deployment-Management/Qlik-Sense-2-0-1-Cannot-start-services-after-update/td-p/866022  but this didn't work for me.

    Can anyone please help me out with this.

    PFA screenshot

    QRS.PNG

     

     

    Thanks in Advance,

    PS

    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.