Hello All,

I'm programming the qlik sense windows upgrade to February 2024.

I found so many documents that explains the steps needed but i need to know if there is any specific issue or tips related these two version ?

Do i have to upgrade the Postgre SQL ?

What are the best steps and tips to do it, in order to back up my existing version?

I lost my certifications passwords, how can i back up them , do i have to recreate them before the upgrade ?

Do i need a test enivrement ?

Noted that i have a multi-node architecture, a central node for production and an other for développement.

I'm loking for your help and your advice.

Thank you.

Hi,

I need  to count distinct rows where aggr Sum is equal or bigger than 10.
I tried use aggr() function in the sheet measures but it doesn't work, so I created 2 flag fields:
* flagA - 1 if total sum by month & ID >= 10
* flagB - 1 if total sum by month & ID & type >= 10.
Now, my problem is to make a distinct count on several fields.

example:

count ID where monthly sum is equal and bigger than 10:
00002, month = 2, sum = 21
00003, month = 2, sum = 22
00002, month = 3, sum = 10
So, the measure should be the count of flagA where flagA=1 and distinct Month&ID, so 3.

count ID where monthly sum by type is equal and bigger than 10:
00002, month = 2, type = a, sum = 12
00003, month = 2, type = a, sum = 11
00003, month = 2, type = b, sum = 11
00002, month = 3, type = a, sum = 10
So, the measure should be the count of flagB where flagB=1 and distinct Month&ID&type,
so when selecting type = a, the result is 3, and when selecting type = b, the result is 1.

Love for some help.
Thanks!

Hi folks,

I want to assign a specific color for each category of [Agent supergroup] in my drilldown master item, much like asked here.

I figured that I could color my graph by expression, with an expression (or, as suggested, an expression stored as a second master item) starting like this

=If(GetSelectedCount([Agent supergroup])<>1,
	Pick(Match([Agent supergroup], 'Hospitals', 'Private laboratories', 'Private practices', 'Other'), '#006580', '#C8C7A9', '#AC4D58', '#99CFCD'), ...)

Without further colors instead of the '...', all subcategories will be colored gray. I guess that I could add more Ifs for [Agent group] and [Agent], but since

• I do not know if the values in the underlying table will change and
• I care only about color consistency across different graphs,

I just want to assign [Agent group] a color by its position in the list of possible values:

Concat({$<[Agent group]=>} DISTINCT [Agent group], ',')​

So I constructed an expression around this to get a color number between 1 and 12 and then added Pick() as follows:

If(GetSelectedCount([Agent group])<>1,
  Pick(Mod(Len(KeepChar(Left(Concat({$<[Agent group]=>} DISTINCT [Agent group], ','), Index(Concat({$<[Agent group]=>} DISTINCT [Agent group], ','), [Agent group])-1), ',')), 12)+1,
    '#006580', '#C8C7A9', '#AC4D58', '#99CFCD', '#E1DAD5', '#83AF9B', '#E0BD8D', '#8A85C6', '#10CFC9', '#A16090', '#87205D', '#C4CFDA'), ... )

(These are the 12 default Qlik Sense colors.)
My test-KPI shows the correct color number, but the categories of [Agent group] in the graph are still one and the same color.

Do you have a hint?

Bonjour, 

J'ai débuté Qlik Sense il y a quelques jours, et après avoir cherché pas mal de temps, je n'ai pas trouvé la réponse à ma question : 

J'ai une table qui contient des champs, et je voudrais que lorsque je clique sur un champ, toute la ligne devient sélectionnée. Sauf que, quand je clique sur cette ligne, il faut que la table reste inchangée, que ça n'affecte pas les autres lignes de celle-ci, mais il ne faut pas que ce soit en "Read-Only" car la ligne sélectionnée d'interagir avec une autre table. 

Merci d'avance pour vos réponses, je reste disponible si vous avez des questions. 😄

When we login to Qlik, we are being asked for our Windows username and password. This didn’t used to happen as we would be logged into the Insight hub automatically? can someone help me on this Many Thanks

Currently I am using Qlik Sense Nov 2022 Patch 12.

Hi guys ( stalwar1‌, hic‌ , petter-s‌ , mto  ..)

I have a problem to load BIG NUMBERS (more than 14,15 and even 17 digits).

In fact, when It's more than 14, Qlik can't seem to recognize the numbers as numbers anymore.

I've tried to surround the field by evaluate when loading it (evaluate(Field) instead of Field)

and this seemed to work at first sight. In fact, the numbers that were imported as Zero are now being well interpreted but then I've found out that there are still some numbers imported as 0 (even bigger numbers) ! So the Evaluate() doesn't seem to work for all the cases...

The question is: how can I import all the numbers (whatever how BIIIIIG they are), and still load them as numbers??)

ps: My source is REST; thus, I'd have to handle things within Qlik.

Thanks !

Hi everyone,

I've created a Job that reads an Excel file and pivots some columns to rows. So far so good.
This is the Excel file:

Even though I'm using a dynamic schema (*) to read the file, I still have to know the real schema of the file so that I can configure the tExtractDynamicFields component correctly:

Then I use the tUnpivotRow component like this (because these columns are always constant):

And I get the desired result:

Thus far all is good.
The problem starts when I start getting Excel files with different schemas (mind you, the first 3 columns are always the same: Name, Surname, City).
(*) This is why I'm using the dynamic schema to read the Excel file.
How do I work with these files? How do I make my Job ready for any Excel that comes with a different schema than the one I'm using in this Job? 

Thank you,
Rui

Hi all,

Sorry for the newbie question. I would like to share a bookmark of a published dashboard so that other users can see my selection directly.

From the explanatory video, I see that after creating the bookmark there should be the option "Copy link" by clicking on the label of the bookmark.

However, in my case, this option does not exist. 

Any suggestion on what I am doing wrong?

Thanks!