Hi All

Im using the AGGR and Rank function to create a rank for each output value for that dimension

Aggr(Rank(1-count({<[somefield]={'Osomevaluet'}>}A_number)/count(A_number)),$(vDimValue))

the dimensions can be anything from 3 to 10+ values so currently my rank produces the values (1,2,3.....10+) or however many dimension values exist.

I want the rank to automatically limit the values of rank between 1 to 5  one being lowest output value aggregated over the dimension.. i don't want to fix the value if output between a and b value 1., else 2...... is there a dynamic way to calculate a range of rank -1-5 based on the values for that dimension

any help appreciated

Hello, I'm glad to be a new member in this community.

We are experiencing a problem sending the NPrinting reports.

Years ago we had configured an office365 account to send the reports. Then we started with problems. We executed some tasks but only few were sent or experienced delays.

Then we found another SMTP server on Internet with old TLS and basic authentication and all were fine. Lately we had to find another SMTP server that is the actual.

We want to use office365 again, but I don't know if it's possible or not. We need to avoid delaying problems.

I have seen this topic that I think it's the same problem:

https://community.qlik.com/t5/Qlik-NPrinting/Using-Office-365-with-SMTP-Authentication-in-NPrinting/td-p/1949132

May you help us?

Our NPrinting version is 17.3.1.0

Thanks in advance

Why can't I withdraw CASE from my account? CASE pops up: Trying to access the Support Case Portal? or Downloads page? Connect with an agent now via live chat (click help icon lower right of page)Product issue? Please post a question in one of our many product forums [https://community.qlik.com/t5/Forums/ct-p/Forums] or create a case with Qlik Support [https://community.qlik .com/t5/crmsupport/page]Return to my original page%MCEpastebin%

repctl checkpoint "task name" for downstream task (source: log stream task & target : oracle database) is not giving correct timestamp. 

D:\bin>repctl getcheckpoint "TASK_INGCDC_02"

command getcheckpoint response:

{

        "checkpoint":   "checkpoint:V1#33512#1271;638506460899807820;20240120221751514712#0#0#*#0#137"

}

[getcheckpoint command] Succeeded

Regards

Dipankar

due to find Qlik Sense Enterprise for Windows Remote Code Execution (RCE) Vulnerability (Authenticated). with suggestion we need to install patch 6 to solve this problem. 

After download the patch and run with administrator on server.  System show logs and installation failed.

detail see file attached. 

It is very urgent for me to find a solution.  Any one met same case and solved.

BS

jens

Hi,

I'm hoping someone can assist with this as it hasn't been reported before.

This is happening on a few of our clients, below is one example.

This is a multi-language site that integrates with our system. We have set the default languages on each users profile and set the labels to look for that default. We created the required multi-language file with the the correct references so the labels use that language e.g =Only({<Index={'SC12'}>} [$(=vDataLanguage)]). This particular user is defaulted to English.

We have set the language on Qlik to only display one language (dependant on the user's default). His OS is defaulted to English as well.

Could it possibly have to do with the amount of data affecting the refresh rates? This is happening on a few clients and it only happens when you cycle through the sheets using the labels to navigate between them.

This hasn't been raised with Qlik before, and occurs on the web app and desktop version.

I have a variable set as vCurrentMonth showing 19 which is the Date.Chron.Month value. 

I would like a textbox to display the value for Date.Month.Year (May-2024) through using the vCurrentMonth variable. 

Does anyone have any suggestions on how this may be done? 

Thanks in advance! 

Hello,

We have Qlik Sense Enterprise installed on a Windows VM. Each day of the work week, the VM automatically stop at 19:00. Each morning, we start manually the VM and the Qlik services are set to start automatically when the VM starts. Since the 15/04/2024, when we start the VM, the Qlik services stopped working properly. When the qlik services starts, its make the VM very slow and unnable to access. It takes around 1 hour for the VM to be accessible again. Once the VM is accessible, i'm able to access it and restart properly the Qlik services and then it starts working properly.

I've try starting every Qlik services in different order to identify the one causing the crash and i've found that it is the Qlik Scheduler Service. 

By waiting for the VM to be accessible, we are able to solve the problem but it is not very convenient since we have to wait some time and more than that, we would like to understand why the Qlik services stopped working properly. Before the 15/04/2024, everything was working fine.