Forums for Qlik Data Analytics solutions. Ask questions, join discussions, find solutions, and access documentation and resources.
Forums for Qlik Data Integration solutions. Ask questions, join discussions, find solutions, and access documentation and resources
Share your best Qlik apps and discuss impacts with peers! Show your work and get recognized for innovative uses of Qlik technologies.
Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.
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
ID | APH_MKT | Market | Sales |
1 | 0 | 1 | 200 |
2 | 0 | 1 | 300 |
3 | 1 | 1 | 230 |
4 | 1 | 1 | 19 |
5 | 0 | 1 | 89 |
Thanks in Advance
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?
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!
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
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!
Groupe des Utilisateurs Francophones
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
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.
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
MVP
22785MVP
8645Employee
8630MVP
8190MVP & Luminary
7987Employee
6506MVP & Luminary
5324MVP
5170MVP & Luminary
4323Employee
4106Hear from the Qlik Community team about the latest platform enhancements and other topics.
Important and useful support information about end-of-product support, new service releases, and general support topics.
Hear directly from Qlik employees and stay current on the latest and greatest information about Qlik products.
We are bringing together people and resources in response to the pandemic of Coronavirus, aka COVID-19, aka SARS-CoV-2.
Join the QlikView to Qlik Sense group and help you modernize your BI experience through adoption of Qlik Sense.
This group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights.
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!’
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.