Team,

I am new to Qlik and I am struggling on functions e.g. aggr() and count() not sure how to achieve the following?

Data:

1, PERSON1, 4/1/2024

2, PERSON1, 4/3/2024

3, PERSON1, 4/10/2024

4, PERSON2, 4/1/2024

5, PERSON2, 4/2/2024

6, PERSON1, 4/11/2024

Below is the desired output:

Person1: 5 Occurrences in April

Person2: 2 Occurrences in April

Similarly for the other months......

Any help would be appreciated! Thanks in advance 🙂

I'm working on creating a command to silently upgrade PostgreSQL using Qlik PostgreSQL Installer. One of the arguments that are mentioned in Silently installing or upgrading PostgreSQL using the Qlik PostgreSQL Installer documentation is iprange.

Does anyone know IP addresses of which devices in a network should be populated for iprange argument?

I've created two color palettes in my custom theme, and both are functioning well. However, the second palette appears white, making it difficult to locate. How can I adjust it to display the colors like the first palette does? Thanks in advance for your help! 

From UI, it is easy to select all tables.

However, if I manually input a json task file, is there a way to define migrating all tables? Instead of adding a list of tables to "explicit_included_tables"?

I have setup a Full Load Completed notification rule and it works fine for when we do a full reload of the entire task.  However, when just reloading individual tables in the task - no email generates.  Is this by design?  We would like it to notify anytime a full load completes on the table-level and the task level.

Hi,

I have to colour the bars of chart in colour Green (for consumption  less than 850)and the rest of colour of same bar in red (for consumption more than 850).

So for "03 Tankroom" , bar should be both in green(for <=850) and red(1911-850) color. and other two bars should be in Green color.

Could some one let me know how to achieve this?

Thanks in advance

Bonjour,

Est-il possible de personnaliser l'affichage des filtres sélectionnés par l'utilisateur sur une feuille/application Qliksense ? 

Par exemple :

On a un filtre ANNEE contenant 6 valeurs d'années, si on applique le filtre sur 3 années (2019, 2020 et 2021) - ( cf. ANNEE.PNG) au lieu d'avoir le nombre de sélections faites au niveau de l'entête de la feuille (cf. FILTRE_ANNEE.PNG) avoir plutôt le contenu exacte des sélections qui ont été faites comme ça se fait sur Qlikview (cf. QV_FILTRE.PNG) et avoir également la possibilité d'appliquer des couleurs selon les dimensions du filtre.

merci par avance. 

Hi,

I am trying to find a listing of all Named CAL QVW authorization assignments. This would be similar to how we can find the list of each document CAL QVW authorization from the CalData.pgo file (CalData/PerDocumentCalData/PerDocumentCalData). I would like to obtain similar per-document authorization data for the Named CALs and cannot find how to do so.

We have a variety of named user CALs assigned. We use DMS authorization. Some Named CALs are assigned to usernames that are available in a configured QMC directory. Other named CALs are assigned to external usernames that are connected to the Access Point via external SSO.

I know that I can obtain a simple list of the current Named CALs with CalData/NamedCalsAllocated/CalAllocEntry. However, I cannot find a way to query what documents those named CALs are assigned to. I highly suspect that this information is available somewhere because I can find it on the QMC. In the QMC, if I go to the Users tab and search for a given named User, the resulting Documents list will show me all of the documents which that named CAL is authorized. I am essentially trying to obtain this same output from the server files themselves.

The reason I am looking for an external server data source is because I can only query the QMC for users that exist in one of my directories. For external SSO users, they do not appear in the QMC because it can only search by QMC connected directories.

Please let me know if I can clarify anything and thank you in advance for your assistance.

Hi Team,

If the latency is due to high volume of data, then how would you trouble shoot it or what are the optimizations we can perform on it. And what are the data validations scripts we have.  or how we can do the data validations.

Thanks