Users need to be able to paste a list of values from excel and use those values as selections in a field. I have seen examples of this done using variable input and a button with select action.

In my use case, however, only values that contain text characters are being returned. Values that only contain numbers are being ignored in the selection process. 

Here is my current setup:

1. Variable input box to set: vMemberID_Selection

2. Button Action: Select values in a field

3. Button Field: PRIMARY_MEMBER_ID //text field

4. Button Value: =replace(vMemberID_Selection,' ',';') //replace the empty space delimiter from excel with a semi-colon

When I paste the below list from excel, only the first 3 values are returned for PRIMARY_MEMBER_ID. The last two values that only contain numbers are ignored.

PER-12345678;ORG-12345678;EMP-dsvo3sdf6sdfs48fs4;23456789;34567890

I have also tried manually converting the Button Value to text but still experienced the same behavior:

=text(replace(vMemberID_Selection,' ',';'))

=replace(text(vMemberID_Selection),' ',';')

Any ideas what could be causing this issue and how to resolve?

Hi team

I have the following questions:

1.Is it possible to get Relative-Record-Number of AS400 by AR_H_STREAM_POSITION of Qlik Replicate?

2.Is there any header or variable to output Relative-Record-Number other than AR_H_STREAM_POSITION?

I would like a primary response by 2025.4.25.

Hallo zusammen,ich
habe mich für die 30-tägige Testversion von Qlik Sense Business mit meiner geschäftlichen E-Mail registriert. Nach dem Abschluss der Registrierung werde ich jedoch immer zur "Qlik Cloud Analytics Tour" weitergeleitet und sehe keine Option, einen Mandanten zu erstellen oder in die eigentliche Qlik Sense Umgebung zu gelangen.
Wenn ich mich unter https://qlikcloud.com anmelde, erscheint "Keine Mandanten zum Verwalten vorhanden".
Könnt ihr mir helfen, meinen Testzugang korrekt zu aktivieren?
Vielen Dank im Voraus!

Hi All,

I have not much knowledge of Security rule in QMC.

There is one issue I am facing as Rootadmin. I am unable to duplicate the application in my work space.

It is for all applications.

There are two security has been created in QMC for RootAdmin and unable to disable newely created one.

In fact, i am unable to update anything in security rule. suppose i am changing any action under resouce filter, it is not getting updated. like create, Read etc..

May be security rule  is getting overriden. 

Request your suggestion for resolving this issue as none of developer able to duplicate the application.

I am attaching the screenshot for reference.

Thanks in advance!!

Qlik Enterprise Manager 

I have a virtual machine with some Excel (.xls) files saved in a local folder.
I manually upload these files using the Data Manager in Qlik Sense to create an app.

However, when I reload the app, it fetches data from the uploaded file stored under 'Data Files' within Qlik Sense, rather than from the original source file in the local folder.

As a result, any changes made to the original Excel file (or if I replace it with a new version) are not reflected in the app after a reload.

I would like the app to always load the most recent data from the source Excel file in the local folder on the VM.
How can I achieve this?


-I also install Qlik Gateway- Direct access
-Also try to achieve this Using Qlik Data Transfer but not able to achieve

Been working with Qlik for 5 years, never seen this issue before. 

Loading data from a parquet file, all floats are rounded to 2dp when I add them as dimension. If I load the fields as TEXT(Field), the numbers come out ok, if I show them as measures, they are fine. 

What's going on here? How can I fix? There's hundreds of columns being imported that are impacted so I need a general fix, not just for that specific field. 

Thanks a lot 

Hello!

I need to count the number of customers that have made at least one purchase in each of the last three weeks and have that in a chart where Week is the dimension.  I have the following expression, but it is not calculating the correct number and I cannot figure out why.  I was wondering if I needed to switch the order of IF() and AGGR(), or if there was a better way to get this result.

Thank you!

Count(distinct aggr(
    if(
        Count({< [Invoice Date] = {">=$(=date(Max(%DateKey)-20,'MM/DD/YYYY'))<=$(=date(Max(%DateKey)-14,'MM/DD/YYYY'))"} >} DISTINCT [Order Number]) >= 1 and
        Count({< [Invoice Date] = {">=$(=date(Max(%DateKey)-13,'MM/DD/YYYY'))<=$(=date(Max(%DateKey)-7,'MM/DD/YYYY'))"} >} DISTINCT [Order Number]) >= 1 and
        Count({< [Invoice Date] = {">=$(=date(Max(%DateKey)-6,'MM/DD/YYYY'))<=$(=date(Max(%DateKey),'MM/DD/YYYY'))"} >} DISTINCT [Order Number]) >= 1,
        [Customer Number]
    ),
    [Customer Number]
))