Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
logo
  • 152,698 members
  • 6,631 online
  • 1,702,925 posts
  • 127,370 Solutions
  • Welcome to Qlik Community

    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

    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.

    Support

    Chat with us, search Knowledge, open a Case, read the latest Updates Blog, find Release Notes, and learn about our Programs.

    Events

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

    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.

    About

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

    Blogs

    Hear directly from Qlik employees in our ten unique blogs.

    Qlik Resources

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

    Qlik Academic Program

    Qlik gives qualified university students, educators, and researchers free Qlik software and resources to prepare students for the data-driven workplace.

    Community Sitemap

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

    Recent Discussions

    • No Boards Found
    • forum

      New to Qlik Sense

      Current month

      Hello i'm trying to create a field which will "predict" shop monthly revenue based on current average revenue. In other words im taking revenue from c... Show More

      Hello i'm trying to create a field which will "predict" shop monthly revenue based on current average revenue. In other words im taking revenue from current month and divide it by days that have already passed. Then im multiplying this number by number of days that there are in month.

      So it look like this :
      ((Sum({<[channel]={'ABC'},Yearx={'2022'},[Monthx]={'May'}>} [Revenue]))/(day(today())-1))*31


      So as you can see i have put manually year, month and number of days in a month. i would like to automate this so i won't have to change it every month 🙂

      But i cant figure it out

      I've tried with [Monthx]=month(today()) but it doesnt work...

      Show Less
    • forum

      Integration, Extension & APIs

      DUO for IDP/SSO for Qliksense SAAS ?

      Hi:  Has anyone figured out how to integrate DUO, which is SAML standard, to Qliksense SAAS, as IDP/SSO? Or is it just impossible because QS only supp... Show More

      Hi:  Has anyone figured out how to integrate DUO, which is SAML standard, to Qliksense SAAS, as IDP/SSO?

      Or is it just impossible because QS only support OIDP standard ? 

      We have DUO already and don't want to adopt something else unless we absolutely have to

      thanks for any info,

      Don

      Show Less
    • forum

      App Development

      radar chart qliksense issue

      Hello community I'm facing an issue about add many measures on the radar chart (bundle vizualisation) we can only put 1 measure... we cannot realise t... Show More

      Hello community

      I'm facing an issue about add many measures on the radar chart (bundle vizualisation)

      we can only put 1 measure...

      we cannot realise the same viz like qlikview ( in order to show benchmark for example)

      Is there a tips in order to realize real Radar Chart?

      Tanka a lot

      Show Less
    • forum

      New to Qlik Sense

      Grouping and Stacking Bars Graph

      Hi! I have a problem with the bar chart. Can I create a grouped bar chart and one of the bars contains two stacked measures? Thanks!  
    • forum

      New to Qlik Sense

      Data Type Alignment

      Within Qlik Sense Hub, I am trying to create a YYYYMM table to link to several other tables. However, I cannot seem to get the data types to align bet... Show More

      Within Qlik Sense Hub, I am trying to create a YYYYMM table to link to several other tables. However, I cannot seem to get the data types to align between tables so when I try to connect on this field, the connection seems poor. Both fields are coming from imported excel files and I have reviewed the fields in each file several times to ensure they are the same within the underlying excel. I don't understand why Qlik left justifies one column but right justifies the other column (see screenshot).

      Any help on how to get these fields to align with each other is greatly appreciated.

      kdstrin1_0-1652972857915.png

       

      Show Less
    • forum

      Brasil

      Variação de preço por ano

      Boa tarde, Preciso fazer calcular a "variação" do preço por ano conforme o print abaixo, pode me ajudar por favor? Muito obrigado!
    • forum

      New to Qlik Sense

      Cumulative field by two dimensions

      Hi team, I would like to get the field "Cumulative cost"   year contract code claim cost Cumulative cost 1 a 1 10,00 € 10,00 € 1 a 2 20,00 € 30... Show More

      Hi team,

      I would like to get the field "Cumulative cost"

       

      year contract code claim cost Cumulative cost
      1 a 1 10,00 € 10,00 €
      1 a 2 20,00 € 30,00 €
      2 a 3 5,00 € 5,00 €
      2 a 4 30,00 € 35,00 €
      3 b 5 40,00 € 40,00 €
      3 b 6 5,00 € 45,00 €
      3 b 7 5,00 € 50,00 €

       

      Do you have some idea? I would like to have it inside of the script.

       

      Thank you very much,

       

       

      Show Less
    • forum

      QlikView Integrations

      Chart representation

      Hello! I import data in te following form: Apartment ID AIR CONDITIONING HEATING BALCONY PARKING 255 YES NO NO NO 301 NO YES NO YES 075 NO NO... Show More

      Hello!

      I import data in te following form:

      Apartment ID AIR CONDITIONING HEATING BALCONY PARKING
      255 YES NO NO NO
      301 NO YES NO YES
      075 NO NO NO NO
      111 YES YES NO NO
      023 YES YES YES YES

       

      I would like to create a chart/table as the following:

        YES NO
      AIR CONDITIONING =count({<AirCond={YES}>},AirCond)=3 =count({<AirCond={NO}>},AirCond)=2
      HEATING =count({<Heating={YES}>},Heating)=3 =count({<Heating={NO}>},Heating)=2
      BALCONY =count({<Balcony={YES}>},Balcony)=1 =count({<Balcony={NO}>},Balcony)=4
      PARKING =count({<Parking={YES}>},Parking)=2 =count({<Parking={NO}>},Parking)=3

       

      Any idea of how I could do this?

      Show Less
    • forum

      App Development

      Accumulate all values up to the selected filter

      I have a problem creating a Set function for accumulating all valaues up to the selected filter (Year, Month, Date). My aim is to SUM all values and d... Show More

      I have a problem creating a Set function for accumulating all valaues up to the selected filter (Year, Month, Date).

      My aim is to SUM all values and display them in a bar char (drill down year, month, date).

      The values should be summed up to the max selection.

      For example: if year 2022 is selected, all values before 31.12.2022 summed up.

       

      ID Year Month Date Value

      1

      2022 02 01.02.2022 50
      2 2022 01 01.01.2022 50
      3 2021 12 01.12.2021 50
      4 2021 11 01.11.2021 50
      5        
               

       

      Show Less
    • forum

      App Development

      Calculate the percentile in the data array for the expression

      Hello! I want to get a table chart in which I will see the following: partner, keyword, number of customers, percentile (which percentile corresponds ... Show More

      Hello!

      I want to get a table chart in which I will see the following: partner, keyword, number of customers, percentile (which percentile corresponds to the number of customers for this keyword inside the partner in the row).

      I understand that I need to use a fractile to calculate percentiles in qlik sense, but I have not yet managed to figure out how to get a fractile to express the number of customers within a partner group for my table.

      partner keyword customers perc (fractile)
      p1 k11 10 0.40
      p2 k33 5 0.30
      p2 k22 20 0.85

       

      Thanks in advance for any tips for this!

      Show Less

    Get Started On Community

    Start Here Get Started On Community

    Top Participants

    Blogs

    Qlik Product Innovation Blog

    Learn about what's new across all of the products in our growing Qlik product portfolio.

    Blogs

    Support Updates Blog

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

    Blogs

    Community News

    Updates about Qlik Community Platform as well as news and announcements.

    Blogs

    Qlik Design Blog

    All about product and Qlik solutions: scripting, data modeling, visual design, extensions, best practices, etc.

    Japan Group

    Japan

    Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。

    Request to join

    Brasil Group

    Brazil

    Welcome to the group for Brazil users. .All discussions will be in Portuguese.

    open to all

    Deutsche User Group

    Deutsche User Group

    Der deutsch(-sprachig)e Qlik-Markt bietet so manche Spezialität, die sich hier leichter diskutieren läßt.

    All are welcome

    Events

    Unleash the Power of Your Finance Data

    Transform financial outcomes with next-gen business intelligence strategies

    Available On-Demand

    Events

    When You Liberate Your SAP Data, Everything Qliks

    How Qlik helped Greene Tweed reduced time to insights by 65%

    Now On-Demand

    Events

    Live Instructor Webinars

    Attend a live webinar session with our expert instructors and special guests to review learning topics in the Qlik Continuous Classroom and beyond.

    Live Instructors