Wow! Half a year is gone already. Stop! We are not thinking of that… slow down, please. Hello June. Let’s make this the best one yet.

This month we feature a Partner who has earned the ranking of “Master” in the Community. With close to 2k posts, he has provided countless solutions, given and received hundreds of likes. Additionally, this member helps to keep our Community spam free. He is in there regularly, helping others and sharing his expertise! It is with great pleasure to introduce the one and only Ali Hijazi; you may know him as the Qlik_Ster!

Ali has been working with Qlik products since 2011. He started with QlikView and now Qlik Sense. Ali has achieved three certifications from Qlik. He works on many projects for his clients using Qlik solutions. Ali regularly uses the Community to ask questions and looks to see where he can answer other members’ questions. Ali has enjoyed watching the Community evolve and improve over the last few years.

We are lucky to have like-minded people like Ali active in the Qlik Community! So let’s show the Qlik_Ster our appreciation by giving him a “High Five” by hitting that like button and leaving a comment.  Thank you for all you do in the Qlik Community! @ali_hijazi @Melissa_Potvin @Jamie_Gregory @nicole_ulloa 

Hello

Some of my reporting has many null values for metric, string, and date fields. while i know that data type isn't exactly a thing in qlik (blows my mind), but what is best way to handle nulls to do reports on these? I cannot filter by nulls, not can i select rows with nulls. One of my analysts told me qlik told him to mask the fields as 0's for metric and a string that says "Null" for strings. this seems incorrect as well as adding 0's to a data distribution could provide false analysis.

thanks

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.