I'm trying to limit the output of a taggregate row to 5 values in a list function:

The current output looks like:

ModuleID | htmlRow

1  |  value1 value2 value3 value4 value5 value6 value7 value8

I want the output to only be 

ModuleID | htmlRow

1  |  value1 value2 value3 value4 value5

 Each ModuleID should have a maximum of 5 htmlRows in the list.

I have a tried a tSamplerow but that limits the amount of ModuleID's.  I don't want to limit the rows going into the taggregaterow, only the rows coming out of the taggregaterow list.

I'm not sure what a taggregatesortedrow does but it doesn't look suitable at first glance.

Can anyone suggest anything I can try?

Thank you.

Hi, 

I'm building a scatter plot and have large values of money on the X-axis. I want to change those values from being $20,000,000,000 to $20B but can't seem to get that to work.

Measure:  Sum({<ModelDiscretionaryAcctFlag={'N'}>} AccountValue)

Number formatting: Money, $#,##0;-$#,##0

Tried using Number formatting: Custom Format: $#,##0.0a

Neither seems to give me what I want. Any thoughts? 

* 

I am getting vulnerabilities on certain components in Package Cache eg libcurl.dll and node.js

I tried to remove them manually from the cache folders but this causes issues when I try to patch next time. While patching it gives error stating missing files, the only way to fix it I have to run repair.

Please let me know what is the right way to get rid of the vulnerable components from the package cache folder.

Hi, we've recently had to enable a HTTPS proxy on our qlik machine, done via the HTTPS_PROXY environmental proxy.

To attempt to control which data doesn't go through the proxy we are utilising NO_PROXY.

Our Kafka endpoint, with the schema registry end point as remained unchanged through out this.

We have however added the schema registry hostname, as well as it's IP, to the NO_PROXY environmental variable.

We have added the environmental variables to the site_arep_login.sh (we only run a single instance) as advised: 

cho "export NO_PROXY=gds,.gds,amazonaws.com,gds-confluent-schema-registry.gds" >>$QLIK_REPLICATE_BASE_DIR/bin/site_arep_login.sh \
    && echo "export no_proxy=gds,.gds,amazonaws.com,gds-confluent-schema-registry.gds" >>$QLIK_REPLICATE_BASE_DIR/bin/site_arep_login.sh \
    && echo "export HTTP_PROXY=\$HTTP_PROXY" >>$QLIK_REPLICATE_BASE_DIR/bin/site_arep_login.sh \
    && echo "export http_proxy=\$HTTP_PROXY" >>$QLIK_REPLICATE_BASE_DIR/bin/site_arep_login.sh \
    && echo "export HTTPS_PROXY=\$HTTPS_PROXY" >>$QLIK_REPLICATE_BASE_DIR/bin/site_arep_login.sh \
    && echo "export https_proxy=\$HTTPS_PROXY" >>$QLIK_REPLICATE_BASE_DIR/bin/site_arep_login.sh \

 And I have confirmed that the pid Qlik is running under has the values.

However, when we start the task it fails with a curl 56 / HTTP code 403, suggesting the data is still going through the proxy.

The COMMUNICATION channel logs also appear to show that NO_PROXY is not picking up our environmental variable, and appears to be hard coded:

00000617: 2026-06-05T11:57:16:761902 [COMMUNICATION   ]V:  CURL DEBUG (TEXT): Uses proxy env variable no_proxy == 'localhost,127.0.0.1'  (at_curl.c:775) 

00000617: 2026-06-05T11:57:16:762203 [COMMUNICATION   ]V:  CURL DEBUG (TEXT): Uses proxy env variable https_proxy == 'http://gblprx.landg.com:80'  (at_curl.c:775)

I've even entirely removed any proxy environmental variables, so no proxy is set anywhere and I still get the line about using proxy env no_proxy with the same values, even though it's not set on the system.

Wondered if anyone else has experienced the same and has a solution? I've tried 2023.11, 2025.11, and 2026.5 - in all of these I've tried setting the proxy inside the qlik app at the server level instead, leaving the environmental variables empty, and then leaving 'use Proxy' unchecked for the Kafka schema registry - but it still ends up picking up the server settings and saying it's using no_proxy with localhost,127.0.0.1

Hi @rubenmarin  i have measure calculated  in script 

sum(cash)   as  cash

now i want to use direct cash field in pivot table  .  its giving me null values.

i tried using

max(cash)

first(Cash)

sum(Cash)

count(cash)

nothing worked any other alternate for this? 

Hi Everyone

I would really love some help in something that I am trying to develop in my qliksense app.

I have attached some sample data. There are 3 different person ID's and each person has filled in two surveys (1 and 2).  Each question 1-4 has a score.  Example person ID 1234646 has answered two surveys with a score of 4 for Q1 in survey 1 and then 3 for Q1 in survey 2.

What I would like to do is take all the distinct PersonID's within my dataset and then when the app is loaded have it open on the first PersonID in the dataset.  I would like two buttons that will allow me when pressed to go to next PersonID in the list or back to the previous PersonID in the list.  I would like the next record button to be enabled until the last record in the list is reached.

For each record that it displayed on the screen I want to be able to show the scores on charts.  This bit I have done by hard coding in an example PersonID so I am thinking that when the button is pressed the value of the PersonID will be passed to a variable which will then be read by the charts and will display accordingly.

The area that I am struggling with is getting the unique PersonID and then looping through each record on a button press.   Any help greatly appreciated.

Hi,

I would like to store the MAX(POINT_IN_TIME) for use elsewhere in the app. I'm working with time series data and often use set analysis like the following to aggregate data for the most recent date only: 

{<POINT_IN_TIME={"$(=max(POINT_IN_TIME))"}>}[# of Members]

I want to do something similar to store the date on its own to hopefully leverage a filter in a table. Right now, the table uses an indicator called EOPD_IND from the data model, which flags if the record is the most recent record in the database. However, I have users that want to filter back to a historical date, say 12/31/2024, and want the record for that data point to show in the table (not the EOPD record). 

I can't simply remove the date filter from the table, either, because the table always needs to be limited to a single POINT_IN_TIME. Any ideas on the best way to achieve this?

Thanks,

Hi everyone,

I'm experiencing an issue with the Straight Table in Qlik Cloud.

I set up my columns in a specific order, but whenever I remove one field, the remaining columns lose their custom order and go back to a different arrangement.

Has anyone else experienced this? Is there a workaround to keep the column order intact after removing a field?

Thanks! 🙂