Everything you need to make your Qlik Community experience valuable.
Explore official Support and member created content.
A live, in-person thrill-ride - full of insights, learning, and peer-to-peer connections.
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.
Get started on Qlik Community, find How-To documents, and join general non-product related discussions.
Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.
Qlik gives qualified university students, educators, and researchers free Qlik software and resources to prepare students for the data-driven workplace.
I have date field " Expiration Date"
I want to show the Expiring Tickets counts and its Value in a Combo Chart for past four months and coming eight months
Fields :
Ticket ID
Value
Expiration Date
Hello together,
For some time now it has been possible to use the formats qvf and qvw within QV.
Unfortunately, I have not yet been able to identify any differences or what advantage the new format is supposed to have within QlikView.
Does anyone have any advice?
Thank you and greetings
Hi Team,
I installed Qlik sense using AWS marketplace :
https://aws.amazon.com/marketplace/seller-profile?id=ba4c05a7-e7ff-462b-a4d6-99d3f6e77d1f
After the installation, all the services are up and running but I am not able to hit :
Can you please help here?
Thanks,
Anmol
Bonjour,
je voudrais comparer tous les champs existant dans deux QVD, sachant que les deux QVD contenants les mêmes champs mais pas toujours les mêmes valeurs.
J'ai essayé avec NOT MATCH mais ça prend beaucoup du temps.
Est-ce que vous avez une autre solution pour comparer les champs entre les QVD et afficher seulement les lignes différentes.
Merci d'avance pour votre aide
while connecting the DB, below error getting. Kindly advise
OleDb error
Connector connect error: IDataInitialize::GetDataSource. HRESULT = 80040E4E. ErrorSource: OraOLEDB, ErrorMsg: The system cannot find message text for message number 0x80040e4e in the message file for OraOLEDB.
CONNECT TO ***
Hello, I have a problem like this: I have a table of resigners whose fields are
student ID, surname, name, date of resignation and job code. My aim is to create a table in which, to these fields, I have to add another field called status in which the serial number can become ceased or terminated based on the selection date in qlik which I call competence date. In practice, if the resignation date is greater than the accrual date selected, the enrollment must have ceased. If the resignation date is less than or equal to the accrual date, the enrollment must have ceased. I need these data because I have to create, and this is the real objective, a dynamic table in which I have, for each job code, the count of the number of freshmen who are ceased or terminated. thanks for whoever can help me.
I want to create a report to analyse worked hours compared to an employee’s assigned roster per day.
Therefore I need to create a table with the amount of hours per date according to the assigned roster
I have the following tables:
ROSTERSETTINGS
Employee_id
Roster_id
Startdate_roster
Enddate_roster
ROSTERHOURS
Roster_id
Roster_name
Roster_days
Roster_day_sequencenumber
Roster_hours
ROSTERSETTINGS EXAMPLE:
Employee_id |
Roster_id |
Startdate |
Enddate |
Startday |
999 |
123 |
1-12-2022 |
31-12-2099 |
4 |
ROSTERHOURS EXAMPLE:
Roster_id |
Roster_name |
Roster_day |
Roster_day_sequencenumber |
Roster_hours |
123 |
Roster 40 |
Mon |
1 |
8 |
123 |
Roster 40 |
Tue |
2 |
8 |
123 |
Roster 40 |
Wed |
3 |
6 |
123 |
Roster 40 |
Thu |
4 |
8 |
123 |
Roster 40 |
Fri |
5 |
6 |
123 |
Roster 40 |
Sat |
6 |
0 |
123 |
Roster 40 |
Sun |
7 |
0 |
The employee started on 1-12-2022, this is the 4th day of the assigned roster, therefore the “startday” of the ROSTERSETTINGS record is “4”.
The table I want to create is the following:
Date | Roster_day_sequencenumber | Roster_hours | Roster_id | Employee_id |
1-12-2022 | 4 | 8 | 123 | 999 |
2-12-2022 | 5 | 6 | 123 | 999 |
3-12-2022 | 6 | 0 | 123 | 999 |
4-12-2022 | 7 | 0 | 123 | 999 |
5-12-2022 | 1 | 8 | 123 | 999 |
6-12-2022 | 2 | 8 | 123 | 999 |
7-12-2022 | 3 | 6 | 123 | 999 |
8-12-2022 | 4 | 8 | 123 | 999 |
9-12-2022 | 5 | 6 | 123 | 999 |
10-12-2022 | 6 | 0 | 123 | 999 |
11-12-2022 | 7 | 0 | 123 | 999 |
Many thanks in advance for your help!
I'm working on a ticket panel, where I have the opening date and closing date of tickets. I would like to create a chart that compares these 2 values - Number of open calls and number of closed calls.
I'm working on a ticket panel, where I have the opening date and closing date of tickets. I would like to create a chart that compares these 2 values - Number of open calls and number of closed calls.
The number of open calls is correct. The number of calls closed is being divided between Sep, Oct and Nov, and it would be necessary to count everything in November, adding the 3 the result is correct, but it would need to count everything in November.
Here are the parameters used to build the graph:
Dimension: Month Opening
Measure - Open calls: Count({$<Status2 = {'New', 'Processing','Pending','Concluded','Resolved'}, SEMANA_FECHAMENTO=,Dt_Closing=, YEAR_CLOSING=, MONTH_CLOSING=, DAY_CLOSING>} Status2 ) -IT'S OK
Measure - tickets closed: Count({$<Status2 = {'Concluded'}, SEMANA_ABERTURA=,Dt_Abertura=, ANO_ABERTURA=, MES_ABERTURA=, DIA_ABERTURA>} Status2) - WRONG
Analyzing the data in table format, I identified that there are calls that were opened between Sep, Oct and Nov and that were closed only in November, but since I am using the filter Month closing = November it should be adding everything for the closing month.
Hi all,
I wanted to check if there is a chart object available in Qliksense that let's us create a data lineage or data semantic layer display, letting us display the flow of data in the underlying source database?
Say if we are getting data from 4 tables and merging to one final table in source database, i want to create a data semantics chart depicting the same and if some data is not available in one of the tables, highlight that semantic connection in red and etc,
Regards,
Darpan
Hi All,
I have 4 measure calculations
i need to divided by column(3) expression divide by column(2) to calculate.
need to display the values based on range.range values in script i stored in variable and using in table.
set vRangeTest = '<= $5M',
'> $5M and <= $10M',
'> $10M and <= $15M',
'> $15M and <= $20M';
i need to get column(3) total value divide by column(2) total value in Rate total
locationpremimun/TIv
i dont want sum for Rate totals
Expected resulst:0.0158699
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!
If you want to know what's new across all of the products in our growing Qlik product portfolio.
Get the latest Support information about end-of-product support, new service releases, and general support topics.
Read all about Qlik solutions: scripting, data modeling, visual design, extensions, best practices and more.
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.
Get ready for QlikWorld: The Conference for Data Thrill-Seekers. From exciting innovations to spine-tingling keynote presentations and lots of peer networking, you'll discover how you and your data can help your business succeed.
Subscribe to our Events and Webinar page so you do not miss an event
opportunity!
Join the "Welcome to Qlik" webinar and learn about the Qlik Ecosystem, such as Qlik Community, Learning, and Help.
There is more than one way to find upcoming events, look on the right side
of any Qlik Community forum!
Subscribe to our Events and Webinar page so you do not miss an event
opportunity!
Join the "Welcome to Qlik" webinar and learn about the Qlik Ecosystem, such as Qlik Community, Learning, and Help.
There is more than one way to find upcoming events, look on the right side
of any Qlik Community forum!