Qlik Community

Ask a Question
Welcome to Qlik Community
cancel
Showing results for 
Search instead for 
Did you mean: 
1,954 online
Announcements
Join us March 10th, 7 Ways Modern Analytics Can Help You Take Smarter Action. REGISTER NOW

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

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

    New to Qlik Sense

    issue with flag

    Hi Community,facing issue with flag, please help what I did wrong.This is my table...  (I'm trying to create flag, if market is 1 should calculate eve... Show More

    Hi Community,

    facing issue with flag, please help what I did wrong.

    This is my table...  (I'm trying to create flag, if market is 1 should calculate everything 838  and if APH_MKT is 1 that should be 249)

    IF(Market=1, 'Genaral', IF(APH_MKT=1, 'APH', 'N/A')) as Flag

    IDAPH_MKTMarketSales
    101200
    201300
    311230
    41119
    50189

    Thanks in Advance

    Show Less
  • forum

    New to Qlik Sense

    Sorting

    I'm showing the last 12 months' data and I'm using wildmatch statement with the Month field in the sorting." WildMatch(Month,'Mar','Apr','May','Jun','... Show More

    mnvrma_0-1614770641985.png

    I'm showing the last 12 months' data and I'm using wildmatch statement with the Month field in the sorting.

    " WildMatch(Month,'Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec','Jan','Feb') "

    I have to change this statement for the upcoming month.

    is it possible to do sorting in other method or with any new field?

    Show Less
  • forum
  • forum

    New to Qlik Sense

    Stacked bar chart without dimensions

    Hello guys!I need to make a stacked bar chart but I don't have the dimension.On the X-axis I need to put for example: London, England, Europe (so 3 ba... Show More

    Hello guys!

    I need to make a stacked bar chart but I don't have the dimension.

    On the X-axis I need to put for example: London, England, Europe (so 3 bar), and on the Y-axis: 'Provided per user', 'Provided per user (England)', 'Provided per user ( Europe)' and 3 more measures: 'Provided per capita', 'Provided per capita (England)', Provided per  capita (Europe)'.

    Thanks for your reply!

    Show Less
  • forum

    New to Qlik Sense

    Comment indiquer à QlikSense le filtre "depuis plus de 60 jours" (>60 jours) sur...

    Bonjour,J'aimerais faire un graphique qui m'affiche tous les équipements qui n'ont pas été utilisé depuis plus de 30 jours. Mon format de date est DD/... Show More

    Bonjour,

    J'aimerais faire un graphique qui m'affiche tous les équipements qui n'ont pas été utilisé depuis plus de 30 jours. Mon format de date est DD/MM/YYYY HH:mm:ss AM

    J'ai "triché" en mettant <60 jours à la date exacte de ce jour qui donne 1/4/2021 :

    Count({<LAST_UPDATE = {"<1/4/2021 12:12:12 AM"}>} ASSAY_ID)

    Mais j'aimerais le faire de manière plus automatisable avec des fontions ou je ne sais pas comment je peux faire ?

    J'ai essayé Count({$<LAST_UPDATE = {"<=$(=Addmonths(Today(),-2))"}>} edoc_document_id) mais ça ne fonctionne pas également..

    Merci d'avance !

    Waïl Riachi

    Count({} ASSAY_ID) Mais j'aimerais le faire de manière plus automatisable avec des fontions ou je ne sais pas comment je peux faire ? J'ai essayé Count({$} edoc_document_id) mais ça ne fonctionne pas également.. Merci d'avance ! Waïl Riachi

    Show Less
  • forum

    New to Qlik Sense

    find best dimension by metric from a filtered dimension list

    Hi everyone! First time asking a question 🙂 We have some kind of feedback screen, and I want to create a KPI view of the language with the highest go... Show More

    Hi everyone! 

    First time asking a question 🙂 

    We have some kind of feedback screen, and I want to create a KPI view of the language with the highest good feedback rate. However, I only want to include languages where we have a minimum number of feedbacks. 

    I managed without the filter to get to this:
    FirstSortedValue(language, -Aggr(Count({<speed_feedback = {'good'}>}distinct email)/count({<first -= '-'>} distinct email), language))

    Which works, but I can't seem to manage to create a filter by language count for example. Something like count(language) > 50 
    as an example. 

    Thanks for helping out!

    Show Less
  • forum

    Groupe des Utilisateurs Francophones

    Comment indiquer à QlikSense le filtre "depuis plus de 60 jours" (&gt;60 jours) sur...

    Bonjour,J'aimerais faire un graphique qui m'affiche tous les équipements qui n'ont pas été utilisé depuis plus de 30 jours. Mon format de date est DD/... Show More

    Bonjour,

    J'aimerais faire un graphique qui m'affiche tous les équipements qui n'ont pas été utilisé depuis plus de 30 jours. Mon format de date est DD/MM/YYYY HH:mm:ss AM

    J'ai "triché" en mettant <60 jours à la date exacte de ce jour qui donne 1/4/2021 :

    Count({<LAST_UPDATE = {"<1/4/2021 12:12:12 AM"}>} ASSAY_ID)

    Mais j'aimerais le faire de manière plus automatisable avec des fontions ou je ne sais pas comment je peux faire ?

    J'ai essayé Count({$<LAST_UPDATE = {"<=$(=Addmonths(Today(),-2))"}>} edoc_document_id) mais ça ne fonctionne pas également..

    Merci d'avance !

    Waïl Riachi

    Show Less
  • forum

    New to Qlik Sense

    affiché sur un graph les 12 derniers mois glissants

    Bonjour à tous, J'ai une appli Qlik Sense avec plusieurs graphiques avec en abscisse des dates. Je souhaiterais sur cet axe, n'afficher que les dernie... Show More

    Bonjour à tous, 

    J'ai une appli Qlik Sense avec plusieurs graphiques avec en abscisse des dates. Je souhaiterais sur cet axe, n'afficher que les derniers mois glissant , je vous joins une capture et ci dessous ma formule actuelle : 

     

    "= month([Date Expédition]) &'.'& Year([Date Expédition])"

     

    Par avance merci à vous tous.

    Show Less
  • forum

    New to Qlik Sense

    Count set analysis does not return expected results

    Hi there , I am struggling to understand why my expression gives a wrong result.I want to calculate customers with event type P whose total events is ... Show More

    Hi there , I am struggling to understand why my expression gives a wrong result.

    I want to calculate customers with event type P whose total events is >= 2. The answer should be 3, but my set analysis giving me 4. 

    COUNT({<[Event Type]={'P'},
    [Customer ID] = {"=sum([Total Events])>=2"}
    >}distinct[Customer ID]

    The expression seems to ignore the Event Type ='P'.

    Could you please help me? I am very new to qliksense.

    Thank you

    q11hhg_1-1614764152833.png

     

     

    Show Less
  • forum

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

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