Qlik Community

Ask a Question
Welcome to Qlik Community
cancel
Showing results for 
Search instead for 
Did you mean: 
944 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

    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
  • forum

    New to Qlik Sense

    Qliksens desktop

    Why I am not able to open qliksens desktop even after using unlock file from qlik branch? 
  • forum

    QlikView App Dev

    Using the GetFieldSelections()

    Hello all,I have as an example:Field_axyz I want to do some calculations based on the value selected in Field_a (as an example GetFieldSelections(Fiel... Show More

    Hello all,

    I have as an example:

    Field_a
    x
    y
    z

     

    I want to do some calculations based on the value selected in Field_a (as an example GetFieldSelections(Field_a)=y)

    let vTest_y=B0_y + B1_y + B2_y;

    B0_y, B1_y, B2_y are already loaded as fields.

    I want only to catch them based on the selected value and to affect the calculated value into new variable named vTest_y.

    Any help please?

    Thanks in advance.

    Show Less
  • forum

    QlikView App Dev

    Mekko Chart total on top

    Hi.it is possible to show the total in the top in mekko chart?.Regards.
  • forum

    Connectivity & Data Prep

    No puedo lograrme en safari con Qlik sense

    No puedo ingresar con el safari en mac o en un iPad con el Qlik sense. desde ya muchas gracias.
  • forum

    New to Qlik Sense

    Instalação Qliksense Desktop

    Bom dia !Não consigo baixar o arquivo .exe do QlikSense Desktop. Já tenho conta no Qlik e quando digito entrar ele dá Mensagem: Obrigado pelo seu inte... Show More

    Bom dia !

    Não consigo baixar o arquivo .exe do QlikSense Desktop. Já tenho conta no Qlik e quando digito entrar ele dá Mensagem:

     

    Obrigado pelo seu interesse no Qlik Sense... envia um email mas para avalição do Sense on Cloud Services

     

    Alguém sabe como baixar o .exe ???

     

    Grato

    Show Less
  • forum

    App Development

    Firstsortedvalue and count

    Hi experts,I have a table that shows segments of the customers with validity start date and validity end dates like,customeridsegmentvaliditystartdate... Show More

    Hi experts,

    I have a table that shows segments of the customers with validity start date and validity end dates like,

    customeridsegmentvaliditystartdatevalidityenddate
    1newcomer01.01.202031.12.2020
    1loyal01.01.202131.12.2021
    2premium01.01.202031.12.2020
    2loyal01.01.202131.12.2021

     

    What i am trying to do is to count the customers according to their segments for a specific as-of date.

    For instance if as-of date is 17-03-2021 (=vAsOf) counts should be:

    newcomer:0

    loyal:2

    premium:0

     

    What i did is in a KPI object for , say, "Loyal":

    measure:

    count({$<segment = {'loyal'},vAsOf={">=$(=firstsortedvalue( validityenddate= {'>$(=vAsOf)'},validitystartdate= {'<$(=vAsOf)'} >} validitystartdate,-validitystartdate))"}>}distinct [customerid])

    But it is not right. 

    Could you please help me on the problem?

    Regards,

    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