Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Bonjour à tous,
Dans un graphe, où figure le nombre d'incidents par mois, comment afficher les mois qui n'ont pas de mesure (d'incident).
Exemple :
Janv 3 incidents
Fevrier 1 incident
Avril 4 incidents
comment avoir Mars 0 incident sans creer cette ligne dans la table des incidents ?
Sachant que mes abscisses sont les An et Mois d'incidents et les ordonnées le nombre d'incidents
Merci
Users need to be able to paste a list of values from excel and use those values as selections in a field. I have seen examples of this done using variable input and a button with select action.
In my use case, however, only values that contain text characters are being returned. Values that only contain numbers are being ignored in the selection process.
Here is my current setup:
1. Variable input box to set: vMemberID_Selection
2. Button Action: Select values in a field
3. Button Field: PRIMARY_MEMBER_ID //text field
4. Button Value: =replace(vMemberID_Selection,' ',';') //replace the empty space delimiter from excel with a semi-colon
When I paste the below list from excel, only the first 3 values are returned for PRIMARY_MEMBER_ID. The last two values that only contain numbers are ignored.
PER-12345678;ORG-12345678;EMP-dsvo3sdf6sdfs48fs4;23456789;34567890
I have also tried manually converting the Button Value to text but still experienced the same behavior:
=text(replace(vMemberID_Selection,' ',';'))
=replace(text(vMemberID_Selection),' ',';')
Any ideas what could be causing this issue and how to resolve?
Hi team
I have the following questions:
1.Is it possible to get Relative-Record-Number of AS400 by AR_H_STREAM_POSITION of Qlik Replicate?
2.Is there any header or variable to output Relative-Record-Number other than AR_H_STREAM_POSITION?
I would like a primary response by 2025.4.25.
Hallo zusammen,ich
habe mich für die 30-tägige Testversion von Qlik Sense Business mit meiner geschäftlichen E-Mail registriert. Nach dem Abschluss der Registrierung werde ich jedoch immer zur "Qlik Cloud Analytics Tour" weitergeleitet und sehe keine Option, einen Mandanten zu erstellen oder in die eigentliche Qlik Sense Umgebung zu gelangen.
Wenn ich mich unter https://qlikcloud.com anmelde, erscheint "Keine Mandanten zum Verwalten vorhanden".
Könnt ihr mir helfen, meinen Testzugang korrekt zu aktivieren?
Vielen Dank im Voraus!
Hi All,
I have not much knowledge of Security rule in QMC.
There is one issue I am facing as Rootadmin. I am unable to duplicate the application in my work space.
It is for all applications.
There are two security has been created in QMC for RootAdmin and unable to disable newely created one.
In fact, i am unable to update anything in security rule. suppose i am changing any action under resouce filter, it is not getting updated. like create, Read etc..
May be security rule is getting overriden.
Request your suggestion for resolving this issue as none of developer able to duplicate the application.
I am attaching the screenshot for reference.
Thanks in advance!!
I have a virtual machine with some Excel (.xls
) files saved in a local folder.
I manually upload these files using the Data Manager in Qlik Sense to create an app.
However, when I reload the app, it fetches data from the uploaded file stored under 'Data Files' within Qlik Sense, rather than from the original source file in the local folder.
As a result, any changes made to the original Excel file (or if I replace it with a new version) are not reflected in the app after a reload.
I would like the app to always load the most recent data from the source Excel file in the local folder on the VM.
How can I achieve this?
-I also install Qlik Gateway- Direct access
-Also try to achieve this Using Qlik Data Transfer but not able to achieve
Hi All,
i would like to know the possiblity of achieving the requirement in front end.
I am struggling with calculating the opening balance and closing balance since it is very dynamic.
Initial opening balance = 20
Opening Balance = last week closing balance
Closing Balance = Opening Balance + New PR Added - PR Coverted - PR Deleted
last week closing balance is next week opening balance and so on
QVF Attached
Been working with Qlik for 5 years, never seen this issue before.
Loading data from a parquet file, all floats are rounded to 2dp when I add them as dimension. If I load the fields as TEXT(Field), the numbers come out ok, if I show them as measures, they are fine.
What's going on here? How can I fix? There's hundreds of columns being imported that are impacted so I need a general fix, not just for that specific field.
Thanks a lot
Hello!
I need to count the number of customers that have made at least one purchase in each of the last three weeks and have that in a chart where Week is the dimension. I have the following expression, but it is not calculating the correct number and I cannot figure out why. I was wondering if I needed to switch the order of IF() and AGGR(), or if there was a better way to get this result.
Thank you!
Count(distinct aggr(
if(
Count({< [Invoice Date] = {">=$(=date(Max(%DateKey)-20,'MM/DD/YYYY'))<=$(=date(Max(%DateKey)-14,'MM/DD/YYYY'))"} >} DISTINCT [Order Number]) >= 1 and
Count({< [Invoice Date] = {">=$(=date(Max(%DateKey)-13,'MM/DD/YYYY'))<=$(=date(Max(%DateKey)-7,'MM/DD/YYYY'))"} >} DISTINCT [Order Number]) >= 1 and
Count({< [Invoice Date] = {">=$(=date(Max(%DateKey)-6,'MM/DD/YYYY'))<=$(=date(Max(%DateKey),'MM/DD/YYYY'))"} >} DISTINCT [Order Number]) >= 1,
[Customer Number]
),
[Customer Number]
))
Workshops. Certifications. And Disney's Animal Kingdom® Theme Park. Only at Qlik Connect. May 13 - 15.
Optimize your data strategy with Iceberg lakehouse insights, cost-saving tips, and a preview of Qlik Talend Cloud’s no-code integration.
Data Flow simplifies, democratizes, and accelerates the last mile of data preparation for analytics, machine learning, and AI.
Read how to embed AI-powered analytics to innovate, enhance customer satisfaction, and fuel business growth.
Your journey awaits! Join us by Logging in and let the adventure begin.
Qlik empowers Foodbank Victoria with real-time data insights, optimizing food acquisition and distribution to deliver 25 million meals annually while reducing waste and costs across its statewide relief efforts.
Qlik accelerates decision-making at Alpha Auto Group, enabling seamless data integration and automation across dealerships, cutting reporting times, and driving scalable business growth.
Qlik Data Integration transforms Airbus' aircraft production, leading to over 150 replication tasks and informing more efficient analysis.
Join one of our Location and Language groups. Find one that suits you today!
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!