Hi everybody,
I have an excel made in this way:

the note refer to question "Is the shop in city center?"; note1 refer to "Shop Size", and note2 refer to "Are there enough sale item".
I want to obtain a table like that:

Is possible to obtain it without using ALIAS? Maybe using the cell of excel like "A";"B";"C"....

Thank you so much
BYE 🙂

Greetings Experts!

The Surname field contains the majority of names but needs to be standardized to follow a consistent naming convention. Generally, the first name is properly formatted, although sometimes the first name is included in the surname field, even though it's captured separately.

Furthermore, the middle name is often missing, and the surname typically holds most of the entries. However, there are occasional inconsistencies within this field, such as titles appearing at the end or unusual characters.

Nonetheless, the main goal is to primarily separate the surname into middle and last names

.Below is a data sample to provide a clearer understanding. Thanks in advance @marcus_sommer @rwunderlich @or  @steeefan  

Load * inline [
First Name,Surname
David, David N.O Plies
Ivan,Ojo-Yaw
Jim,Jim Jame Jones
ESTATE,ESTATE OF Mke Peters-Sui
Theresa,Theresa cols / Henry cols
O.,O.J Johnson (Mrs.).
lt. LT. Col Larson
Duke,Duke L.T.Y
Reagan,Rita Rosilina Addo ];

Hello,

I have an application built in Qlik Sense which is already connected to SSMS. There are already tables pulled over from SSMS, and many reports are built using that data. I am adding a new section in the data load editor, and I am trying to pull another table from SSMS and load it into Qlik Sense. However, every time I write my load script, it gives me an error. Interestingly, when I tried loading the same data into an empty application, it worked fine. What could be the problem preventing me from pulling the data into my existing application?

My load script is simple:

Load:

select ID, Rev1, Rev2,Rev3

From ABCTable

Where Year=2024 and Status= 'Active'

Thank you!

Hi ,

I have a requirement  that when a user from a certain country logs into Qliksense and run the app , he should see data related to his country only. Is this possible within Qliksense? When a user who doesn't have the mapping country executes the app , no data should be returned.

Best Regards

Vamsi

I want to upgrade my existing version of Qlik Sense Enterprise from release February 2023 to February 2024. The existing version still uses the PostgreSQL 9.6 database. So I want to use the Qlik PostgreSQL Installer to upgrade and unbundle the PostgreSQL database.

I used version 1.3 instead of 1.4 of the QPI tool as my folder where Qlik is installed is not the default "C:\program files\qlik\sense" folder.

After a few minutes the QPI returns an error and refers to the log folder. Within this log folder in the install-postgresql.log file, the following lines are included:

-----------------------------------

Called ClearAcl (C:\Program Files\PostgreSQL\14\data)...
Executing batch file 'rad811EC.bat'...
C:\Program Files\PostgreSQL\14\data NT SERVICE\TrustedInstaller:(I)(F)
NT SERVICE\TrustedInstaller:(I)(CI)(IO)(F)
NT AUTHORITY\SYSTEM:(I)(F)
NT AUTHORITY\SYSTEM:(I)(OI)(CI)(IO)(F)
BUILTIN\Administrators:(I)(F)
BUILTIN\Administrators:(I)(OI)(CI)(IO)(F)
BUILTIN\Users:(I)(RX)
BUILTIN\Users:(I)(OI)(CI)(IO)(GR,GE)
CREATOR OWNER:(I)(OI)(CI)(IO)(F)
APPLICATION PACKAGE AUTHORITY\ALL APPLICATION PACKAGES:(I)(RX)
APPLICATION PACKAGE AUTHORITY\ALL APPLICATION PACKAGES:(I)(OI)(CI)(IO)(GR,GE)
APPLICATION PACKAGE AUTHORITY\ALL RESTRICTED APPLICATION PACKAGES:(I)(RX)
APPLICATION PACKAGE AUTHORITY\ALL RESTRICTED APPLICATION PACKAGES:(I)(OI)(CI)(IO)(GR,GE)

Successfully processed 1 files; Failed processing 0 files

Removing inherited ACLs on (C:\Program Files\PostgreSQL\14\data)
Called Die(Failed to reset the ACL (C:\Program Files\PostgreSQL\14\data))...
Failed to reset the ACL (C:\Program Files\PostgreSQL\14\data)

Script stderr:
Program ended with an error exit code

-----------------------------------

I'm an admin and I run the tool as administrator. Also I disabled UAC, but without any success. Please help.

Hello Qlikkies,

We are hosting a meetup event at the end of the month (May 30th) for the 4 groups I manage with @marksouzacosta: Atlanta, Boston, Dallas, Portland. We will discuss Qlik AutoML, Automations, LLMs, how this all work together from a Language perspective.

For more information, enter one the meetup groups and register for the event. Links follow:

Atlanta: Qlik Meetup - Atlanta | Meetup

Boston: Qlik Meetup - Boston | Meetup

Dallas: Qlik Meetup - Dallas | Meetup

Portland: Qlik Meetup - Portland | Meetup