What feature of Qlik Sense causes the creation of an auto-generated script section?

- Creating a new app

- manually adding a script section

- performing a reload in debug mode

- using data manager to add data

Hello All,

I have QBS column in my dashboard,
I have to add it as Filterpane in Frontend. In taht column some records are there which starts as 

'No. of days from Assigned to Requested'
I want to show as 'Days from Assigned to Requested'

I have many recoords like this and also have some different records as SP Code, Country Code, which shows as it is there 

How to achive
Plaese help


Thanks!

Hi

I have created an AWS lambda function to update source oracle endpoint attribute archivedLogDestId using python. 

my payload to patch_endpoint is [{"op":"replace","path":"/db_settings/archivedLogDestId","value":str(taskdet['oracledestid'])}] along with that I am passing replicate server name and endpoint name. When I tried to run the lambda I am getting "errorMessage": "'AemClient' object has no attribute 'patch_endpoint'"

I am able use EM API's to get server details , task details and archivedLogDestId (existing value using export_task) from the task, but for some reason patch_endpoint is not working. Any help on this topic is greatly appriciated

I would like to report what I believe is a bug in inner and outer set expressions feature (May 2023 patch 1), not sure if this forum can be a suitable location.

Given the the script, 

Fruits:
LOAD * Inline [
Type,Color,Quantity
apple,green,1
apple,green,1
apple,green,1
orange,orange,1
orange,orange,1
];

Consider the below formulae outputs, where we select apples (which exist in the data set) and kiwis (which do not exist):

Sum({<Type={'apple'}, Color={'green'}>} Quantity)

{<Type={'apple'}>} Sum({<Color={'green'}>} Quantity)

{<Type={'apple'}, Color={'green'}>} Sum(Quantity)

Sum({<Type={'kiwi'}, Color={'green'}>} Quantity)

{<Type={'kiwi'}>} Sum( {<Color={'green'}>} Quantity)

{<Type={'kiwi'}, Color={'green'}>} Sum(Quantity)

Sum({<Type={'orange'}, Color={'green'}>} Quantity)

{<Type={'orange'}>} Sum( {<Color={'green'}>} Quantity)

{<Type={'orange'}, Color={'green'}>} Sum(Quantity)

Sum({<Type={'kiwi'}>} Quantity)

{<Type={'kiwi'}>} Sum( Quantity)

As per the results above: outer set expression is not inherited if

1. the outset set expression selects an inexistant value,
2. there is an inner set expression

Could someone confirm this is indeed a bug and whether it has already been fixed in the recent version? Thanks!

I have a bar chart that uses two different bar charts:

And I want to make it so that the two bar charts get coloured by the two different measures' values, so I made this code to put in the Colour by Expression section:

IF(
    VALUELIST('Availability', 'Availability Aggr.') = 'Availability Aggr.',
    IF(
        [Availability Aggr.] > '99%',
        GREEN(),
        IF(
            [Availability Aggr.] > '89%',
            RGB(255, 165, 0),
            RED()
        )
    ),
    IF(
        VALUELIST('Availability', 'Availability Aggr.') = 'Availability',
        IF(
            [Availability] > '99%',
            GREEN(),
            IF(
                [Availability] > '89%',
                RGB(255, 165, 0),
                RED()
            )
        ),
        BLACK() // Default colour
    )
)

 Unfortunately as you can see, it always takes the default colour. 

I saw in previous posts people suggesting to colour the maste rmeasure by segments within the master measure itself, I tried that but it didn't work as well. 

Can anybody help me solve this ? Thank you!

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  @MarcoWedel

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!