I am using Nprinting Designer 19.4.

Currently I am not able to edit the existing Nprinting reports and not able to create new report. When I am trying to work on edit template and saving and doing preview I am getting the old report's preview. The new or edited version are not reflecting. 

I connected with infra team and uninstalled and reinstalled the Nprinting designer in my local machine still the issue persist. Then I upgraded to 2013 version still the issue persist. 

Can anyone help on this? 

The documentation on Prerequisites does not document what versions of MySQL ODBC driver are compatible with the version of Replicate, only mentioning to install v8.0.32. https://help.qlik.com/en-US/replicate/May2023/Content/Global_Common/Content/SharedReplicateHDD/MySQL-Source/prereq-mysql-source.htm

I doubt this is the only version of MySQL that is compatible, but what has been tested for compatability?

As an admin of client-managed Qlik Replicate, I need to know what versions are tested to work with the 2023.5 version, though this request extends to future versions of Replicate as well, as our system will be upgraded at some point.

Is there anything different in formatting numbers in Qliksense vs Qlikview when exporting data to Excel? We noticed that some numbers in Qliksense are not identified as numbers when doing a vlookup after exporting data. I have chart in QS where ItemID (number) is used as dimension. When exported to Excel and validating data against Qlikview, the vlookup returns #N/A, even though Excel does recognize the Qliksense exported data as numbers. Column explanation to chart :

• A: Qliksense exported number
• B: Isnumber function on col A
• C: vLookup to Qlikview numbers (on a separate tab in the same Excel)
• 😧 vLookup using col A * 1 to Qlikview numbers
• E: Value of col A * 1
• F: vLookup of col E to Qlikview
• G: vLookup to Qlikview using numbervalue on col A

Only if i used vLookup with numbervalue, i was able to match numbers properly. This is confusing why some numbers in Qliksense are recognized as numbers while some not.

I noticed that when i click 'enter' on the cells in col A that are not matched, the value is recognized by the vLookup as number and i get a match. 

I am attaching the Excel file here. Anyone has experienced the similar issue?

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 !