Hello,

The Paris Olympics are in 426 days!

In the meantime, we have just developed a mashup made with #Qlik and #Talend to analyze data from all the Olympic Games since 1896️ : 51 editions, 223 countries, 729 events, +19k medals, + 140k athletes…

link : https://www.acssi.fr/jo2024/

In progress : English language, font optimization, new Data, optimizations, addition of Winter Olympics data for the last 2 editions, Paris Olympics calendar, live statistics of the Paris Olympics...

Do not hesitate to share your feedback and your ideas with us so that we can evolve the web site.

Many Thanks,

Olivier

Qlik Sense Enterprise on Windows #sport #talend

As we have many many apps, there is a server going to be decommissioned. I found the related data connection name. 

How I can search across all apps if that Data Connection been used?

Thanks in advance.

I have Project and time slot in seperate tables.

I want to schedule time slot for group of projects based on certain condition.

If 1. Project review is 1st review schedule 45 mins

   2. Project review is not 1st review schedule 15 mins

Schedule Time (9:00 am to 11:300 am) for every monday.

Project Data:

Project ID, Review, Date, Region,  Time Slot, Status

A, 1st Review, 5/13/2024, AP,<Fill the Time slot> , <USED- if alloted, Otherwise BLANK>,

A, 2st Review, 5/13/2024, AP,<Fill the Time slot> , <USED- if alloted, Otherwise BLANK>,

A, 3st Review, 5/20/2024, AP,<Fill the Time slot> , <USED- if alloted, Otherwise BLANK>,

A, 4st Review, 5/20/2024, AP,<Fill the Time slot> , <USED- if alloted, Otherwise BLANK>,

B, 1st Review, 5/13/2024, AP,<Fill the Time slot> , <USED- if alloted, Otherwise BLANK>,

B, 2st Review, 5/20/2024, AP,<Fill the Time slot> , <USED- if alloted, Otherwise BLANK>,

C, 1st Review, 5/13/2024, AP,<Fill the Time slot> , <USED- if alloted, Otherwise BLANK>,

C, 2nd Review, 5/13/2024, AP, <Fill the Time slot> , <USED- if alloted, Otherwise BLANK>

Timeslot Table 

Output:

Project ID, Review, Date, Region,  Time Slot, Status

A, 1st Review, 5/13/2024, AP,9:00 - 9:45 , USED,

A, 2nd Review, 5/13/2024, AP,9:45 - 10:00 , USED,

B, 1st Review, 5/13/2024, AP,10:00 - 10:45, USED,

C, 1st Review, 5/13/2024, AP,10:45 - 11:30, USED,

C, 2nd Review, 5/13/2024, AP, No Slot available, Not Confirmed,

@Dataintellinalytics 

I am trying to create a pivot table that shows "Current Sales" and "Previous Month Sales" for each "month year" 

Data:

Expected outcome in Pivot Table

Hope you can help me to solve this requirement 🙂 

Thank you very much for your assistance!

Hi guys,

I just wanted to know the extent of Machine Learning, predictive analytics, different data analysis algorithms we can run or integrate with Qlik tool for a proposal we received from client. If anyone can help, TIA

I'm a one-man shop, building our DW, data models, datasets, with our reporting all in PBI. While a number of users rely on my reporting, either directly or via "Analyze in Excel," very few people are actually using PBI to create their own reports.

Recently, someone that joined the company spoke well regarding QlikSense, that it was easy for users to jump right in and build reports.

If you've had experience using QlikSense, I'd be curious to get your thoughts. Is it user-friendly? Is there a use case for having both Power BI and QlikSense? I find it hard to believe that the same user community that has not been motivated build PBI reports off of my pre-built datasets and flows, will begin using QlikSense to do so, but who knows?

I would appreciate any insight you have. TIA!

I know there are a ton of topics about it, but I'm the next to get this problem: the connection between office and nprinting does not work. It used to work on my old computer but fails there - even as I did install (and now reinstalled twice) office 2019 especially for that goal.
I don't get it working on my new computer with office 365, including trying the tips on this forum and two nPrintingDesigner versions.
Has anybody an idea what to try next? Or is there any help out there?

HI,

I installed QS server (February 24), During the installation I noticed that the computer name that appears automatically does not match the real hostname, I changed it in "Computer host name" field to the real hostname.  

* The computer name that appeared initially is a "Doman Control" or the servers environment. (VMware server that devised for some computers)  

* The installation is a single node environment 

After installation I can't access to HUB or QMC ("This page cannot be reached"). All services was up

* hostname that present in certificate (mmc) does not match to real hostname (appears what was received automatically installation)

I tried to recreate the certificates like here-  Did all the steps, but for no success 

https://community.qlik.com/t5/Official-Support-Articles/How-to-recreate-or-just-delete-certificates-in-Qlik-Sense-No/ta-p/1712692

I ran this command: 
"C:\Program Files\Qlik\Sense\Repository\Repository.exe" -bootstrap -iscentral -restorehostname

And the certificate generation failed, this error was received -

Fatal exception during bootstrap: Newly created client certificate not valid; root certificate can't sign new certificates; 

What else can be done to make it work? I don't know what is the exact problem 

Does the computer name have to be the same as the certification?

Thanks  

***

Some details about system and environment 

1. Windows server 2022
2. VMware server
3. Singe node environment