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.
Bonjour,
Je fais des manipulations sur des dates, j'ai besoin de faire la différence entre deux dates en fonction d'un autre champ.
J'aimerai bien savoir, s'il y a une possibilité de faire la différence entre ( La date de fin [11/07/2020] ) et ( la date de début [04/09/2020] ). Parce qu'en vrai, j'ai besoin de savoir est ce que la personne en question a repris le travail entre temps ou pas. Surtout, pour voir si elle a prolongé son arrêt ou elle a repris et ensuite elle a déposé un autre arrêt maladie.
En grosso-modo, je veux dire: Si ( [la date de fin (N-1)] - [la date de début (N)] ) > 1 donc le résultat sera de 1 sinon c'est 0 cela en fonction du nom de la personne .
Je vous remercie d'avance.
We use the "Launch" action that opens a PDF file (Tips and Tricks document). We open Access Point in IE and have no problems. With IE going away, we have started opening Access Point in Chrome and we have discovered that the PDF document won't open and we get this window:
We discovered that both our test and prod servers have IE installed but not Chrome. I installed Chrome, but nothing has changed. I'm not much of a server admin type. Are we on the right track? I feel that I am missing something obvious, but my search attempts on the Community were not very helpful.
Hi Everyone,
I've been struggling with this problem for quite some time now, which in my head seems to be simple but I can't figure out a solution.
I have two tables loaded in my app: Admissions and Appointments.
Admissions contains the records of when the patient was admitted at the hospital. Here is a simplified version of the table:
Admission ID | Patient ID | Admission Date |
a1 | p1 | 01/01/2020 |
a2 | p1 | 02/01/2020 |
a3 | p2 | 02/01/2020 |
Appointments contains the appointments each patient attended in a clinic
Appointment ID | Patient ID | Appointment Date |
app1 | p1 | 01/01/2019 |
app2 | p3 | 01/03/2020 |
app3 | p4 | 02/10/2020 |
I want to check the against each admission the Previous appointment this patient attended, by comparing the Admission date with the Appointment Date. Ideally by making a reference to the AppointmentID in an additional column while loading the Admissions table.
Can anybody give me some direction?
Hi Qlik Users,
I would like to write below nested if condition up to next 120 months.
Can any one suggest me to simplify this logic instead of writing 120 times.
If(MDate=MonthStart(Today()),Sales,
If(MDate=MonthStart(Today(),1),Sales,
If(MDate=MonthStart(Today(),2),Sales,
If(MDate=MonthStart(Today(),3),Sales,
If(MDate=MonthStart(Today(),4),Sales,
If(MDate=MonthStart(Today(),5),Sales,
If(MDate=MonthStart(Today(),6),Sales,
.
.
.
.
If(MDate=MonthStart(Today(),120),Sales,
0
)
))))))))))
Hello,
how can we change the label of an axis.
I got a combochart with 6 measures, the y-axis is full of the measure-names.
What i want is just two words there. But i can only display or not the names of the measurement.
Is there a possibility or a extension to customize the chart labels?
This package (referred to as QVScalabilityTools) contains a complete set of tools for easy creation, execution and analyzing of load/performance tests and regression tests.
QlikView documents to help analyze result and log files(This was previously included in this package):Scalability Results Analyzer
Older versions of the tool can be found here: Tool for easy creation of load/performance tests of QlikView (v.10 and 11)
Tools for Qlik Sense can be found here: Qlik Sense Scalability Tools (Sense v2.0, v2.1, v2.2, v3.0, v3.1)
QlikView Benchmarking tests: QlikView 12 Hardware Benchmarking Package and QlikView 11 Hardware Benchmarking Package
Note: Using windows built-in unzip functionality will not allow the .exe to launch unless unblocking zipped package first (properties -> unblock).
Included parts are:
Changelog 1.2.6->1.2.7
2019-08-26
Documentation updates due to:
- New recommended JMeter version (4.0)
- Changes to the licensing for the Oracle Java implementation (seehttps://www.oracle.com/technetwork/java/javase/overview/oracle-jdk-faqs.html)
- Open-source Java Development Kits (JDKs) have been verified for use with JMeter and the QlikView Scalability Tools
Changelog 1.2.5->1.2.6
Changelog 1.2.4->1.2.5
Changelog 1.2.3->1.2.4
Changelog 1.2.2->1.2.3
Changelog 1.2.1->1.2.2
Changelog 1.2->1.2.1
Changelog 1.1 -> 1.2
Your use of QVScalabilityTools will be subject to the same license agreement between you and QlikTech for QlikView Server. QlikTech does not provide maintenance and support services for QVScalabilityTools, however please check QlikCommunity for additional information on use of these products.
PLEASE NOTE:
The supported versions of Java are 8 and 9. Supported version of JMeter are 3.0 and 4.0, but not 3.2
Hello,
I want to send PDF to a ditribution list on Nprinting.
I want to know how to do this?and if i could create a user with le email address ,
I tried to do this but i don't know what i should put on the field NT NAME when i will create the user.
Thanks
Recently we upgraded our QV version from 12.20SR9 to 12.50SR4. And we notice that some of our reload time increased drastically.
Below is the comparison between the log files of 12.20 (left) vs 12.50 (right). It is using the exact same QVW, QVD and also same computer/server.
Previously it took about 1 minute to load this QVD, but in the new version it took 15mins! Anyone that experience this before?
Hello i have a crosstable lookinkg like this. i got a value connected to a location on each date. how can i connect the calendar week / week number (like the date 02.01.2021 would get the number 1, because its in the first week of the year) to each date? is there some way to "iterate" over the variable names, to do something like
calendar week = week([22.2.2021]), but for all imported dates?
my Crosstable import looking like this:
Directory;
CrossTable(date, *value*)
LOAD location,
[22.2.2021],
[23.2.2021],
[24.2.2021],
[25.2.2021],
[26.2.2021],
.......more dates
FROM
[***.xlsx]
(ooxml, embedded labels, table is Sheet0);
Hello,
I have a Bar chart where I want to show the dimensions only if it has two conditions (field MakeBuy should be 'make' and the calculated value should be ave 0.2
=if((MakeBuy='make'and Sum({<Source={'AccountStructureSOW'}>} Value)/
Sum({<Unit={'Costs'}>}Value)>'0.2'),SubCompetency)
the formular is shown as OK but the dimension is not guilty. what did i wrong?
Best regards
Pia
MVP
22788MVP
8646Employee
8635MVP
8190MVP & Luminary
7987Employee
6506MVP & Luminary
5330MVP
5172MVP & Luminary
4326Employee
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.