A user manually added 2 charts in a report published on the access point, and after adding, we cannot open the report again. I can connect from Open's server, but the report does not open. What can I do, your help is requested.

Buenas, 

no encuentro un modo de hacer una clasificación por cada agente directamente en el script de carga... sería el equivalente a la función de gráfico RowNo(): https://help.qlik.com/es-ES/qlikview/May2022/Subsystems/Client/Content/QV_QlikView/ChartFunctions/InterRecordFunctions/rowno.htm

Me explico, desaría un resultado como éste en el script de carga de datos en una tabla llamada "Ranking ventas":

¿Eso es posible?

La finalidad es obtener una tabla así:

Muchas gracias.

Hi,

We're trying to find a method to reduce the time/effort in app creation for new clients.

one of things we're attempting is connecting to a database via a connection string instead of having to create a connection for each client.

Our initial thought was to set a string variable to hold the database name (they're all kept on the same postgres server, different database name for each client), and to connect by a string that will hold this variable to instruct the script which database to use.

From what i understand this method was available in prior versions using "CONNECT TO" but it isn't available unless we move the server to legacy mode, which may have other undesired implications.

Our Qlik version is the initial 2023 release.

Thanks in advance 🙂

Hi, In Qlikview I'm facing this error . Any one suggest. pls . 

1. Port opening everything was done. 

2. QMC is working fine. 

3. qlikengine and qlikserver added as a administrator. 

4. QlikNprinting is working fine. 

So, I want to learn how to use Qlik Compose I started a Test project following the steps of Qlik Compose tutorial in Qlik help.

Qlik Compose for Data Warehouses tutorial | Qlik Compose for Data Warehouses Help

I used the NorthWind DB while using MS SQL server as a source, and another empty DB as a target to make a DW.

everything went smoothly until I needed to generate ETL statements it does not complete the process.

I don't know what causes this to happen, and I searched everywhere for a solution I could not find anything in regard to this problem.

Hello,

I wonder if anyone has an idea on getting such a table as below but with the total sessions by company along with the single top channel (by company´s sessions).  I use the LIMITATION  FIXED NUMBER = 1 which works but then I ultimately get that Session number for that Channel. And  when I try a TOTAL aggregation for Sessions, I get that desired total number by company name but Top Channel is becoming odd (showing a channel but not the top one)

Thanks a lot for your help!

Hi Fellow Qlikers, 

I need help with getting ranks for my data, the issue is that when a dimension value is having a same rank i.e 4-5, I need to sort that value based on another field, I have tried doing it but it seems to be not working as I am getting 1 as the same rank for all the values. 

Basically the data currently looks like this. 

Expression in Rank 1: 

Aggr

I want to sort the rank 4-5 into 4 & 5 giving [# 175 - Polymer Wax Polish 250 ml] as 4th rank and [# 170 - Wax Shampoo 250 ml] as 5 th rank. 

Meaning that I want them to be sorted on lift if the ranking is coming out to be same and want to show it in the Simple KPI rather than the chart. 

Do let me know if anything further can be provided for understanding the issue.