Qlik Community

Ask a Question
Welcome to Qlik Community
cancel
Showing results for 
Search instead for 
Did you mean: 
906 online
Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY

Data Analytics

Forums for Qlik Data Analytics solutions. Ask questions, join discussions, find solutions, and access documentation and resources.

Data Integration

Forums for Qlik Data Integration solutions. Ask questions, join discussions, find solutions, and access documentation and resources

QlikWorld

This forum will provide you with event highlights and related content to get you energized and ready for QlikWorld Online.

Groups

Join a Group that is right for you and get more out of your collaborations. Some groups are closed. Closed Groups require approval to view and participate.

Qlik Gallery

Share your best Qlik apps and discuss impacts with peers! Show your work and get recognized for innovative uses of Qlik technologies.

Ideation

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

Qlik Resources

Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.

Events

Learn about upcoming Qlik related events, webinars and local meetups.

Blogs

Hear directly from Qlik employees in our ten unique blogs.

About

Get started, find How-To documents, and join general non-product related discussions.

Community Sitemap

Here you will find a list of all the Qlik Community forums.

Recent Discussions

  • No Boards Found
  • forum

    Deployment & Management

    QMC not sync between cluster nodes

    Hi, we deployed a multi node installation and noticed a strange behave when changing security rules on QMC.Some of the nodes are affected immediately ... Show More

    Hi, we deployed a multi node installation and noticed a strange behave when changing security rules on QMC.

    Some of the nodes are affected immediately when a security rule is changed, but other take minutes or hours to sync the new security rule. This happens often on the central node.

    We tried several things, including increasing the number of max connections on postgress, but the only thing take seems to work is restarting the machine services. Have anyone got this error already? Thanks in advance.

     

    Show Less
  • forum

    App Development

    Qlik Sense table chart font size

    Hi all,I'm using Qlik Sense June 2019 edition.I've been requested to try enlarging the table font size in a certain app, I'm using a table chart,the o... Show More

    Hi all,

    I'm using Qlik Sense June 2019 edition.
    I've been requested to try enlarging the table font size in a certain app, I'm using a table chart,
    the one that comes with Qlik(Not an extension).

    Seems like there is no option of adjusting the table text font size over the June 19 edition.
    I would like to know if there is a hidden option of font size adjustment for the table chart (Pretty sure there isn't) or if there is an extension that acts as a table and have the setting of font adjustment.

    Another option that was offered to me use to use "Sense Theme", I've tried to use it to adjust the font size but it's not applying to the table chart, also seems like there is no option to apply changes over the table chart(Screenshot attached).

    shayd_0-1617872218437.png


    Any suggestions?
    Thanks.

    Show Less
  • forum

    App Development

    Qlik Sense Saas. Zero without a slash (or angled line) through it

    Hi AllMy client has asked me to remove the slash from the zero'sWhat I found is most of the Apps follow this format. But a few don't. I though it woul... Show More

    Hi All

    My client has asked me to remove the slash from the zero's

    What I found is most of the Apps follow this format. But a few don't. I though it would eb one of the initial SET Statement, But when I copied and pasted the SET statements from the non slash zero App to the slash zero App it make no difference

    And help will be appreciated

    Thanks Robert

     

    Slash

    robert99_0-1617165579577.png

    No slash

    robert99_1-1617166003091.png

     

    Show Less
  • forum

    New to Qlik Sense

    Table Join

    Hi, I am quite new to Qlik sense.I would like to join my two tables in following. Table-1Table -2Final Table  I would like to have as Final table as t... Show More

    Hi, I am quite new to Qlik sense.

    I would like to join my two tables in following. 

    Table-1

    YanMin_0-1617868548136.png

    Table -2

    YanMin_1-1617868574319.png

    Final Table 

    YanMin_2-1617868597534.png

     

    I would like to have as Final table as they will not be in different rows if Product Name is Same.

    Can anyone assist?

    Thanks in advanced.

     

    Show Less
  • forum

    New to Qlik Sense

    If Load statement

    Hi, Can anyone help me with following if load statement. My files got different column names. So what I want to do is after certain date, I want load ... Show More

    Hi, 

    Can anyone help me with following if load statement. My files got different column names. So what I want to do is after certain date, I want load different column name. My codes is as follows: 

    if(Date(right(FileBaseName(),8))<Date('20210405'),

    "Wishlist Visitor","Wishlist Visitors") as "Wishlist Visitor",

    The spelling of column name is different for the files that is before that specific date. That codes seems no work.

    Can anyone help?

    Thanks in advanced

     

    Show Less
  • forum

    New to Qlik Sense

    Why even use set analysis ?

    What's the point of using set analysis since it accepts only Data Model Fields and not Dimensions .1. I see that almost every case where we need set a... Show More

    What's the point of using set analysis since it accepts only Data Model Fields and not Dimensions .

    1. I see that almost every case where we need set analysis, it can be replaced by a combination of other functions like aggr(), if() etc. So do we really require set analysis?

    2. I have a date field in my data model called "order_date" and dimensions "order_year", "order_week" which are derived from "order_date" field using formula Year(order_date) and Week(order_date) . I can't use these two dimensions in my set expressions. For eg, I can't use these dimensions like this 

    =Sum({<order_year={"<=$(=vMaxYear)"}>}Sales) 

    because "order_year" being a dimension can't be used and this formula will throw an error.   So how do you handle situations like these and does Set analysis even help when I have my Calendar fields as Dimensions? If so, in what cases? 

    Thanks in Advance

    @Henric_Cronström @sunny_talwar @swuehl 

    Show Less
  • forum

    QlikView App Dev

    Aggregate with different set expressions

    there are 2000 properties in 10 different countries. Each property has a purchase price.there are 5 appraisers. Each of them reassess some of the 20 p... Show More

    there are 2000 properties in 10 different countries. Each property has a purchase price.
    there are 5 appraisers. Each of them reassess some of the 20 properties.
    This leads us to two tables.

    1: property, country, purchase price, date of sale announcement, status of sale
    2: appraiser, property, estimated price

    Table one shows property, country, purchase price overruled by estimated price of selected appraiser if exists (called "current price")

    IF(
         ISNULL(ONLY([estimated price by appraiser]))
         ,ONLY($(setexpression) [purchase price])
         ,ONLY([estimated price by appraiser])
         )

    where $(setexpression) restricts to specific timeframe when sales have been announced first as well as to specific status of sale

    wanted: table two should show the sum of current prices per country (formula above aggregated by country) restricted to properties that fit to $(setexpression) in general

    Show Less
  • forum

    App Development

    Help with Section Access

    Hi All,I need help with section acesss.In the below table has the sample data where i want to apply Section access User level, but with some condtions... Show More

    Hi All,

    I need help with section acesss.

    In the below table has the sample data where i want to apply Section access User level, but with some condtions.

    Dep, ID, user
    123 1 AAA
    123, 2, BBB
    123, 3, CCC
    456, 4, DDD
    456, 5, EEE
    456, 6, FFF

    User BBB and CCC reports to AAA - So AAA should see data for himself and also for BBB and CCC only.
    Where BBB and CCC should see only their data

    Same way, User EEE and FFF reports to DDD- So DDD should see data for himself and also for EEE and FFF only.
    Where EEE and FFF should see only their data.

    Please help me.

    Thanks in Advance

    Show Less
  • forum

    New to Qlik Sense

    classify the sales proposal as won/lost based on an event log

    Hello,I have a simple timeseries data representing a sales event log. I would like to create a new column in script editor that classifies the given O... Show More

    Hello,

    I have a simple timeseries data representing a sales event log. I would like to create a new column in script editor that classifies the given Ops id as WON, LOST or PENDING based on the below conditions:

    IF for a given Ops id a "Deal signed" milestone exists, the new column (status) should return WON for all of the Ops id records

    IF for a given Ops id a "Opportunity cancelled" milestone exists, the new column should return LOST for all of the Ops id records

    IF none of the above, then new column sould return PENDING

    Excel example attached, will appreciate any advice

    Show Less
  • forum

    App Development

    Creating a Target Based of calculations

    Hi,I am new to Qlik sense and need a little bit of help. I need to insert a static target based off of the average number of customers  from a financi... Show More

    Hi,

    I am new to Qlik sense and need a little bit of help. 

    I need to insert a static target based off of the average number of customers  from a financial year over 52 weeks. I believe I need to count the total amount of customers id's first, then sum them, then divide it by 52 weeks to get the average.

    So in excel terms it would be IF( Financial_Year ='2020/2021', Sum(count(Customer_ID)/52)," ")

    I then would need to create and upper and lower target with a 5% variance each way 

    If have the first part created using set analysis: Count({ $<Financial_Year ={'2020/2021'}>}count(Customer_ID)

    I have a calendar variable that breaks down our financial weeks that I am using to plot on the graph. 

    Open to all suggestions, and really appreciate the help.

    Below is a graph of how I envisage it to look.

    alex-wb_0-1617985372157.png

    I am open to any suggestions and appreciate the help  :).

    Thanks,

    Alex

    Show Less

Get Started On Community

Start Here Get Started On Community

Top Participants

Blogs

Qlik Community Manager Blog

Hear from the Qlik Community team about the latest platform enhancements and other topics.

Blogs

Support Updates Blog

Important and useful support information about end-of-product support, new service releases, and general support topics.

Blogs

Blogs

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

Groups

Covid 19

We are bringing together people and resources in response to the pandemic of Coronavirus, aka COVID-19, aka SARS-CoV-2.

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

Online Conference

Join QlikWorld to hear from Qlik CEO, Mike Capone on activating your data for impact. You’ll also have access over 100 breakout sessions covering data integration and analytics, tips for getting the most out of your data, and a view into what the next generation of BI holds.

May 10-12, 2021

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

Direct Relief Uses Qlik to Manage Its COVID-19 Supply Chain

Qlik can help you manage your supply chain risks during COVID‑19.The nonprofit organization, Direct Relief, uses Qlik’s Supply Chain solution to scale its delivery of medical supplies worldwide.

Available on Demand